Oracle® Retail Omnichannel Cloud Data Service Installation Guide Release 19.0.0 F25867-01 |
|
Previous |
Next |
This chapter describes the instructions for building the OCDS schemas on an Oracle 12c Pluggable Database (PDB).
Oracle Database 12c (Release 12.1.0.2) has been installed.
Container Database (CDB) has been created.
Pluggable Database (PDB) for OCDS schema has been created.
Configured ORDS 19.2 for the OCDS database:
Set the location of the ORDS configuration files
java -jar ords.war configdir </path/to/ords/config>
Configure database connection to the OCDS database
java -jar ords.war setup --database <database name>
Configure the request routing rule for OCDS services
java -jar ords.war map-url --type base-path <path prefix> <database name>
The two OCDS database users have been created with the following names and empty schemas:
ocds_ifc
ocds_txn
Perform the following procedure to prepare for these schema creation of the OCDS database. This archive file contains scripts to populate the two OCDS schemas, enable and secure the OCDS REST services.
Unzip ocds-database-creation.zip
. The location where the files were extracted will be referenced as <dbScripts> in the following steps.
Perform the following steps to populate the OCDS schemas.
Connect to the ocds_ifc schema and execute the following scripts:
<dbScripts>/scripts/rtg_ifc/ddl/BDI_BATCH_JOB_INFRA_CREATE.sql
<dbScripts>/scripts/rtg_ifc/ddl/BDI_RECEIVER_INFRA_CREATE.sql
<dbScripts>/scripts/rtg_ifc/ddl/ocds_ddl.sql
Connect to the ocds_ifc schema as a user with permissions to grant access to tables in the ocds_ifc schema and execute the following scripts:
<dbScripts>/ocds_txn/plsql/Interface_Schema_Access.sql
Connect to the ocds_txn schema and execute the following scripts:
<dbScripts>/scripts/ocds_txn/ddl/ocds-txn-ddl.sql
<dbScripts>/scripts/ocds_txn/plsql/ocds-txn-plsql.sql
Connect to the ocds_txn schema as a user with permissions to grant access to packages on the ocds_txn schema and execute the following scripts:
<dbScripts>/scripts/ocds_ifc/plsql/Transaction_Schema_Access.sql
Connect to the ocds_ifc schema and execute the following scripts:
<dbScripts>/scripts/ocds_ifc/plsql/ocds-ifc-plsql.sql