Provisioning Oracle Order and Service Management 7.5.3
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:
- Navigate to the model for OSM
- Click Edit Configuration at the top-right of MyST Studio
- 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:
PropertyExpected valuedb-default-tablespaceDefault tablespace OSM tables will be installed in.db-model-data-tablespaceTablespace OSM model tables will be created in.db-model-index-tablespaceTablespace OSM model index tables will be created in.db-order-data-tablespaceTablespace OSM order data tables will be created in.db-order-index-tablespaceTablespace OSM order index tables will be created in.db-temp-tablespaceTemporary tablespace used for OSM database operations.frontend-hostHost where front-end load balancer is locatedfrontend-http-portHTTP port used by front-end load balancer directing traffic to OSM.frontend-https-portHTTPS port used by front-end load balancer directing traffic to OSM.notification-email-addressEmail address for OSM administratornotification-email-serverEmail host used by OSMtimezone-offsetConfigured timezone of database used by OSM, expressed in offset from GMT in seconds.user-admin-passwordOSM administrator password.user-automation-passwordOSM automation user (osm-automation) password.user-internal-passwordPassword for core OSM user (osm-internal)user-studio-passwordPassword for Design Studio administrator user.