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:
- From the OCI console, navigate to the left menu, click Database and select Bare Metal, VM and Exadata.
- 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.
- In the Add SSH keys section, select the option Paste SSh key and provide the genereated SSH key in the SSH key text box.
- In the Specify the network information section, click the Virtual Cloud Network in ODI drop-down arrow to select the required virtul cloud network.
- Provide the required details in Hostname Prefix, Host domain name and Host domain URL text boxes. Click Next.
- 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.
- 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.
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.