# 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](https://docs.primeur.com/data-one-installation-manager/cli-and-configuration-files/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.&#x20;

## 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)](https://docs.primeur.com/data-one-installation-manager/install-data-mover/data-mover-domain-master-configuration-reference). 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 |