Feed aggregator

SQLLOADER - Error Field in data file exceeds maximum length

Tom Kyte - 3 hours 10 min ago
Hi, I am trying to load a data file into a database table using SQL loader. I received the data in an Excel spreadsheet but I saved it as a comma delimited file. When I run the SQL Loader command no records are loaded - looking at the log file I ge...
Categories: DBA Blogs

A Quick Look At What's New In Oracle JET v5.0.0

OTN TechBlog - 10 hours 41 min ago

The newest release of Oracle JET was delivered to the community on April 16th. Continuing the foundational concept of delivering a toolkit on a consistent and predictable release schedule that application developers can rely on. This is the 24th consecutive on-schedule release for Oracle JET.

 

oracle jet logo

This release is primarily a maintenance release, with updates to the underlying open source dependencies where needed, and quite a bit of housekeeping, with removal of previously deprecated API's.  As always, the Release Notes will provide the details and it's highly recommended that you take some time to read through the sections that describe the removed API's.  Most have been under deprecation notice for well over a year.  In some cases API's are being removed that had deprecation notices announced almost 4 years ago.  This will help keep things as clean and lightweight as possible going forward.

visual build call to action button example

One of the first things that you'll probably notice is the Home page now has an option to checkout the new Visual Builder Cloud Service. For those that are more familiar and comfortable with a declarative approach to web development, Visual Builder provides a very comprehensive drag and drop approach to developing JET based applications. If you find yourself in a position where you need to get down to the code while working in Visual Builder, the newest release now provides full code level development as well.  Just hit the Code button and you'll find yourself writing real JET code, with code completion, inline documentation and more. It's the same code that you see in the Cookbook and other sample applications today.

 

New ways to Get Started

The Get Started page has also received a bit of a face lift.  As the JET community continues to grow, there are more developers looking at JET for the first time, and providing multiple ways to get that first experience is important.  You'll now find that you can Get Started by using Visual Builder as described above, or take a quick look at how JET code is structured with a quick sample available on jsFiddle.  Of course the Command Line Interface (ojet-cli) is still the primary method for getting things off the ground with JET.

get started page screenshot

 

Growth and Success

The JET Community continues to grow at a rapid pace and we are proud to have three new Oracle Partners/Customers added to the Success Stories page in this release.  We also added a new Oracle Product which is providing tremendous opportunities for Cloud Startups.  Visit the Success Stories page to learn more about:

 

If you have a JET application, or your company is using JET and you'd like to be included on the JET Success Stories page, please drop a note in the JET Community Forums.

 

A Single Source of Truth for Resource Paths

The Oracle JET Command Line Interface itself has added a few new features in this release.  One of the most notable is the consolidation of resource path definitions into one configuration file.  If you have tried adding 3rd party libraries to a JET application in the past, you found yourself adding the path to those libraries in up to three different files take make sure things worked in both development as well as a production build of the application.  Everything is now in a single file called "path-mappings.json".  Checkout the Migration Chapter of the Developers Guide for details on how to work with this new single source of truth for paths.

path mapping file structure example

 

 

Composite Component Architecture(CCA) continues to mature

Composite Component Architecture(CCA) continues to be a major focus of Oracle JET and each release brings more enhancements to the metadata and structure of the overall Architecture. The best place to keep track of what is happening in CCA development, is on Duncan Mills' Blog series.  The latest installment covers changes made in the JET v5.0.0 release.

 

 

Theming gets an update

Theming has always been a significant feature of JET with the inclusion of SASS (.scss) files for the default Alta theme, themes for Android, iOS, and Windows platforms, as well as a Theme Builder application to help you build your own theme as needed.  In JET v5.0.0 the method for defining the base color scheme as been revised.  Take a look at the Theme Changes section of the Release Notes for details, as well as the Theme Builder example on the JET Website.

 

New task types in oj-Gantt

The Gantt chart has been gaining features over the last few releases, and with this release comes the ability to add new types of tasks such as a Summary and Milestone. Continue to watch this component over future releases as it matures to meet more and more use cases.

 

 

As always your comments and constructive feedback is welcome.  If you have questions, or comments, please engage with the Oracle JET Community in the Discussion Forums, or follow @OracleJET on Twitter

On behalf of the entire JET development team, Happy Coding!!

 

Magic Memories Grows its Business by Capturing Smiles Across the World

Oracle Press Releases - 12 hours 16 min ago
Press Release
Magic Memories Grows its Business by Capturing Smiles Across the World Global tourist experience business accelerates international growth with NetSuite

SUITEWORLD18—LAS VEGAS—Apr 26, 2018

Magic Memories, a business that is revolutionising the guest experience at tourist destinations around the world, has successfully implemented NetSuite OneWorld to support its growth from humble beginnings in Queenstown, New Zealand, to a US$120 million business with a presence at over 170 attractions.

Magic Memories was founded by John Wikstrom and Stuart Norris in 1995 when they saw an opportunity to help travellers capture memories amidst their travels. Wikstrom and Norris realised that not everyone has the talent, skill or equipment to capture high end photographs and video while on vacation and established Magic Memories to provide innovative photography and video products, such as personalised photobooks and shareable digital content. It now partners with some of the most iconic tourist attractions in the world, including Legoland in California, Barcelona Football Club, London Sea Life Aquarium and Warner Bros. Movie World on Australia’s Gold Coast.

Magic Memories has grown from US$30 million in 2015 to US$120 million currently and now operates in ten countries, with approximately 2,500 staff, across its 170 partner attractions around the world. The rapid growth meant Magic Memories needed systems in place that could manage the demands of a sophisticated global business. The business had outgrown its existing management systems, including Xero and manual spreadsheets, and needed an integrated solution that could support operations in multiple countries and across multiple tax systems and currencies.

“Expansion has always been a key aim for Magic Memories, since we first started out and we wanted to be prepared for the future and equip the business with a sophisticated ERP system that could integrate our processes in a single source of truth. Oracle NetSuite gives us exactly that—a future-proof system that expands with us,” said Simon Robinson, acting chief financial officer, Magic Memories. “OneWorld supports our core financial, procurement and supply chain needs and enables us to continue to grow and expand, without operational challenges. When we chose NetSuite as we wanted to build a long-term strategy on a robust system that could grow and scale with the business.”

NetSuite OneWorld has allowed Magic Memories to simplify its reporting processes from days to just hours. These time savings are an added bonus to the flexibility the cloud-based system already provides, which include remote access and its ability to localise the platform to service the region in which it operates. NetSuite’s support for multi-currency, multi-language operations, also means the business remains compliant no matter of its geographic location.

Robinson continued, “we chose NetSuite OneWorld as our ERP system in December 2013 as we were confident that it could meet the needs of our increasingly geographically dispersed business, integrate the whole supply chain and set us up for growth. It’s a system that is well suited to the US$200-500 million company we want to be, as well as the size we were then and are now.”

“It’s been encouraging to see the successful evolution of Magic Memories over the past five years. We’re proud to have played a key role by supporting its growth across multiple regions, and providing Magic Memories with a flexible, global system needed to sustain its global expansion,” said Lee Thompson, group vice president and general manager, Asia Pacific and Japan (APJ) Cloud/ERP at Oracle NetSuite.

Contact Info
Suzanne Myerson
Oracle NetSuite Public Relations
+61 414 101 583
suzanne.myerson@oracle.com
About Magic Memories

Founded in 1995, Magic Memories is the global leader in making people smile. Our Smile Teams are passionate about capturing your once-in-a-lifetime moments at iconic attractions around the globe. We’re always looking for new, innovative ways to help you personalize and commemorate your most exciting experiences. To learn more, visit https://www.magicmemories.com.

About Oracle NetSuite

Oracle NetSuite pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, it provides a suite of cloud-based financials/Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit http://www.netsuite.com.

Follow NetSuite’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Suzanne Myerson

  • +61 414 101 583

Announcing the General Availability of MySQL 8.0

OTN TechBlog - 14 hours 59 min ago

MySQL adds NoSQL and many new enhancements to the world’s most popular open source database:

  1. NoSQL Document Store gives developers the flexibility of developing traditional SQL relational applications and NoSQL, schema-free document database applications.  This eliminates the need for a separate NoSQL document database. 
  2. SQL Window functions, Common Table Expressions, NOWAIT and SKIP LOCKED, Descending Indexes, Grouping, Regular Expressions, Character Sets, Cost Model, and Histograms.
  3. JSON Extended syntax, new functions, improved sorting, and partial updates. With JSON table functions you can use the SQL machinery for JSON data.
  4. GIS Geography support. Spatial Reference Systems (SRS), as well as SRS aware spatial datatypes,  spatial indexes,  and spatial functions.
  5. Reliability DDL statements have become atomic and crash safe, meta-data is stored in a single, transactional data dictionary 
  6. Observability Performance Schema, Information Schema, Invisible Indexes,  Error Logging.
  7. Manageability Persistent Configuration Variables, Undo tablespace management, Restart command, and New DDL.
  8. High Availability InnoDB Cluster delivers an integrated, native, HA solution for your databases.
  9. Security OpenSSL improvements, new default authentication, SQL Roles, breaking up the super privilege, password strength, authorization.
  10. Performance Up to 2x faster than MySQL 5.7.
Developer Features

MySQL 8.0 delivers many new features requested by developers in areas such as SQL, JSON and GIS. Developers also want to be able to store Emojis, thus UTF8MB4 is now the default character set in 8.0.

NoSQL Document Store

MySQL Document Store gives developers maximum flexibility developing traditional SQL relational applications and NoSQL, schema-free document database applications.  This eliminates the need for a separate NoSQL document database.  The MySQL Document Store provides multi-document transaction support and full ACID compliance for schema-less JSON documents.

SQL

Window Functions

MySQL 8.0 delivers SQL window functions in MySQL.   Similar to grouped aggregate functions, window functions perform some calculation on a set of rows, e.g. COUNT or SUM. But where a grouped aggregate collapses this set of rows into a single row, a window function will perform the aggregation for each row in the result set.

Window functions come in two flavors: SQL aggregate functions used as window functions and specialized window functions.

Common Table Expression

MySQL 8.0 delivers [Recursive] Common Table Expressions (CTEs) in MySQL.  Non-recursive CTEs can be explained as “improved derived tables” as it allow the derived table to be referenced more than once. A recursive CTE is a set of rows which is built iteratively: from an initial set of rows, a process derives new rows, which grow the set, and those new rows are fed into the process again, producing more rows, and so on, until the process produces no more rows.

MySQL Workbench Showing MySQL CTE and Windows Functions

MySQL CTE and Window Functions in MySQL Workbench 8.0

NOWAIT and SKIP LOCKED

MySQL 8.0 delivers NOWAIT and SKIP LOCKED alternatives in the SQL locking clause. Normally, when a row is locked due to an UPDATE or a SELECT ... FOR UPDATE, any other transaction will have to wait to access that locked row. In some use cases there is a need to either return immediately if a row is locked or ignore locked rows. A locking clause using NOWAIT will never wait to acquire a row lock. Instead, the query will fail with an error. A locking clause using SKIP LOCKED will never wait to acquire a row lock on the listed tables. Instead, the locked rows are skipped and not read at all.

Descending Indexes

MySQL 8.0 delivers support for indexes in descending order. Values in such an index are arranged in descending order, and we scan it forward. Before 8.0, when a user create a descending index, we created an ascending index and scanned it backwards. One benefit is that forward index scans are faster than backward index scans.

GROUPING

MySQL 8.0  delivers GROUPING(), SQL_FEATURE T433. The GROUPING() function distinguishes super-aggregate rows from regular grouped rows. GROUP BY extensions such as ROLLUP produce super-aggregate rows where the set of all values is represented by null. Using the GROUPING()function, you can distinguish a null representing the set of all values in a super-aggregate row from a NULL in a regular row.

JSON

MySQL 8.0 adds new JSON functions and improves performance for sorting and grouping JSON values.

Extended Syntax for Ranges in JSON path expressions

MySQL 8.0 extends the syntax for ranges in JSON path expressions. For example SELECT JSON_EXTRACT('[1, 2, 3, 4, 5]', '$[1 to 3]');results in [2, 3, 4]. The new syntax introduced is a subset of the SQL standard syntax, described in SQL:2016, 9.39 SQL/JSON path language: syntax and semantics.

JSON Table Functions

MySQL 8.0 adds JSON table functions which enables the use of the SQL machinery for JSON data. JSON_TABLE() creates a relational view of JSON  data. It maps the result of a JSON data evaluation into relational rows and columns. The user can query the result returned by the function as a regular relational table using SQL, e.g. join, project, and aggregate.

JSON Aggregation Functions

MySQL 8.0 adds the aggregation functions JSON_ARRAYAGG() to generate JSON arrays and JSON_OBJECTAGG() to generate JSON objects . This makes it possible to combine JSON documents in multiple rows into a JSON array or a JSON object.

JSON Merge Functions

The JSON_MERGE_PATCH() function implements the semantics of JavaScript (and other scripting languages) specified by RFC7396, i.e. it removes duplicates by precedence of the second document. For example, JSON_MERGE('{"a":1,"b":2 }','{"a":3,"c":4 }'); # returns {"a":3,"b":2,"c":4}.

JSON Improved Sorting

MySQL 8.0 gives better performance for sorting/grouping JSON values by using variable length sort keys. Preliminary benchmarks shows from 1.2 to 18 times improvement in sorting, depending on use case.

JSON Partial Update

MySQL 8.0 adds support for partial update for the JSON_REMOVE()JSON_SET() and JSON_REPLACE() functions.  If only some parts of a JSON document are updated, we want to give information to the handler about what was changed, so that the storage engine and replication don’t need to write the full document.

GIS

MySQL 8.0 delivers geography support. This includes meta-data support for Spatial Reference System (SRS), as well as SRS aware spatial datatypes,  spatial indexes,  and spatial functions.

Character Sets

MySQL 8.0 makes UTF8MB4 the default character set. UTF8MB4 is the dominating character encoding for the web, and this move will make life easier for the vast majority of MySQL users.

Cost Model

Query Optimizer Takes Data Buffering into Account

MySQL 8.0 chooses query plans based on knowledge about whether data resides in-memory or on-disk. This happens automatically, as seen from the end user there is no configuration involved. Historically, the MySQL cost model has assumed data to reside on spinning disks. The cost constants associated with looking up data in-memory and on-disk are now different, thus, the optimizer will choose more optimal access methods for the two cases, based on knowledge of the location of data.

Optimizer Histograms

MySQL 8.0 implements histogram statistics. With Histograms, the user can create statistics on the data distribution for a column in a table, typically done for non-indexed columns, which then will be used by the query optimizer in finding the optimal query plan. The primary use case for histogram statistics is for calculating the selectivity (filter effect) of predicates of the form “COLUMN operator CONSTANT”.

Reliability

Transactional Data Dictionary

MySQL 8.0 increases reliability by ensuring atomic, crash safe DDL, with the transactional data dictionary. With this the user is guaranteed that any DDL statement will either be executed fully or not at all. This is particularly important in a replicated environment, otherwise there can be scenarios where masters and slaves (nodes) get out of sync, causing data-drift.

Observability

Information Schema (speed up)

MySQL 8.0 reimplements Information Schema. In the new implementation the Information Schema tables are simple views on data dictionary tables stored in InnoDB. This is by far more efficient than the old implementation with up to 100 times speedup.

Performance Schema (speed up)

MySQL 8.0 speeds up performance schema queries by adding more than 100 indexes on performance schema tables. 

Manageability

INVISIBLE Indexes

MySQL 8.0 adds the capability of toggling the visibility of an index (visible/invisible). An invisible index is not considered by the optimizer when it makes the query execution plan. However, the index is still maintained in the background so it is cheap to make it visible again. The purpose of this is for a DBA / DevOp to determine whether an index can be dropped or not. If you suspect an index of not being used you first make it invisible, then monitor query performance, and finally remove the index if no query slow down is experienced.

High Availability

MySQL InnoDB Cluster delivers an integrated, native, HA solution for your databases. It tightly integrates MySQL Server with Group Replication, MySQL Router, and MySQL Shell, so you don’t have to rely on external tools, scripts or other components.

Security features

OpenSSL by Default in Community Edition

MySQL 8.0 is unifying on OpenSSL as the default TLS/SSL library for both MySQL Enterprise Edition and MySQL Community Edition. 

SQL roles

MySQL 8.0 implements SQL Roles. A role is a named collection of privileges. The purpose is to simplify the user access right management. One can grant roles to users, grant privileges to roles, create roles, drop roles, and decide what roles are applicable during a session.

Performance

MySQL 8.0 is up to 2x faster than MySQL 5.7.  MySQL 8.0 comes with better performance for Read/Write workloads, IO bound workloads, and high contention “hot spot” workloads.

Scaling Read/Write Workloads

MySQL 8.0 scales well on RW and heavy write workloads. On intensive RW workloads we observe better performance already from 4 concurrent users  and more than 2 times better performance on high loads comparing to MySQL 5.7. We can say that while 5.7 significantly improved scalability for Read Only workloads, 8.0 significantly improves scalability for Read/Write workloads.  The effect is that MySQL improves  hardware utilization (efficiency) for standard server side hardware (like systems with 2 CPU sockets). This improvement is due to re-designing how InnoDB writes to the REDO log. In contrast to the historical implementation where user threads were constantly fighting to log their data changes, in the new REDO log solution user threads are now lock-free, REDO writing and flushing is managed by dedicated background threads, and the whole REDO processing becomes event-driven. 

Utilizing IO Capacity (Fast Storage)

MySQL 8.0 allows users to use every storage device to its full power. For example, testing with Intel Optane flash devices we were able to deliver 1M Point-Select QPS in a fully IO-bound workload.

Better Performance upon High Contention Loads (“hot rows”)

MySQL 8.0 significantly improves the performance for high contention workloads. A high contention workload occurs when multiple transactions are waiting for a lock on the same row in a table,  causing queues of waiting transactions. Many real world workloads are not smooth over for example a day but might have bursts at certain hours. MySQL 8.0 deals much better with such bursts both in terms of transactions per second, mean latency, and 95th percentile latency. The benefit to the end user is better hardware utilization (efficiency) because the system needs less spare capacity and can thus run with a higher average load.

MySQL 8.0 Enterprise Edition

For mission critical applications, MySQL Enterprise Edition provides the following additional capabilities:

  • MySQL Enterprise Backup for full, incremental and partial backups, Point-in-Time Recovery and backup compression.
  • MySQL Enterprise High Availability for integrated, native, HA with InnoDB Cluster.
  • MySQL Enterprise Transparent Data Encryption (TDE) for data-at-rest encryption.
  • MySQL Enterprise Encryption for encryption, key generation, digital signatures and other cryptographic features.
  • MySQL Enterprise Authentication for integration with existing security infrastructures including PAM and Windows Active Directory.
  • MySQL Enterprise Firewall for real-time protection against database specific attacks, such as an SQL Injection.
  • MySQL Enterprise Audit for adding policy-based auditing compliance to new and existing applications.
  • MySQL Enterprise Monitor for managing your database infrastructure.
  • Oracle Enterprise Manager for monitoring MySQL databases from existing OEM implementations.
MySQL Cloud Service

Oracle MySQL Cloud Service is built on MySQL Enterprise Edition and powered by Oracle Cloud, providing an enterprise-grade MySQL database service. It delivers the best in class management tools, self service provisioning, elastic scalability and multi-layer security.

Resources

Europe June 2018 Seminars: Confirmed Venues for Oslo, Munich and Zürich

Richard Foote - 22 hours 34 min ago
I’m very excited to confirm all venues for the European June 2018 dates of my popular “Oracle Indexing Internals and Best Practices” seminar. This is a must attend seminar of benefit to not only DBAs, but also to Developers, Solution Architects and anyone else interested in designing, developing or maintaining high performance Oracle-based applications. It’s […]
Categories: DBA Blogs

Deploying PostgreSQL in MiniShift/OpenShift

Yann Neuhaus - 23 hours 10 min ago

The last post quickly outlined on how you can setup MiniShift for playing around with OpenShift on your workstation. In this post we’ll setup PostgreSQL in MiniShift using the default PostgreSQL image that already comes with MiniShift.

When MiniShift is currently stopped start it up:

dwe@box:~$ minishift start
dwe@box:~$ eval $(minishift oc-env)
dwe@box:~$ which oc
/home/dwe/.minishift/cache/oc/v3.9.0/linux/oc

With OpenShift everything is organized into projects and the first thing you need to do is to create a project. You can either do that using the command line or the web interface. Doing it using the command line is quite simple and fast. The first step is to login to OpenShift:

dwe@box:~$ oc login
Authentication required for https://192.168.99.100:8443 (openshift)
Username: system
Password: 
Login successful.

You don't have any projects. You can try to create a new project, by running

    oc new-project 

The output of the login command already tells what you need to do to create a new project:

dwe@box:~$ oc new-project postgres
Now using project "postgres" on server "https://192.168.99.100:8443".

You can add applications to this project with the 'new-app' command. For example, try:

    oc new-app centos/ruby-22-centos7~https://github.com/openshift/ruby-ex.git

to build a new example application in Ruby.

Doing the same with the web interface of course needs more time:

Selection_043
Selection_044
Selection_045Selection_046

To get a list of available images from the command line:

dwe@box:~$ oc get imagestreams --namespace openshift
NAME             DOCKER REPO                                TAGS                           UPDATED
dotnet           172.30.1.1:5000/openshift/dotnet           2.0,latest                     4 hours ago
dotnet-runtime   172.30.1.1:5000/openshift/dotnet-runtime   2.0,latest                     4 hours ago
httpd            172.30.1.1:5000/openshift/httpd            2.4,latest                     4 hours ago
jenkins          172.30.1.1:5000/openshift/jenkins          1,2,latest                     4 hours ago
mariadb          172.30.1.1:5000/openshift/mariadb          10.1,10.2,latest               4 hours ago
mongodb          172.30.1.1:5000/openshift/mongodb          2.4,2.6,3.2 + 2 more...        4 hours ago
mysql            172.30.1.1:5000/openshift/mysql            5.5,5.6,5.7 + 1 more...        4 hours ago
nginx            172.30.1.1:5000/openshift/nginx            1.10,1.12,1.8 + 1 more...      4 hours ago
nodejs           172.30.1.1:5000/openshift/nodejs           8,latest,0.10 + 2 more...      4 hours ago
perl             172.30.1.1:5000/openshift/perl             5.24,latest,5.16 + 1 more...   4 hours ago
php              172.30.1.1:5000/openshift/php              5.5,5.6,7.0 + 2 more...        4 hours ago
postgresql       172.30.1.1:5000/openshift/postgresql       9.2,9.4,9.5 + 2 more...        4 hours ago
python           172.30.1.1:5000/openshift/python           3.3,3.4,3.5 + 3 more...        4 hours ago
redis            172.30.1.1:5000/openshift/redis            3.2,latest                     4 hours ago
ruby             172.30.1.1:5000/openshift/ruby             2.0,2.2,2.3 + 2 more...        4 hours ago
wildfly          172.30.1.1:5000/openshift/wildfly          10.1,8.1,9.0 + 2 more...       4 hours ago

Quite a few to choose from but we of course are interested in the postgresql one.

dwe@box:~$ oc new-app -e POSTGRESQL_USER=blubb -e POSTGRESQL_PASSWORD=blubb -e POSTGRESQL_DATABASE=blubb postgresql

Checking the logs is always a good idea. For this we need to know the pod:

dwe@box:~$ oc get pods
NAME                 READY     STATUS    RESTARTS   AGE
postgresql-1-8n85h   1/1       Running   0          5m

Now that we know the pod we can ask for the logs:

dwe@box:~$ oc logs postgresql-1-8n85h
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /var/lib/pgsql/data/userdata ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

Success. You can now start the database server using:

    pg_ctl -D /var/lib/pgsql/data/userdata -l logfile start


WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
waiting for server to start....LOG:  redirecting log output to logging collector process
HINT:  Future log output will appear in directory "pg_log".
 done
server started
=> sourcing /usr/share/container-scripts/postgresql/start/set_passwords.sh ...
ALTER ROLE
waiting for server to shut down.... done
server stopped
Starting server...
LOG:  redirecting log output to logging collector process
HINT:  Future log output will appear in directory "pg_log".

Looks good so far. How can we work with the PostgreSQL instance now? One way is to start a remote shell:

dwe@box:~$ oc rsh postgresql-1-8n85h
sh-4.2$ ps -ef
UID        PID  PPID  C STIME TTY          TIME CMD
1000100+     1     0  0 13:29 ?        00:00:00 postgres
1000100+    57     1  0 13:29 ?        00:00:00 postgres: logger process  
1000100+    59     1  0 13:29 ?        00:00:00 postgres: checkpointer process  
1000100+    60     1  0 13:29 ?        00:00:00 postgres: writer process  
1000100+    61     1  0 13:29 ?        00:00:00 postgres: wal writer process  
1000100+    62     1  0 13:29 ?        00:00:00 postgres: autovacuum launcher pr
1000100+    63     1  0 13:29 ?        00:00:00 postgres: stats collector proces
1000100+    85     0  0 13:46 ?        00:00:00 /bin/sh

sh-4.2$ psql -c "\l"
                                 List of databases
   Name    |  Owner   | Encoding |  Collate   |   Ctype    |   Access privileges
   
-----------+----------+----------+------------+------------+--------------------
---
 blubb     | blubb    | UTF8     | en_US.utf8 | en_US.utf8 | 
 postgres  | postgres | UTF8     | en_US.utf8 | en_US.utf8 | 
 template0 | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres        
  +
           |          |          |            |            | postgres=CTc/postgr
es
 template1 | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres        
  +
           |          |          |            |            | postgres=CTc/postgr
es
(4 rows)

This is usually not what you want to do. What you rather want is to make the instance available from outside the cluster. How can you do that? Either you do port forwarding:

dwe@box:~$ oc port-forward postgresql-1-8n85h 5432
Forwarding from 127.0.0.1:5432 -> 5432

This will stay in the foreground. From another session you can use psql to connect:

dwe@box:~$ psql -h localhost -U blubb blubb
psql (9.5.12, server 9.6.5)
WARNING: psql major version 9.5, server major version 9.6.
         Some psql features might not work.
Type "help" for help.

blubb=> 

… or you can expose a service:

dwe@box:~$ oc expose dc postgresql --type=LoadBalancer --name=mpostgresql-ingress
service "mpostgresql-ingress" exposed
dwe@box:~$ oc get svc
NAME                  TYPE           CLUSTER-IP     EXTERNAL-IP                     PORT(S)          AGE
mpostgresql-ingress   LoadBalancer   172.30.15.98   172.29.104.134,172.29.104.134   5432:31734/TCP   38s

From now on you can connect using the MiniShift IP and the port listed above:

dwe@box:~$ psql -h $(minishift ip) -p 31734 -U blubb
Password for user blubb: 
psql (9.5.12, server 9.6.5)
WARNING: psql major version 9.5, server major version 9.6.
         Some psql features might not work.
Type "help" for help.

blubb=> \l
                                 List of databases
   Name    |  Owner   | Encoding |  Collate   |   Ctype    |   Access privileges   
-----------+----------+----------+------------+------------+-----------------------
 blubb     | blubb    | UTF8     | en_US.utf8 | en_US.utf8 | 
 postgres  | postgres | UTF8     | en_US.utf8 | en_US.utf8 | 
 template0 | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres          +
           |          |          |            |            | postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres          +
           |          |          |            |            | postgres=CTc/postgres
(4 rows)

blubb=> 

Be aware that the storage is not persistent in that case and you’ll lose everything when the container is stopped. In the next post we’ll look into how we can deploy the containers which are provided by EnterpriseDB.

 

Cet article Deploying PostgreSQL in MiniShift/OpenShift est apparu en premier sur Blog dbi services.

ODPI-C 2.3.1 is now on GitHub

Christopher Jones - Wed, 2018-04-25 17:36
ODPI-C logo

Release 2.3.1 of Oracle Database Programming Interface for C (ODPI-C) is now available on GitHub

ODPI-C is an open source library of C code that simplifies access to Oracle Database for applications written in C or C++.

 

 

Today a minor patch update release of ODPI-C was pushed to GitHub. Check the Release Notes for details on the handful of fixes that landed.

ODPI-C References

Home page: https://oracle.github.io/odpi/

Code: https://github.com/oracle/odpi

Documentation: https://oracle.github.io/odpi/doc/index.html

Release Notes: https://oracle.github.io/odpi/doc/releasenotes.html

Installation Instructions: oracle.github.io/odpi/doc/installation.html

Report issues and discuss: https://github.com/oracle/odpi/issues

Oracle Fusion Middleware Infrastructure 12.2.1.2.0 – Probable Incorrect Firewall Configuration

Yann Neuhaus - Wed, 2018-04-25 15:14

It was a long time that I wrote my last blog. Lots of customer activities and I had no time to write one. With the acquired knowledges, it’s time to write more blogs and share knowledge, don’t you think ?

Let’s begin with an easy one. During customer activity when upgrading a complex Fusion Middleware Platform, it was asked to us to provide support during a move to a secure zone. I can’t tell you what’s really behind the secure zone, probably a more protected and more restricted network with more firewall restriction, don’t ask I have no idea but we unfortunately had an issue. Before that move, I was quite confident as it was informed that it’s only impacting the current IP address. No stress as all the Fusion Middleware Component configuration were using a network alias leveraging the impact of any network changes that could happen. So as a sample for this blog post, the WebLogic instances listen addresses was set with the network alias “dbi-cust-1983.dbi-services.com” pointing to the real hostname in the DNS “vmtestdbiofm01.dbi-services.com”. The NodeManager was set the same for the configured machine. Please see some screenshot to help to understand the configuration we had.

WebLogic Admin Server Listen Address

ofm-wls-firewall-AdminServer-ListenAddress

NodeManager machine Listen Address

ofm-wls-firewall-NM-ListenAddress

NodeManager Listen Address

weblogic@:/home/weblogic/ [dbiOFMHDV] cd $DOMAIN_HOME
weblogic@:/data/weblogic/config/domains/dbiOFMHDV/ [dbiOFMHDV] find ./ -name nodemanager.properties
./nodemanager/nodemanager.properties
weblogic@:/data/weblogic/config/domains/dbiOFMHDV/ [dbiOFMHDV] cat nodemanager/nodemanager.properties | grep ListenAddress
ListenAddress=dbi-cust-1983.dbi-services.com

Let’s also add that the network naming resolution for the Middleware Components was also done through the DNS and the local naming resolution (/etc/hosts) wasn’t containing the real host nor the DNS alias used.

weblogic@:/data/weblogic/config/domains/dbiOFMHDV/ [dbiOFMHDV] cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

So the operation began, we shutdown all the Middleware and Database Components, the Network and Unix Team worked on their tasks (IP changes, DNS correlated changes, forcing changes propagation over the network, aso). Once they completed and once we confirmed that Network Config change have been properly applied (ifconfig, ping, nslookup), we started the platform again without any changes from the Middleware part. Application team performed smoke testing and there was no functional impact.

After reviewing the logs for any error, I found an Error with the RJVM module as follow

####<Apr 16, 2018, 11:08:06,438 AM CEST> <Error> <RJVM> <vmtestdbiofm01.dbi-services.com> <AdminServer> <ExecuteThread: '0' for queue: 'weblogic.socket.Muxer'> <<WLS Kernel>> <> <d41ced14-a5e8-4ef9-bd90-19f63910849d-00000059> <1523869686438> <[severity-value: 8] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000572> <The server rejected a connection attempt JVMMessage from: '3739718027889105070S:dbi-cust-1983.dbi-services.com:[-1,-1,9001,9001,-1,-1,-1]:dbiOFMHDV:WLS_FORMS' to: '0B:10.32.0.12:[8443,-1,-1,-1,-1,-1,-1]' cmd: 'CMD_IDENTIFY_REQUEST', QOS: '101', responseId: '-1', invokableId: '-1', flags: 'JVMIDs Sent, TX Context Not Sent, 0x1', abbrev offset: '183' probably due to an incorrect firewall configuration or administrative command.>
####<Apr 16, 2018, 11:08:55,371 AM CEST> <Error> <RJVM> <vmtestdbiofm01.dbi-services.com> <AdminServer> <ExecuteThread: '3' for queue: 'weblogic.socket.Muxer'> <<WLS Kernel>> <> <d41ced14-a5e8-4ef9-bd90-19f63910849d-0000005d> <1523869735371> <[severity-value: 8] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000572> <The server rejected a connection attempt JVMMessage from: '-2190410908851642855S:dbi-cust-1983.dbi-services.com:[-1,-1,9002,9002,-1,-1,-1]:dbiOFMHDV:WLS_REPORTS' to: '0B:10.32.0.12:[8443,-1,-1,-1,-1,-1,-1]' cmd: 'CMD_IDENTIFY_REQUEST', QOS: '101', responseId: '-1', invokableId: '-1', flags: 'JVMIDs Sent, TX Context Not Sent, 0x1', abbrev offset: '183' probably due to an incorrect firewall configuration or administrative command.>
####<Apr 16, 2018, 11:09:06,509 AM CEST> <Error> <RJVM> <vmtestdbiofm01.dbi-services.com> <AdminServer> <ExecuteThread: '2' for queue: 'weblogic.socket.Muxer'> <<WLS Kernel>> <> <d41ced14-a5e8-4ef9-bd90-19f63910849d-0000005e> <1523869746509> <[severity-value: 8] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000572> <The server rejected a connection attempt JVMMessage from: '3739718027889105070S:dbi-cust-1983.dbi-services.com:[-1,-1,9001,9001,-1,-1,-1]:dbiOFMHDV:WLS_FORMS' to: '0B:10.32.0.12:[8443,-1,-1,-1,-1,-1,-1]' cmd: 'CMD_IDENTIFY_REQUEST', QOS: '101', responseId: '-1', invokableId: '-1', flags: 'JVMIDs Sent, TX Context Not Sent, 0x1', abbrev offset: '183' probably due to an incorrect firewall configuration or administrative command.>
####<Apr 16, 2018, 11:09:59,162 AM CEST> <Error> <RJVM> <vmtestdbiofm01.dbi-services.com> <AdminServer> <ExecuteThread: '0' for queue: 'weblogic.socket.Muxer'> <<WLS Kernel>> <> <d41ced14-a5e8-4ef9-bd90-19f63910849d-00000059> <1523869799162> <[severity-value: 8] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000572> <The server rejected a connection attempt JVMMessage from: '-2190410908851642855S:dbi-cust-1983.dbi-services.com:[-1,-1,9002,9002,-1,-1,-1]:dbiOFMHDV:WLS_REPORTS' to: '0B:10.32.0.12:[8443,-1,-1,-1,-1,-1,-1]' cmd: 'CMD_IDENTIFY_REQUEST', QOS: '101', responseId: '-1', invokableId: '-1', flags: 'JVMIDs Sent, TX Context Not Sent, 0x1', abbrev offset: '183' probably due to an incorrect firewall configuration or administrative command.>

Facing this issue, I ask colleagues for any recommendation or finding to solve the issue ASAP. They recommended to have a look on the cluster configuration for any broadcasting messaging mode, the default cluster configuration messaging mode of my Middleware component was unicast.

WebLogic Server – Default Forms & Reports Cluster configuration

ofm-wls-firewall-Cluster-ListUnicast

Let’s check the BEA error code to continue the investigation.

The BEA-00572 error description

ofm-wls-firewall-BEA-ErrorDescription

The message is quite clear “The server rejected a connection attempt JVMMessage From …” As said before, all the Fusion Middleware was properly started and the functional tests shown that there was no impact at all. It’s always recommended to find a solution to remove such kind of error message. After some research on the MOS, I found a document “Doc ID 860340.1″ applicable the WebLogic Server since the version 7.0. It clearly described that this issue was not reported, nor tested on more recent WebLogic Server version 10.3 or 12c version. I was not really confident with this Oracle Support Note but I tested in case of and I was surprised.

The provided solution by Oracle work very well on my case, I append the  JAVA Option with the flag “-Dweblogic.rjvm.enableprotocolswitch=true” in the setUserOverrides.sh script located under the $DOMAIN_HOME/bin.

export JAVA_OPTIONS="${JAVA_OPTIONS} -Ddomain.home=/u02/weblogic/config/domains/dbiOFMHDV -Dweblogic.nodemanager.ServiceEnabled=true -Dweblogic.security.SSL.minimumProtocolVersion=TLSv1.2 -Dweblogic.security.disableNullCipher=true -Djava.security.egd=file:///dev/./urandom -Dweblogic.rjvm.enableprotocolswitch=true"

After this change and after having restarted the whole domain, there error was gone. No more probable Firewall Configuration Error.

Hope this will help other people that will have to move a Fusion Middleware 12c Platform into a secure zone.

 

Cet article Oracle Fusion Middleware Infrastructure 12.2.1.2.0 – Probable Incorrect Firewall Configuration est apparu en premier sur Blog dbi services.

Alex’s Lemonade Stand Foundation Continues One Girl’s Fight Against Childhood Cancer

Oracle Press Releases - Wed, 2018-04-25 11:30
Press Release
Alex’s Lemonade Stand Foundation Continues One Girl’s Fight Against Childhood Cancer NetSuite Enables Nonprofit to Focus on What’s Important as it Undergoes Rapid Growth, Extends its Mission to Research

SUITEWORLD18—LAS VEGAS—Apr 25, 2018

Alex’s Lemonade Stand Foundation (ALSF), a national foundation dedicated to raising funds for research into new treatments and cures for all children battling cancer, has selected NetSuite to optimize its financial, donor relations and marketing programs. With NetSuite, the Foundation can increase efficiencies, support its growth and focus on its mission while expanding into new areas such as data-driven research.

Established in 2004, Alex’s Lemonade Stand Foundation is focused on changing the lives of children with cancer through funding impactful research, raising awareness, supporting families, and empowering everyone to help cure childhood cancer. Inspired by Alexandra Scott’s personal battle with neuroblastoma, a childhood form of cancer, and her initial lemonade stand that she opened when she was just four years old, the foundation has raised more than $150 million. To manage its growth, grant distribution, an expanding range of fund raising events, and keep administration costs low to make sure donors’ money is going to the mission, Alex’s Lemonade Stand Foundation selected NetSuite.

“We’re focused on continuing Alex’s fight to bring an end to childhood cancer and support the many families and medical professionals involved in that struggle,” said Liz Scott, Alex’s mother and co-executive director of the Foundation. “As we continue to expand into research of our own, we needed a system that could support our growth and help us better manage our operations. NetSuite was the answer.”

With NetSuite, Alex’s Lemonade Stand Foundation has been able to streamline financial management and marketing. By eliminating previously manual and time-consuming processes, NetSuite has enabled the Foundation to focus on its mission and launch new initiatives, including the way the funds are dispersed. Since 2005, the Foundation has funded more than 800 research projects at 135 hospitals and since 2008, it has also provided support for families that are forced to travel get cancer treatments. In 2017, Alex’s Lemonade Stand Foundation created the Childhood Cancer Data Lab. It has built out a team of data scientists, engineers and designers to create an informatics lab using publicly available sources to make cancer data and analysis widely available, easily mineable and broadly reusable.

“Alex’s Lemonade Stand Foundation is truly inspirational and has shown just how far one person’s vision can reach,” said Evan Goldberg, executive vice president of development, Oracle NetSuite. “We’re thrilled to support nonprofits like ALSF and are happy that we are able to provide the tools they need to focus on the things that will advance their mission.”

NetSuite will host its own lemonade stand at SuiteWorld18. Attendees can make greeting cards for children undergoing treatment, learn about their inspirational stories and are encouraged to share their experience via social media using the hashtags #GiveBack2Alex and #SuiteWorld18. For 2,000 posts, NetSuite will donate $5,000 to Alex’s Lemonade Stand Foundation and for 3,000 posts, NetSuite will donate $10,000 to help find a cure.

Contact Info
Michael Robinson
Oracle NetSuite Corporate Communications
781-974-9401
michael.s.robinson@oracle.com
About Alex’s Lemonade Stand Foundation

Alex's Lemonade Stand Foundation (ALSF) emerged from the front yard lemonade stand of cancer patient Alexandra “Alex” Scott (1996-2004). In 2000, 4-year-old Alex announced that she wanted to hold a lemonade stand to raise money to help find a cure for all children with cancer. Since Alex held that first stand, the Foundation bearing her name has evolved into a national fundraising movement, complete with thousands of supporters across the country carrying on her legacy of hope. To date, Alex’s Lemonade Stand Foundation, a registered 501(c)3 charity, has raised more than $150 million toward fulfilling Alex’s dream of finding a cure, funding over 800 pediatric cancer research projects nationally. In addition, ALSF provides support to families affected by childhood cancer through programs such as Travel For Care and SuperSibs. For more information on Alex’s Lemonade Stand Foundation, visit AlexsLemonade.org.

About Oracle NetSuite

Oracle NetSuite pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, it provides a suite of cloud-based financials/Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries.

For more information, please visit http://www.netsuite.com.

Follow NetSuite’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Michael Robinson

  • 781-974-9401

VIVOBAREFOOT Makes Giant Strides in Transforming the Footwear Industry

Oracle Press Releases - Wed, 2018-04-25 11:15
Press Release
VIVOBAREFOOT Makes Giant Strides in Transforming the Footwear Industry Leading London-based Barefoot Shoe Company Turns to NetSuite to Support Growth and Shift in Focus to Ecommerce

SUITEWORLD18—LAS VEGAS—Apr 25, 2018

VIVOBAREFOOT, a global barefoot shoe company, has selected Oracle NetSuite to support its transition to an ecommerce business model and its ambitious plans for international growth that include a goal to reach £100 million within the next five years. With NetSuite, VIVOBAREFOOT will be able to eliminate the complexity of its previous systems so that it can quickly and easily monitor and act on critical business data.

Galahad Clark, a 7th generation descendent of the Clark Shoes company founded VIVOBAREFOOT with his cousin Asher Clark in 2012. Their mission is to change the footwear industry based on one simple insight—shoes should let your feet do their natural thing. Every shoe features a patented, ultra-thin, puncture-resistant sole that protects the foot and allows maximum sensory feedback.

To accelerate its growth, VIVOBAREFOOT decided to increasingly focus on ecommerce and delivering great customer experiences and has gone from selling 6,000 pairs of shoes online in 2012 to 120,000 pairs in 2017. In order to manage this growth, support its transition to an ecommerce business and maintain control over its brand and customer experience, VIVOBAREFOOT implemented NetSuite.

“NetSuite is the perfect complement to VIVOBAREFOOT’s omnichannel approach, allowing us to sell through multiple channels and preparing us for the growth we expect over the coming years,” said Damian Peat, Operations Director at VIVOBAREFOOT.

With NetSuite, VIVOBAREFOOT is able to track and manage inventory of the roughly 100 different lines of shoes it produces each year across manufacturing facilities in Portugal, China and Ethiopia. In addition, VIVOBAREFOOT can track financials across its London store, online and franchises in Europe. By unifying inventory, orders and financials on one platform, VIVOBAREFOOT is able to eliminate the complexity of its legacy systems from Prima, Sage 50 and Divendo and focus on continuing to innovate in footwear. For example, VIVOBAREFOOT recently added a vegan line of shoes, an Internet of Things-based smart shoe and an amphibious adventure shoe that features a foam sole made from algae blooms, not only ending the reliance on petrochemicals traditionally used in shoes, but also removing harmful freshwater algae.

“Innovative, fast-growing companies like VIVOBAREFOOT that recognize a new market and capitalize on it quickly are exactly the types of businesses NetSuite has been supporting for nearly two decades,” said Mark Woodhams, vice president EMEA, Oracle NetSuite. “The innovation, intelligent leadership, and drive are what make VIVOBAREFOOT special. By helping them meet their customers’ expectations and expand into new markets we are fulfilling our mission of helping our customer grow today and beyond.”

Contact Info
Michael Robinson
Oracle NetSuite Corporate Communications
781-974-9401
michael.s.robinson@oracle.com
About VIVOBAREFOOT

VIVOBAREFOOT launched in 2012 as a standalone brand, and is based in London, England. VIVOBAREFOOT is on a mission to change the footwear industry based on one simple insight—shoes should let your feet do their natural thing. The shoes feature a patented, ultra-thin, puncture-resistant sole in every shoe that protects the foot and allows maximum sensory feedback. Designed using ancient wisdom with modern technology VIVOBAREFOOT is a complete shoe collection for off road, exercise and everyday wear, as well as a line for kids. Created by two cousins from a long line of cobblers, Galahad and Asher Clark are on a quest to make the perfect shoe—perfect for feet. VIVOBAREFOOT footwear is produced sustainably using recycled, locally sourced materials in independently monitored factories. For more information on VIVOBAREFOOT, visit www.vivobarefoot.com.

About Oracle NetSuite

Oracle NetSuite pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, it provides a suite of cloud-based financials/Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries.

For more information, please visit http://www.netsuite.com.

Follow NetSuite’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Michael Robinson

  • 781-974-9401

Loot Crate Achieves Explosive Growth on NetSuite

Oracle Press Releases - Wed, 2018-04-25 11:00
Press Release
Loot Crate Achieves Explosive Growth on NetSuite Innovator in Subscription Fandom Finds Flexibility and Success Through Collaboration with NetSuite

SUITEWORLD18—LAS VEGAS—Apr 25, 2018

Loot Crate, the worldwide leader in fan subscription boxes, has implemented NetSuite to manage the rapid growth its undergone in just five years. With NetSuite, Loot Crate has a unified and flexible platform to scale with its growth and handle the complex requirements of its business model.

Ranked #1 on the 2016 Inc. 5,000, and named the fastest growing company in the U.S., Loot Crate is a fan commerce and subscription business delivering themed crates to the world’s most passionate fans. By partnering with more than 250 licensors in sports, entertainment, anime and video games, Loot Crates offer exclusive collectors’ items, from apparel to unique fan experiences to action figures. Loot Crate has delivered over 14 million crates to subscribers in 35 territories globally since it was launched in 2012. To manage the increasing business complexity presented by rapid subscription growth-two warehouses, more than 5,000 active SKUs, and in-house kitting and assembly-Loot Crate selected NetSuite.

“Our success has been built on a unique business model that pairs fandom with the customer experience,” said Erich Gazaui, CIO at Loot Crate.  “Our customers, called Looters, can subscribe to a crate that specifically speaks to their fandom, but they won’t know what items are going to be included until the crate arrives. This creates anticipation, surprise and excitement and has enabled us to create a tight knit community that is rapidly growing. With our high volume of transactions and revenue model, getting the right systems in place was critical to our continued growth.”

NetSuite has provided Loot Crate with the flexibility and scalability required to support its business model, which is based on recurring billing, similar to a software company where payment is time-based rather than fulfillment-based. With NetSuite, Loot Crate is able to manage over 70,000 transactions for fulfillment each day while modernizing and streamlining financials, order management, inventory management, customer relationship management (CRM) and business intelligence systems.

To further streamline business operations and enhance the experience it offers to customers, Loot Crate took advantage of the agility and flexibility offered by NetSuite’s SuiteCloud Development Platform to build a custom tool - The LC Assortment Planner’ - to identify the optimal products to include in each crate and gain real-time insights into business operations. This includes how target unit costs are affected, product weight thresholds for shipping, the ability to update order quantities as sales forecasts change, and a built-in SKU encoder that automates the creation of SKU IDs at the item level.

“Loot Crate’s unique approach to merchandise for fans all over the world and the growth the company has achieved in such a short time is a testament to innovative thinking and execution,” said Jim McGeever, executive vice president, Oracle NetSuite. “With NetSuite helping to manage its operations and automating cumbersome tasks, Loot Crate and other businesses like it can focus on the things that drive growth.”

Contact Info
Michael Robinson
Oracle NetSuite Corporate Communications
781-974-9401
michael.s.robinson@oracle.com
About Loot Crate

Founded in 2012, Loot Crate™ is a leading subscription commerce platform targeting super fans of entertainment franchises. Loot Crate partners with major studios, game companies, comics publishers, professional sports leagues and personalities in the shared curation of premium and exclusive consumer products in themed mystery boxes, delivered directly to subscribers’ doorsteps. Loot Crate was ranked #1 fastest-growing private company by Inc. magazine’s Inc. 5000 as well as #1 on Deloitte’s Fast 500 list for 2016. For more information and to sign up for a Loot Crate subscription, please visit www.lootcrate.com and for sports subscriptions please see www.sportscrate.com.

About Oracle NetSuite

Oracle NetSuite pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, it provides a suite of cloud-based financials/Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries.

For more information, please visit http://www.netsuite.com.

Follow NetSuite’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Michael Robinson

  • 781-974-9401

A Simple, Straightforward Method to Update Content on WebCenter-Based Portal Pages

In our experience working with numerous WebCenter Portal customers, almost all of whom suffered from failed portal/intranet implementations, this difficulty to update and quickly edit page content always lead to stagnant content throughout the portal. This stagnant content made the portal less sticky and therefore the organization didn’t realize widespread adoption.

The difficulty to add and update content was magnified by the fact that in most cases, portal page updates were performed by system administrators. As you can imagine especially in a large organization, the ability for a few admins making page updates across human resources, finance, marketing, and IT departments would cause bottlenecks and it would be days or weeks before the various business groups would see their new content on the portal. Because the business groups really couldn’t take ownership of the content on the portal, less and less changes or updates would be requested.

To make it easier for customers to update their portals and ultimately realize distributed content authoring, Fishbowl Solutions released its Portal Solution Accelerator (PSA) framework in 2012 which included a profile-driven process to make page updates. Today, one of the most desirable and usable features of Fishbowl’s Portal Solution Accelerator (PSA) is the inline editor. This feature enables portal users with the appropriate permissions to edit content directly on portal pages. Now before I provide more detail on this feature, I think it is important to provide some context on how Fishbowl Solutions has continued to make this feature easier for the business user to edit content.

With previous versions of PSA, the process involved the user going to the content server to find the content item. They then would check out the item, and then use a WYSIWYG-style editor to edit the content. After checking the content item back in they would return to the portal, refresh the page, and hopefully see the changes they made. To highlight what I’ve outlined above, see this video starting at 44:48.

With the current version of PSA, the inline editor was built with the business user mind. Fishbowl wanted to ensure that anyone with the appropriate permissions could edit page content and that the process itself could be done directly on the page itself. This would ensure that more users across more departments could be involved with keeping content on the portal fresh and new, helping companies get more value through higher adoption. An overview of the process is as follows:

  1. Users with the appropriate permissions go to the page they want to update. Hover effects indicate highlighted sections that can be updated.
  2. They then click on the edit icon (pencil on paper) that will appear in the bottom right corner of the editable section.
  3. Once clicked, stylized versions of Content Server profile pages appear. Within this profile form, the user can make any changes to page content. At this point, this page (content item) is checked out from the content server.
  4. Once finished the user click out of the profile form. This checks the item back in, which could trigger a workflow process for page reviews. The user that did the editing can then see in near real-time the updates to the page they made.

To illustrate how easy it is to edit portal page content with Fishbowl’s PSA inline editor, this video shows some examples of editing content, approving those items through workflow, and then seeing the updates.

As you can see, the inline editor feature of Fishbowl’s PSA makes it easy for anyone to update content on the portal. This feature alone ensures that more people within an organization, across departments and roles, can participate in content creation. With content being created more frequently, employees should be more engaged and better informed leading to higher rates of portal adoption.

The post A Simple, Straightforward Method to Update Content on WebCenter-Based Portal Pages appeared first on Fishbowl Solutions.

Categories: Fusion Middleware, Other

Oracle Named a Leader Again in 2018 Gartner Magic Quadrant for Enterprise Integration Platform as a Service

Oracle Press Releases - Wed, 2018-04-25 07:00
Press Release
Oracle Named a Leader Again in 2018 Gartner Magic Quadrant for Enterprise Integration Platform as a Service Oracle evaluated based on its ability to execute and completeness of vision

Redwood Shores, Calif.—Apr 25, 2018

Oracle today announced that it has been named a Leader in Gartner’s 2018 “Magic Quadrant for Enterprise Integration Platform as a Service” report¹ for the second consecutive year. Oracle believes that the recognition is testament to the continued momentum and growth of Oracle Cloud Platform in the past year.

Oracle Cloud Platform, which includes Oracle’s iPaaS offerings, has rapidly expanded its installed base in the last year, reaching almost 3,000 customers—nearly triple its size from fiscal year 2017.

“In our view, being recognized as a Leader for two years in a row further demonstrates the value Oracle Cloud Platform is delivering to thousands of enterprises every day,” said Vikas Anand, vice president of product management, Oracle.  “Our comprehensive iPaaS offering has eliminated the barriers between various Oracle and non-Oracle ERP, HCM, and CX applications to provide a seamlessly connected business spanning cloud and on-premises. This comprehensive and easy to use offering, combined with strong synergy with the rest of the Oracle Cloud portfolio, continues to help our customers successfully transform and evolve their businesses by leveraging modern integration technologies, including artificial-intelligence and machine learning-powered services.”

Oracle recently announced autonomous capabilities across its entire Oracle Cloud Platform portfolio, including application and data integration. Autonomous capabilities include self-defining integrations that help customers rapidly automate business processes across different SaaS and on-premises applications, as well as self-defining data flows with automated data lake and data prep pipeline creation for ingesting data (streaming and batch). Oracle also recently introduced Oracle Self-Service Integration, enabling business users to improve productivity and streamline daily tasks by connecting cloud applications to automate processes. Thousands of customers use Oracle Cloud Platform, including global enterprises, along with SMBs and ISVs to build, test, and deploy modern applications and leverage the latest emerging technologies such as blockchain, artificial intelligence, machine learning and bots, to deliver enhanced experiences.

Gartner positions vendors within a particular quadrant based on their ability to execute and completeness of vision.  According to Gartner, “During 2017, the Leaders quadrant accounted for almost 30,000 clients and more than $600 million in revenue, representing more than half of the entire EiPaaS market. The vendors in this quadrant have client numbers in the thousands for their EiPaaS offering, and often many thousands of indirect users via embedded versions of the platform and through "freemium" options. They have a solid reputation, with notable market presence and a proven track record in enabling multiple integration use cases — often supported by the large global networks of their partners. Their platforms are well-proven and functionally rich, with regular releases to rapidly address this fast-evolving market. As the market evolves to provide further capabilities over the coming months and years, it is the Leaders that are best positioned to continue pushing their dominance, although leadership cannot be taken for granted. In the fast-moving EiPaaS market, one misstep could have catastrophic consequences.”

“GE leverages Oracle Integration Cloud to streamline commercial, fulfilment, operations and financial processes of our Digital unit across multiple systems and tools, while providing a seamless experience for our employees and customers,” said Kamil Litman, vice president of software engineering, GE Digital. “Our investment with Oracle has enabled us to significantly reduce time to market for new projects, and we look forward to the autonomous capabilities that Oracle plans to soon introduce.”

Gartner states, “An integration platform as a service (iPaaS) solution provides capabilities to enable subscribers (aka "tenants") to implement data, application, API and process integration projects involving any combination of cloud-resident and on-premises endpoints.” The report adds, “This is achieved by developing, deploying, executing, managing and monitoring integration processes/flows that connect multiple endpoints so that they can work together.”

Oracle’s iPaaS offerings include Oracle Integration Cloud and Oracle SOA Cloud, both part of Oracle Cloud Platform. Oracle Integration Cloud is a simple and powerful integration platform targeting ad hoc integrators with tools such as process automation, while Oracle SOA Cloud delivers a high-control platform for specialist integrators. With more than 100 adapters, customers can quickly integrate and scale Oracle, third-party, and on-premises applications, APIs, people and devices. Additionally, Oracle has many other cross-PaaS offerings that can be combined with Oracle’s iPaaS services to deliver greater productivity.  Those services include Oracle Data Integration Platform Cloud, to support real-time data streaming, batch data processing, and enterprise data quality and governance; Oracle API Platform Cloud, for API first design and management; and Oracle IoT Cloud, for IoT integration. Oracle API Platform Cloud, leveraging Apiary’s unique API-first design tool used by over 300,000 developers and 400,000 APIs, is designed to eliminate the complexities associated with transforming on-premises API solutions into the cloud, so companies can thrive in the digital economy.

Download a complimentary copy of Gartner’s 2018 “Magic Quadrant for Enterprise Integration Platform as a Service” here.

¹ Gartner, “Magic Quadrant for Enterprise Integration Platform as a Service,” by Keith Guttridge, Massimo Pezzini, Eric Thoo, Bindi Bhullar, Betty J. Zakheim, April 18, 2018

Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner's research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.

Contact Info
Nicole Maloney
Oracle
+1.650.506.0806
nicole.maloney@oracle.com
Kristin Reeves
Blanc & Otus
+1.925.787.6744
kreeves@blancandotus.com
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Nicole Maloney

  • +1.650.506.0806

Kristin Reeves

  • +1.925.787.6744

Setting up MiniShift

Yann Neuhaus - Wed, 2018-04-25 04:18

Currently we have many requests to support customers in running PostgreSQL in Docker containers. Some of those use redhat OpenShift as the management platform for their Docker deployments. Setting up an OpenShift cluster requires quite some resources and is nothing you want to do on your workstation usually. To overcome that you can use MiniShift which launches a one node OpenShift cluster which you can use for testing. Setting that up is quite easy.

Obviously MiniShift needs to be downloaded. I’ll be running MiniShift on my workstation and will use VirtualBox as the Hypervisor for Minishift:

dwe@box:~$ sudo mkdir /opt/minishift
[sudo] password for dwe: 
dwe@box:~$ sudo chown dwe:dwe /opt/minishift
dwe@box:~$ cd /opt/minishift
dwe@box:/opt/minishift$ wget https://github.com/minishift/minishift/releases/download/v1.16.1/minishift-1.16.1-linux-amd64.tgz
dwe@box:/opt/minishift$ tar -axf minishift-1.16.1-linux-amd64.tgz
dwe@box:/opt/minishift$ cd minishift-1.16.1-linux-amd64/
dwe@box:/opt/minishift/minishift-1.16.1-linux-amd64$ export PATH=/opt/minishift/minishift-1.16.1-linux-amd64:$PATH
dwe@box:/opt/minishift/minishift-1.16.1-linux-amd64$ minishift config set vm-driver virtualbox
No Minishift instance exists. New 'vm-driver' setting will be applied on next 'minishift start'

Now MiniShift can be started:

dwe@box:/opt/minishift/minishift-1.16.1-linux-amd64$ minishift start

The output should look similar to this:

-- Starting profile 'minishift'
-- Checking if https://github.com is reachable (using proxy: "No") ... OK
-- Checking if requested OpenShift version 'v3.9.0' is valid ... OK
-- Checking if requested OpenShift version 'v3.9.0' is supported ... OK
-- Checking if requested hypervisor 'virtualbox' is supported on this platform ... OK
-- Checking if VirtualBox is installed ... OK
-- Checking the ISO URL ... OK
-- Downloading OpenShift binary 'oc' version 'v3.9.0'
 42.11 MiB / 42.11 MiB [========================================================================================================================] 100.00% 0s-- Downloading OpenShift v3.9.0 checksums ... OK
-- Checking if provided oc flags are supported ... OK
-- Starting local OpenShift cluster using 'virtualbox' hypervisor ...
-- Minishift VM will be configured with ...
   Memory:    2 GB
   vCPUs :    2
   Disk size: 20 GB

   Downloading ISO 'https://github.com/minishift/minishift-b2d-iso/releases/download/v1.2.0/minishift-b2d.iso'
 40.00 MiB / 40.00 MiB [========================================================================================================================] 100.00% 0s
-- Starting Minishift VM ........................... OK
-- Checking for IP address ... OK
-- Checking for nameservers ... OK
-- Checking if external host is reachable from the Minishift VM ... 
   Pinging 8.8.8.8 ... OK
-- Checking HTTP connectivity from the VM ... 
   Retrieving http://minishift.io/index.html ... OK
-- Checking if persistent storage volume is mounted ... OK
-- Checking available disk space ... 0% used OK
   Importing 'openshift/origin:v3.9.0' . CACHE MISS
   Importing 'openshift/origin-docker-registry:v3.9.0'  CACHE MISS
   Importing 'openshift/origin-haproxy-router:v3.9.0'  CACHE MISS
-- OpenShift cluster will be configured with ...
   Version: v3.9.0
Pulling image openshift/origin:v3.9.0
Pulled 1/4 layers, 26% complete
Pulled 2/4 layers, 72% complete
Pulled 3/4 layers, 82% complete
Pulled 4/4 layers, 100% complete
Extracting
Image pull complete
Using Docker shared volumes for OpenShift volumes
Using 192.168.99.100 as the server IP
Starting OpenShift using openshift/origin:v3.9.0 ...
OpenShift server started.

The server is accessible via web console at:

https://192.168.99.100:8443

You are logged in as:
    User:     developer
    Password: 

To login as administrator:
    oc login -u system:admin

-- Exporting of OpenShift images is occuring in background process with pid 7708.

You should also see a new VM in VirtualBox:
Selection_040

As we will need the oc binary to work with OpenShift we need to add that to the PATH:

dwe@box:/opt/minishift/minishift-1.16.1-linux-amd64$ minishift oc-env
export PATH="/home/dwe/.minishift/cache/oc/v3.9.0/linux:$PATH"
# Run this command to configure your shell:
# eval $(minishift oc-env)
dwe@box:/opt/minishift/minishift-1.16.1-linux-amd64$ eval $(minishift oc-env)
dwe@box:/opt/minishift/minishift-1.16.1-linux-amd64$ which oc

And we are ready to use OpenShift:

oc login -u system:admin
Logged into "https://192.168.99.100:8443" as "system:admin" using existing credentials.

You have access to the following projects and can switch between them with 'oc project ':

    default
  * edb
    kube-public
    kube-system
    myproject
    openshift
    openshift-infra
    openshift-node
    openshift-web-console

Using project "edb".

The web interface is up and running is well:
Selection_041

Logging in as system/admin:
Selection_042

… we could already start and deploy a PostgreSQL container but this is the topic for the next post. To stop MiniShift:

dwe@box:~$ minishift stop
Stopping local OpenShift cluster...
Cluster stopped.

Hope that helps.

 

Cet article Setting up MiniShift est apparu en premier sur Blog dbi services.

From Home Kitchen to Multimillion Dollar Business: hint&reg; Achieves Rapid Growth on NetSuite

Oracle Press Releases - Tue, 2018-04-24 12:00
Press Release
From Home Kitchen to Multimillion Dollar Business: hint® Achieves Rapid Growth on NetSuite NetSuite Helps Pioneering Healthy Lifestyle Company Innovate and Scale in a Crowded Market

SUITEWORLD18—LAS VEGAS—Apr 24, 2018

hint inc., a San Francisco-based provider of unsweetened, fruit flavored water, has grown from a family-run business to a multimillion-dollar company in just a decade with NetSuite. As its founder eyes growth targets of $1 billion, NetSuite will enable hint® to scale its critical business systems as it goes toe-to-toe with industry giants.

Started by Kara Goldin in the kitchen of her San Francisco Bay Area home in 2005, hint was inspired by Goldin’s personal health journey. To replace her 10-can-a-day Diet Coke habit and stay off the soda, Goldin wanted to make water more drinkable and started to experiment by adding fruit into pitchers of water. After rave reviews from her friends and family, and the failure to find a similar unsweetened flavored water in the market, Goldin pitched the idea to Whole Foods. An initial 10 cases sold out overnight and within six months, hint water was on the shelves of Whole Foods stores nationwide. To support this rapid growth, scale the business and ensure products are manufactured as close as possible to the point of distribution, hint selected NetSuite.

“I didn’t set out to launch a beverage company, but as I learned more about the options available to consumers, I realized that it was time to shake things up,” said Goldin, a former long-time AOL executive. “The market was ready, but it was still dominated by centuries-old stalwarts. To have our voice heard in such a crowded space, we needed to couple all of our startup energy and enthusiasm with business processes that allowed us to operate like a much larger firm. NetSuite has given us a platform to grow our business so that we can focus on delighting our customers.”

With NetSuite, hint has been able to avoid IT complexity as its business has grown by automating inventory and order management practices with financial and accounting processes from a very early stage. By adopting business process best practices of much larger organizations from the beginning, hint has been able to quickly capitalize on market opportunities. Building on this success, hint started selling direct to consumers in 2014 and B2C sales now make up a huge percentage of hint’s business.

“hint offers so many lessons on purposeful growth, from its very inception, to the way it continues to influence the industry,” said Jim McGeever, executive vice president Oracle NetSuite. “We are excited to partner with the hint team to help support its next stage of growth.”

Contact Info
Michael Robinson
Oracle NetSuite Corporate Communications
781-974-9401
michael.s.robinson@oracle.com
About hint Inc.

hint inc., the San Francisco-based company founded by entrepreneur Kara Goldin in 2005, is a healthy lifestyle brand known for its delicious unsweetened flavored water. hint® makes it easier and more enjoyable for consumers to live healthier lives. The company’s products have received numerous accolades, including Best Flavored Water (Health, Men’s Health, and SELF), Best New Product (Better Homes and Gardens) and the Silver Stevie Award for Best New Product. Since its launch, hint has been making water taste great without adding any sugar or diet sweeteners. hint’s brands include its flagship product, hint water, its sparkling product line, hint fizz®, and its lightly caffeinated line, hint kick®. hint recently expanded its product offerings into other health and wellness categories with the launch of hint sunscreen spray, a SPF 30 mist that is oxybenzone and paraben-free and scented with hint fruit essences. hint’s products are available nationwide in most major specialty and grocery stores and are available at drinkhint.com for delivery direct to your door. For more information, visit www.drinkhint.com..

About Oracle NetSuite

Oracle NetSuite pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, it provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries.

For more information, please visit http://www.netsuite.com.

Follow NetSuite’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Michael Robinson

  • 781-974-9401

NetSuite Unveils World’s First Intelligent Cloud Suite

Oracle Press Releases - Tue, 2018-04-24 11:45
Press Release
NetSuite Unveils World’s First Intelligent Cloud Suite Artificial intelligence and machine learning deliver insights, automation and intelligent interactions

SUITEWORLD18—LAS VEGAS—Apr 24, 2018

Providing customers with the tools and insight required to meet rapidly evolving business demands, Oracle NetSuite today announced the world’s first intelligent cloud suite. By natively building powerful artificial intelligence and machine learning-based capabilities within its leading cloud business management suite, NetSuite can deliver the insight, interaction and automation customers need to grow their business.

“A pioneer in the cloud, NetSuite has long been a leader in providing powerful business intelligence across its suite,” said Jim McGeever, executive vice president, Oracle NetSuite. “With new artificial intelligence and machine learning capabilities within NetSuite, we’re equipping our customers to understand not only what’s happened with their business, but what will happen in the future and how they can stay ahead.”

Businesses can no longer rely on backward-looking data or traditional business intelligence (BI) systems to successfully grow, scale and adapt to change. To provide the real time-insights businesses need today, NetSuite has built upon its existing native BI functionality by incorporating advanced machine learning and sophisticated data science within its unified cloud suite. The new intelligent cloud combines NetSuite and third-party data to enable businesses to make proactive and timely decisions and take action from right within the NetSuite application. 

“A future where AI drives new business models is quickly becoming the present,” said R “Ray” Wang, principal analyst and founder, Constellation Research. “Having business applications that can deliver predictive, prescriptive and automated outcomes is going to be an imperative for businesses that want to grow and succeed in the years to come.”

The new artificial intelligence and machine learning based capabilities enable businesses to glean better insights, drive efficiencies by further automating processes and determine the next best action with predictive actions. The intelligent cloud suite can deliver benefits to business users across the organization.

  • Finance and Procurement Professionals: AI and machine learning enables finance professionals to improve audit risk analysis, analyze past payment history with vendors and customers and enhance cash flow predictions, a key pain point for growing businesses.
  • HR Professionals: AI and machine learning enables HR professionals to create profiles of the best candidate based on existing top performers, predict high performers who might be a flight risk and better automate employee self-service by identifying what questions employees might have based on role, time of year or other factors.
  • Supply Chain Professionals: AI and machine learning offers supply chain professionals the potential to not only identify risks or potential upcoming problems in the supply chain but, as it learns, provide potential solutions.
  • Manufacturing Professionals: AI and machine learning helps manufacturing professionals optimize labor schedules in the warehouse based on past performance or predicted demand and identify machinery in need of maintenance before it becomes a problem.
  • Commerce Professionals: AI and machine learning helps commerce professionals significantly boost searchandising and improve online sales and conversions by serving up products customers are more likely to buy based on key indicators such as past purchases, search history and results of similar buyers.
  • Customer Services Professionals: AI and machine learning provide customer service professionals with more accurate results around total customer lifetime value by using predictions of costs to the support organization, anticipated satisfaction and information on a customer’s likelihood of renewal.
  • Marketing Professionals: AI and machine learning help marketers improve campaign optimization by identifying what type of campaigns lead to a conversion with what frequency and what type of sale based on demographics, a profile within the customer base, and activity on the website, at events or other available data points.
  • Sales Professionals: AI and machine learning for sales teams support intelligent interactions guiding agents through the sales process, personalizing it for the prospect, the product and upsell, and cross-sell opportunities.
 

“Data is the new gold. With NetSuite, we have real-time insights and visibility into all of our key performance indicators, enabling us to make lightning fast decisions,” said Tony Drockton, Founder and CEO of Hammitt, a Los Angeles-based luxury accessories brand. “Building in intelligence and automation will make using NetSuite easier and more powerful than it already is.”

Contact Info
Michael Robinson
Oracle NetSuite Corporate Communications
781-974-9401
michael.s.robinson@oracle.com
About Oracle NetSuite

Oracle NetSuite pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, it provides a suite of cloud-based financials/Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries.

For more information, please visit http://www.netsuite.com.

Follow NetSuite’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle.

Talk to a Press Contact

Michael Robinson

  • 781-974-9401

NetSuite Enables Businesses to Launch an Online Store Within 30 Days

Oracle Press Releases - Tue, 2018-04-24 11:30
Press Release
NetSuite Enables Businesses to Launch an Online Store Within 30 Days New ecommerce solution gives customers the freedom to grow and evolve their online business

SUITEWORLD18—LAS VEGAS—Apr 24, 2018

Empowering businesses to quickly and efficiently deliver engaging online experiences, Oracle NetSuite today announced an innovative new ecommerce product. The latest release of SuiteCommerce enables businesses to launch a sophisticated online store within 30 days and provides the freedom to grow and evolve to meet the changing needs of shoppers. The first 1,000 customers to sign up for SuiteCommerce get implementation included for pre-defined themes*. To learn more about the offer, sign up here.

“With SuiteCommerce, businesses can quickly and easily launch, manage and enhance their ecommerce site. From day one, they get a single, unified solution that supports their entire business and will be the first and last system they will ever need,” said Jim McGeever, executive vice president, Oracle NetSuite. “Most importantly, our unique approach puts an end to long, costly implementations and allows customers to get the most they can from their commerce investment.”

To keep up with ever-evolving customer expectations, merchants need an ecommerce solution they can easily manage, extend and enhance without development resources. The new NetSuite commerce solution meets this need by providing themes, accelerated deployment, drag-and-drop site management tools and plugins to extend site capabilities. In addition, ecommerce is integrated with the NetSuite platform so businesses gain the advantage of having a single source of real-time order, customer and inventory information to create seamless omnichannel brand experiences and streamline business processes.

“SuiteCommerce is the perfect solution for us,” said Bob Sullivan, CEO and owner of DASH Medical Gloves, a leading supplier of high quality protective gloves for a variety of industries. “It’s amazing how much you can do without a lot of technical knowledge. The fact that we can go in and make changes to the site, add new products or run promotions with simple drag-and-drop tools is extremely valuable. The beauty of this approach is that we can continually evolve our website to meet changing customer needs.”

SuiteCommerce delivers:

  • Full-Featured SaaS Ecommerce: By supporting B2C and B2B ecommerce on the same platform, SuiteCommerce provides uniquely branded, relevant shopping experiences that drive online engagement and conversion. To help businesses further increase engagement, a selection of themes optimized for performance, engagement and conversion are available. All themes are fully responsive to provide a consistent experience no matter how shoppers browse the store.
  • Easy to Implement: Rapid site implementation enables faster time to value, increased business efficiency and greater customer satisfaction. By leveraging the knowledge, experience and best practices from thousands of ecommerce deployments, SuiteSuccess for SuiteCommerce enables customers to get a best-in-class B2C or B2B online store with commerce reports, dashboards and KPIs within 30 days.
  • Easy to Manage: Drag-and-drop site management tools allow non-technical users to edit pages and manage content. This gives business users the ability to update the look and feel of their site without the help of a developer. In addition, users can easily complete multiple changes to the site and then schedule them for future deployment based on business needs.
  • Easy to Extend: Business users can quickly and easily expand the capabilities of their stores with extensions. Extensions are designed to upgrade seamlessly with each release, allowing customers to enhance their site in a way that’s maintainable. To support developers, the NetSuite Commerce Extension Framework provides an API that makes it easy for developers to create their own extensions.
 

* SuiteSuccess for SuiteCommerce implementation service included with the purchase of SuiteCommerce
1. Offer applies only to webstores built with the purchase of NetSuite’s SuiteCommerce Module
2. Offer is available for the implementation of a single webstore hosted under a single domain
3. Offer is only available for implementation services that leverage NetSuite’s pre-defined theme templates for design and functionality of the webstore
4. Offer is valid for webstores that transact in USD only; are subject to a tax jurisdiction(s) within the United States; and display only US English on the webstore
5. Additional descriptions which define webstore functionality, the implementation services, & the provision of training services will be defined in a Statement of Work provided by NetSuite Professional Services
6. Promotional pricing is available for new and current customers who contract for subscription and services on or before 5/31/2018
7. Customers are required to complete the self-paced training class; Getting Ready for Commerce, which is provided at no additional cost, prior to the scheduled start date of any implementation services

Contact Info
Michael Robinson
Oracle NetSuite Corporate Communications
781-974-9401
michael.s.robinson@oracle.com
About Oracle NetSuite

Oracle NetSuite Global Business Unit pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, it provides a suite of cloud financials/Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries.

For more information, please visit http://www.netsuite.com.

Follow Oracle NetSuite’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle.

Talk to a Press Contact

Michael Robinson

  • 781-974-9401

NetSuite Industry Innovations Help Businesses Accelerate Growth

Oracle Press Releases - Tue, 2018-04-24 11:15
Press Release
NetSuite Industry Innovations Help Businesses Accelerate Growth New industry-specific solutions, finance, HR, supply chain and data analytics transform and improve business operations

SUITEWORLD18—LAS VEGAS—Apr 24, 2018

Oracle NetSuite today announced a series of new innovations to help organizations across industries drive growth, reduce costs and quickly and easily achieve the benefits of cloud computing. The latest innovations within the NetSuite platform include new SuiteSuccess industry cloud solutions, enhanced financial management, HR and supply chain capabilities, new innovations for product and service companies, and a powerful new data analytics solution.

Successfully growing a business has never been harder. New technologies, rapidly shifting consumer expectations and evolving industry regulations continue to change the game. For business leaders, this can feel like a no-win situation, particularly as competition continues to increase and results are under the microscope. The latest innovations from NetSuite help business leaders navigate this change, overcome the barriers to growth and successfully scale by delivering industry best practices, new customer engagement models and business optimization methods, more than 20 major enhancements to core business applications and powerful data processing and visualization capabilities.

“Many companies are able to get their businesses up and running only to struggle when the time comes to reach the next stage of growth,” said Jim McGeever, executive vice president of Oracle NetSuite. “With continuous innovation, we give our customers the tools to overcome the barriers to growth.”

New Industry SuiteSuccess Cloud Solutions

To deliver faster time to value, increased efficiency and provide the flexibility to foster growth and customer success, NetSuite is introducing 14 new editions of SuiteSuccess. A unified, and pre-configured industry cloud solution, SuiteSuccess is built on industry leading practices, combining deep domain knowledge with pre-built KPIs and dashboards. The latest editions are designed to meet the unique requirements of micro-verticals and span a variety of specific industries, company sizes and maturity in the cloud ERP journey. The new SuiteSuccess editions include:

  • Starter: Designed for small and rapidly growing company needs, including finance and accounting, order-to-cash and procure-to-pay.
  • Commerce: Designed for retailers and other ecommerce-focused business needs, including website development and order management.
  • Technology Services: Designed for technology services provider needs, including project management, sales, order and financial management.
  • Consulting Services and Consulting Services Emerging: Two new editions designed for consulting services organizations at different stages of growth with finance and accounting, project and resource management.
  • Manufacturing and Manufacturing Emerging: Two new editions support manufacturers at different stages of growth with inventory, supply chain and order management.
  • Food and Beverage Manufacturer: Designed for food and beverage manufacturers, including features for demand planning, tracking and traceability.
  • Advertising, Media and Publishing: Three new editions designed for agencies, media and entertainment and publisher needs, including features for resource allocation, time and expense, and reporting.
  • OneWorld, Administrator and Accounting: Three new editions for existing NetSuite customers are designed to support global growth, enhance the capabilities and knowledge of NetSuite administrators and ensure accounting features within NetSuite are being maximized.

New Vertical Industry Functionality

To help customers accelerate growth while reducing costs, NetSuite has introduced more than 20 major enhancements to its core application. The enhancements include new industry-specific capabilities for product and services companies as well as innovative HR and financials functionality. The latest updates include:

  • Innovations for Product Companies: For companies in industries like manufacturing, wholesale distribution and retail, NetSuite is delivering new features that increase efficiency, deliver greater insights and improve the customer experience. The enhancements include new supply chain control tower, warehouse management, fulfillment, engineering change management, quality management system and landed costing capabilities.
  • Innovations for Services Companies: To help service companies improve profitability, resource management, revenue management and revenue recognition, NetSuite has introduced enhanced project profitability reporting, advanced revenue management enhancements, charge-based billing for ‘time-based rules,’ a new UI for weekly timesheets, a deferred expense waterfall report and new resource allocation grid filters.
  • Innovative Financial Features: To ensure customers have a leading-edge financials solution, NetSuite has reworked its cash management and bank reconciliation functionality in order to streamline the process and give companies better control of one of their key assets - cash. The latest additions include an enhanced online bank statement reconciliation and transaction matching engine, improved bank statement import record capabilities, full translation support for electronic payments and new multi subsidiary customer support.
  • Innovative HR Features: Building on the launch of NetSuite SuitePeople, an HR offering natively built on NetSuite’s unified cloud suite, NetSuite has introduced a range of new capabilities to help HR professionals attract, manage, train and retain talent. New capabilities include a mobile employee directory, payroll dashboard, headcount and turnover analytics, absence management enhancements and integration with Oracle Taleo Business Edition.
  SuiteAnalytics

To help customers make better business decisions, NetSuite has introduced new SuiteAnalytics capabilities, including a powerful consumer grade data exploration tool that brings rapid, secure and meaningful data exploration capabilities to non-technical users enabling them to gain real-time insight into the business without needing to wait for data warehouses to be updated, outdated reports to be written our moving large amounts of important company data to unsecure spreadsheets.

Contact Info
Michael Robinson
Oracle NetSuite Corporate Communications
781-974-9401
michael.s.robinson@oracle.com
About Oracle NetSuite

Oracle NetSuite pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, it provides a suite of cloud-based financials/Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit http://www.netsuite.com.

Follow Oracle NetSuite Global Business Unit’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

Talk to a Press Contact

Michael Robinson

  • 781-974-9401

NetSuite Empowers Businesses to Capitalize on Opportunities Presented by World’s Largest and Fastest Growing Economies

Oracle Press Releases - Tue, 2018-04-24 11:00
Press Release
NetSuite Empowers Businesses to Capitalize on Opportunities Presented by World’s Largest and Fastest Growing Economies NetSuite OneWorld adds localized product capabilities and expands in-country presence for businesses in Germany, France, China, Japan, Brazil and Mexico

SUITEWORLD18—LAS VEGAS—Apr 24, 2018

Extending its commitment to helping businesses across the world grow, scale and adapt to change, Oracle NetSuite today announced localized product capabilities and customer support for businesses in Germany, France, China, Japan, Brazil and Mexico. With the new local capabilities and in-country teams, NetSuite further empowers customers to take advantage of one unified business platform to streamline the management of multi-subsidiary operations, achieve consistent processes across countries, support global compliance and gain real-time global insight.

“With ever-changing regulations and evolving customer expectations, it is getting harder for businesses to drive growth both locally and internationally,” said Jim McGeever, executive vice president, Oracle NetSuite. “With new native localizations and customer support, we are giving our customers a complete solution with language, currency, tax compliance and local support teams in six of the world’s biggest and fastest growing economies.”

Germany, France, China, Japan, Brazil and Mexico are among the top 15 largest and fastest growing economies in the world, but increasing competition, shifting customer expectations and constantly changing regulations mean it is harder than ever to capitalize on the opportunities presented by these economies. With the new localized product capabilities and local in-country teams, NetSuite empowers businesses headquartered or operating subsidiaries in these economies to quickly and easily leverage an integrated suite of modern business applications to drive growth, reduce costs and achieve the benefits of cloud computing. 

With customers now operating in 199 countries and dependent territories around the world, NetSuite is the proven cloud ERP business platform of choice for companies operating and growing internationally. The expanded global support further extends NetSuite OneWorld, a real-time, unified global business management platform that enables global businesses to streamline multi-subsidiary operations and achieve real-time visibility into key business metrics at the local, regional and headquarter levels. In addition, to help businesses across the world successfully grow, OneWorld supports 190 currencies, 24 languages, automated tax calculation and reporting in more than 100 countries.

  • Germany: NetSuite has achieved the local IDW PS 880 certifications necessary to validate NetSuite OneWorld for use by companies headquartered in Germany, and subsidiaries of multinational companies with operations in Germany. In addition, NetSuite OneWorld delivers country-specific features and functionality such automated period end closing entries, general ledger impact locking (Storno) and coming later this year, legal central bank reporting Z4/Z5a, fixed asset reporting – Anlagengitter, and bank and cash management updates.
  • France: NetSuite has achieved the first ever formal certification of NetSuite software in the market. OneWorld for French-based companies delivers period end close journals, FEC reporting, (Fichier d’écritures comptables), general ledger impact locking (Storno), Foreign Currency Gains/Losses variance postings (including custom rules), and coming in the next release support for Lettrage.
  • China: NetSuite customers can now open subsidiaries or new businesses in the world’s fastest-growing economy without the need for third-party products or extensive customization. Support for local Chinese requirements includes China-specific Reports and accounting as well as support for the China Golden Tax System.
  • Japan: NetSuite customers can now benefit from an improve user experience that includes enhanced Japanese summarized invoice support and automatic validation of closing and payment date. Summarized invoice support enables users to easily follow the general practice of sending a consolidated statement of all invoices, while automatic validation of closing and payment date capabilities enables users to automatically adjust the payment due dates on an invoice and credit memos if it falls on a weekend or holiday.
  • Brazil: NetSuite OneWorld can support services-based companies in Brazil, the largest economy in Latin America, with further plans to support product-based companies in the next 12 months. Support for local Brazilian requirements includes Brazilian-specific tax support, Nota Fiscal Eletrônica NFS-e (electronic invoices for services), electronic statutory reports and enabling Electronic Payments integrations to local banks.
  • Mexico: NetSuite customers can now benefit from native support for Mexican-based companies including the latest Electronic Invoicing requirements—CFDI 3.3—and Electronic Accounting 1.3.
Contact Info
Michael Robinson
Oracle NetSuite Corporate Communications
781-974-9401
michael.s.robinson@oracle.com
About Oracle NetSuite

Oracle NetSuite pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, it provides a suite of cloud-based financials/Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries.

For more information, please visit http://www.netsuite.com.

Follow NetSuite’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

Talk to a Press Contact

Michael Robinson

  • 781-974-9401

Oracle Linux 7 Update 5 is out: time to create a new Vagrant Base Box

Darwin IT - Tue, 2018-04-24 09:31
It's been busy, so unfortunately it's already been almost two weeks I wrote my introductory story on Vagrant. Today I happen to have an afternoon off, and I noticed that Oracle Linux 7 Update 5 is out. I based my first boxes on 7.4, so nice moment to start with creating a new Base Box.

De essentials on creating a Vagrant base box can be read here. But I'm going to guide you trough the process step by step, so I hope you will be able to repeat this yourself, using this guide-through.

First of, Vagrant recommends Packer to automate the creation of base boxes. But I'm a bit confused, because in this guide it is apparently stated that this is deprecated by march 2018. I haven't tried Packer yet, but I feel that over the years I created a base VM only a few times. I used to create a base VM that I import/clone to create new VMs over and over again. And often, I start of with a VM that already contains a pre-installed database for instance.

Vagrant has a built in command to create a base box out of an existing VM. That is what I use.
Base box requirementsWhat is a Base Box actually? Well, it's in fact sort of a template that is used by Vagrant to create and configure a new VM and provision that. It should contain the following
  • An OS: I use Oracle Linux 7 Update 5 for this story. I also have a base box with Ubuntu. Ubuntu has some peculiarities I want to discuss later on in this series. For this base box I'll install a server-with-gui. But further as basic as possible.
  • A vagrant user. The vagrant user is used for provisioning the box. We'll place a public insecure key in it, that will be replaced by Vagrant at first startup. We'll add vagrant to the sudoers list, so the user can sudo without passwords.
  • A started ssh daemon:  Vagrant connects via ssh using the vagrant-user to do the provisioning.
  • A NAT (Network Address Translation) Adapter as the first one: needed to do kernel/package updates without further network configuration.
  • VirtualBox GuestAdditions installed: Vagrant makes use of shared folders to map the project folder to get to the scripts. Also it's convenient to add an extra stage folder mapping. 
  • Password of root: not a requirement, but apparently it's a bit of a standard to set the root password to vagrant as ease of sharing. But at least note down the passwords.
That's about it. Maybe I forget something, but since it's digital, I can edit it later... So let's get started.

Download  Oracle LinuxAll the serious enterprise stuff of Oracle can be downloaded at edelivery. Search for Oracle Linux:
Then add the 7.5 version to the Cart by clicking it:

Follow the wizard instructions and you'll get to:
I downloaded V975367-01.iso        Oracle Linux Release 7 Update 5 for x86 (64 bit), 4.1 GB.

Create the VMThe ISO is downloading, so let's create a VM in VirtualBox. I assume VirtualBox with VirtualBox Extension Pack is installed. And for later on Vagrant of course.

From the Oracle VM VirtualBox Manager, create a new VM, I called it OL75, for Oracle Linux 64 bit:
I followed the wizard and gave it 10240 MB memory and a 128GB dynamically allocated virtual disk:

In the VM Settings, I set the number of processors to 4 and for now I kept everything to the default.

In the meantime my download is ready, so in the VM Settings, under Storage I added the disk by clicking the disk icon next to the IDE controller:

Then navigate to your downloaded iso:
and select it. Now the VM is ready to kick-off:


It will startup automatically after a minute, but let's not wait that long.

I don't need much, but in the Sofware Selection I do want Server with GUI:
But with out selecting other packages. What I might need later on, I'll install at provisioning.

I do not like default local domain networknames. So I changed the network hostname to darlin-vce.darwin-it.local:
Hostname darlin stands for Darwin Linux and vce for Virtual Course Environment.

Then hit Begin Installation:


Soon in the installation the installer asks for the Root password:
And the password is as said: vagrant.
Then I add also a vagrant with the same password:
Having done that, we need to wait for the installer to finish. At the end of the Install, do a reboot:

This leads to 2 questions to be answered. One is about accepting the licensing. I assume that can be answered without guidance. The other is about connecting the network.

You need to switch on the network adapter, but to have it done automatically you need to configure it and check the box Automatically connect to this network when it is available on the General tab. You'll need to have this done, otherwise Vagrant will have difficulties in connecting to the box.
Then finish the configuration:
Install guest additionsTo be able to install the guest additions, we need to add some kernel packages. We could have done that by installing additional kernel packages. But I wanted to have a as basic as possible installation. And the following is more fun...

So open a terminal and switch to the super user:

[vagrant@darlin-vce ~]$ su -
Password:
Last login: Tue Apr 24 09:41:21 EDT 2018 on pts/0
...


Then stop package kit, because it will probably hold a lock pausing yum:
[root@darlin-vce ~]# systemctl stop packagekit

And then install the packages kernel-uek-devel kernel-uek-devel-4.1.12-112.16.4.el7uek.x86_64, that are suggested by the GuestAdditions installer, by the way:
[root@darlin-vce ~]# yum -q -y install kernel-uek-devel kernel-uek-devel-4.1.12-112.16.4.el7uek.x86_64
No Presto metadata available for ol7_UEKR4
warning: /var/cache/yum/x86_64/7Server/ol7_latest/packages/cpp-4.8.5-28.0.1.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Public key for cpp-4.8.5-28.0.1.el7.x86_64.rpm is not installed
Public key for kernel-uek-devel-4.1.12-124.14.1.el7uek.x86_64.rpm is not installed
Importing GPG key 0xEC551F03:
Userid : "Oracle OSS group (Open Source Software group) "
Fingerprint: 4214 4123 fecf c55b 9086 313d 72f9 7b74 ec55 1f03
Package : 7:oraclelinux-release-7.5-1.0.3.el7.x86_64 (@anaconda/7.5)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle

Having done that, insert the GuestAdditions CD:
It brings the following pop-up, click Run:

And provide the Administrator password:

In my case the script ran and during that the display got messed up. But after a reset of the VM (I waited until I got the impression it was done), the VM got up with a Hi-res display, indicating that the install went ok. Also the bi-directional clipboard worked.

Configure vagrant userAgain in a terminal switch to super user and add the following line to the /etc/sudoers file:
vagrant ALL=(ALL) NOPASSWD: ALL

Exit and as vagrant user create a .ssh folder in the vagrant home folder, cd to it and create the file authorized_keys:
[vagrant@darlin-vce ~]$ mkdir .ssh
[vagrant@darlin-vce ~]$ cd .ssh
[vagrant@darlin-vce .ssh]$ vi authorized_keys

Insert the following content:
ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAQEA6NF8iallvQVp22WDkTkyrtvp9eWW6A8YVr+kz4TjGYe7gHzIw+niNltGEFHzD8+v1I2YJ6oXevct1YeS0o9HZyN1Q9qgCgzUFtdOKLv6IedplqoPkcmF0aYet2PkEDo3MlTBckFXPITAMzF8dJSIFo9D8HfdOV0IAdx4O7PtixWKn5y2hMNG0zQPyUecp4pzC6kivAIhyfHilFR61RGL+GPXQ2MWZWFYbAGjyiYJnAmCP3NOTd0jMZEnDkbUvxhMmBYSdETk1rRgm+R4LOzFUGaHqHDLKLX+FIPKcF96hrucXzcWyLbIbEgE98OHlnVYCzRdK8jlqm8tehUc9c9WhQ== vagrant insecure public key

This is the insecure key of vagrant that can be downloaded here.
It will be replaced by Vagrant at first startup.

Package the boxSo, now we have a base install that can function as a base box for Vagrant. Thus we can now shut it down to export it to an OVA (just as a backup for VirtualBox) and then create are base box out of it.

After creating your export of the OVA, that I skip describing here, you just open a command window. I assume you have Vagrant installed.

To package the box, you use the package subcommand of vagrant:

Microsoft Windows [Version 10.0.16299.371]
(c) 2017 Microsoft Corporation. All rights reserved.

d:\Projects\vagrant>vagrant package --base OL75 --output d:\Projects\vagrant\boxes\OL75v1.0.box
==> OL75: Exporting VM...
==> OL75: Compressing package to: d:/Projects/vagrant/boxes/OL75v1.0.box

d:\Projects\vagrant>

Conclusion Well, that concludes this part of the series. We have our own base box and it's barely 3GB. Next: create a VM with it. Stay tuned.




Pages

Subscribe to Oracle FAQ aggregator