3 Configuring ODI Marketplace Repositories on DBCS Instance

This chapter helps you to create a new DBCS instance and set up ODI master and work repositories for the newly created DBCS instance on Oracle Cloud Marketplace.

Perform the following steps to create a DBCS instance and set up ODI master and work repositories for the created DBCS instance:

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. After installing the schemas you can set up ODI on DBCS by providing the DBaaS connection credentials.

For more information on creating schemas using RCU, refer to Creating Master and Work Repositories.

Note:

If you wish to use the newly created DBCS repository for your default ODI Marketplace Agent, refer to Switching Repositories of the ODI App Server.

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.

After creating the domain based on the type of agent deployed, start the agent (standalone agent) or Admin Server and Managed server (JEE agent) from the location $ODI_DOMAIN_HOME/bin.

Note:

For more details on creating and configuring a JEE agent, refer to Configuring the Domain for a Java EE Agent chapter of Installing and Configuring Oracle Data Integrator guide.