Oracle Order and Service Management 12c

Preparing database privileges

In order to provision Oracle Order and Service Management (OSM) 7.5.3 successfully, the database used by the environment must be prepared by executing the following SQL for the sys user:

grant create any context to sys with admin option;

Defining required properties

In order to provision Oracle Order and Service Management (OSM) 7.5.3 successfully with MyST Studio, a number of properties must be defined for the OSM product in your configuration model.

To define the required properties:

1. Navigate to the model for OSM

2. Click Edit Configuration at the top-right of MyST Studio

3. Navigate to 'Oracle Order and Service Management' in the Product section of the model tree displayed on the left-hand side.

The required properties are:

Property	Expected value
db-default-tablespace	Default tablespace OSM tables will be installed in.
db-model-data-tablespace	Tablespace OSM model tables will be created in.
db-model-index-tablespace	Tablespace OSM model index tables will be created in.
db-order-data-tablespace	Tablespace OSM order data tables will be created in.
db-order-index-tablespace	Tablespace OSM order index tables will be created in.
db-temp-tablespace	Temporary tablespace used for OSM database operations.
frontend-host	Host where front-end load balancer is located
frontend-http-port	HTTP port used by front-end load balancer directing traffic to OSM.
frontend-https-port	HTTPS port used by front-end load balancer directing traffic to OSM.
notification-email-address	Email address for OSM administrator
notification-email-server	Email host used by OSM
timezone-offset	Configured timezone of database used by OSM, expressed in offset from GMT in seconds.
user-admin-password	OSM administrator password.
user-automation-password	OSM automation user (osm-automation) password.
user-internal-password	Password for core OSM user (osm-internal)
user-studio-password	Password for Design Studio administrator user.