Creating database objects for Oracle

Database prerequisites

• The database cluster must already exist.

• This procedure must be performed by a DBA user.

Create database objects

To create database objects for Oracle, it is recommended to use the automatic procedure described in this section.

Follow these steps:

1. Run the il dataonedb.cfg file as detailed on the dataonedb.cfg-reference page.

2. Run this command: ./dataonedbmgr.sh -sqlrun -install

Manually launch the scripts

Manually launching scripts is not suggested. If you are aware of what you are doing and know how to get out of it in case of unwanted results, follow these steps to access the scripts:

• Copy the DOIM_HOME/pkg-repo/pkg-base/db/ghibli-distro-db-<version>.tar.gz to the database host or to a client that can connect to the database.

• Extract the package ghibli-distro-db-<version>.tar.gz.

• Run the scripts and compile as needed.

Oracle script parameters vs DMCFG parameters

Some of the scripts require parameters whose value must be the same as the value specified in the Domain Master Configuration Reference (DMCFG). Here is a quick cross-reference between the two sets of parameters:

Oracle script parameter	DMCFG parameter
ADMIN_USER	ceman_db_schema
APP_USER	CEMAN_DB_USR
APP_PASS	CEMAN_DB_PSW
KEYCLOAK_USER	KEYCLOAK_DB_SCHEMA