3 OCDS Schemas

This chapter describes the instructions for building the OCDS schemas on an Oracle 12c Pluggable Database (PDB).

Prerequisites

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 18.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:
- ocds_ifc
- ocds_txn

Preparation

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

Database Schema Population

Perform the following procedure to populate each of the OCDS schemas.

Execute each schema's db-define script as a DBA role database user:
1. Specify OCDS database as container.
  - alter session set container = <database name>;
2. Execute each db-define:
  - <database scripts root folder>/scripts/ocds_txn/db-define.sql
  - <database scripts root folder>/scripts/ocds_ifc/db-define.sql

Enable REST Services on OCDS Database

Perform the following procedure to enable the OCDS web services on the ocds_txn schema.

Execute the enable-rest script as the ocds_txn database user.

<database scripts root folder>/scripts/ocds_txn/enable-rest.sql

Secure OCDS Web Services on OCDS Database

Perform the following procedure to secure the OCDS web services on the ocds_txn schema.

Execute the secure-rest script as the ocds_txn database user.

<database scripts root folder>/scripts/ocds_txn/secure-rest.sql