Creating a DBCS instance on Oracle Cloud Marketplace

Follow the below steps to create a DBCS instance on Oracle Cloud Marketplace:

1. From the OCI console, navigate to the left menu, click Database and select Bare Metal, VM and Exadata.
2. Select the required compartment and click Create DB System. DB System Information screen appears. It allows you to configure all the required details for creating a DB instance, such as compartment, Database name, username and password. All the default values are auto-populated.
3. In the Add SSH keys section, select the option Paste SSh key and provide the genereated SSH key in the SSH key text box.
4. In the Specify the network information section, click the Virtual Cloud Network in ODI drop-down arrow to select the required virtul cloud network.
5. Provide the required details in Hostname Prefix, Host domain name and Host domain URL text boxes. Click Next.
6. Create Administrator Credentials screen appears allowing you to configure the password for the default admin user.

   Note:

   Admin password that you provide should be 9 to 30 characters in length, contain at least two alphabets in upper case, two alphabets in lower case, two special characters (which includes _, # or -) and two numeric characters.
7. After configuring all the details, click Create DB system.

A new DBCS instance is created.

Setting up ODI on DBCS

For setting up ODI master and work repositories on a DBCS instance, you need to install ODI schemas using RCU.

Follow the below procedure to create repositories using the Repository Creation Utility:

1. Find the repository creation utility executable available in the $MW_HOME/oracle_common/bin directory in the Fusion Middleware home and launch rcu.
2. The first screen is just a welcome screen. Click Next.
3. Accept the default values and click Next.
4. Specify the database connection details. Once entered, you can see a dialog box showing the progress of the three checks carried out on the database, making sure that the connection is successful.
5. Select the repository components to install. Some are selected by default. Make sure you select the Master and Work repository option. Click Next.

   You can now see a dialog box showing the progress of the checks carried out on the prerequisites for the components you selected

6. If all the prerequisite checks pass, then enter the password for the schema users for the repositories. It's easiest to use the same passwords for all schemas, however, make sure you choose the option that conforms to your company security policy. Click Next.
7. Enter the password for the Supervisor user, what type the work repository is, its name and the password for its user. Also specify the encryption algorithm. Click Next.
8. Map the tablespaces. This is where you specify the name of the schema owners, and the default and temporary tablespace names for each component. You can accept the default names, or choose to specify your own. Click Next.
9. The penultimate screen summarizes your selections, and from here, you create the repositories. Click Create. Note that it takes several minutes to create all the repositories.
10. Click Close after you have reviewed the summary of the repositories just created.

After installing the schemas you can set up ODI on DBCS by providing the DBaaS connection credentials.

Configuring the Domain for a Standalone Agent

Create and configure a standalone domain for a standalone agent using the Configuration Wizard. For more information on configuring ODI Domain ($ODI_DOMAIN_HOME) with Standalone/JEE Agent template, refer to Configuring the Domain for a Standalone Agent chapter of Installing and Configuring Oracle Data Integrator guide.