Install the Domain Orchestrator › Post-Installation Tasks for the Domain Orchestrator › Change the Database Configuration to Use an Oracle Service Name

Change the Database Configuration to Use an Oracle Service Name

When you install an Orchestrator using Oracle as the database type, you specify an Oracle Instance Name or SID for each of the three data stores. The Oracle Service Name is required when you reference an Oracle RAC Database; you configure CA Process Automation to use an Oracle Service Name as a post-installation task.

In the examples that follow, replace the oracle-hostname-or-ip variable with one of the following values:

• The host name of an Oracle RAC SCAN
• The IP address of an Oracle RAC SCAN
• The host name of a standalone Oracle instance
• The IP address of a standalone Oracle instance

Follow these steps:

1. Verify that CA Process Automation successfully uses the Oracle databases that were specified (at installation) using the Instance Name or SID. To verify successful usage, start the CA Process Automation service and examine the log file to verify that there are no database-related errors. The log file path and name is:

   install_dir/server/c20/logs/c2o.log
   

2. Stop the CA Process Automation service as described in Stop the Orchestrator.
3. Open the OasisConfig.properties file.

   install_dir\server\c2o\.config\OasisConfig.properties
   

4. Modify the following entries for the Library data store:

   oasis.database.connectionurl=jdbc:oracle:thin:@//oracle-hostname-or-ip:1521/
   oasis.database.lib.dbname=ServiceName
   oasis.database.queues.dbname=ServiceName
   oasis.database.dbhostname=oracle-hostname-or-ip
   

5. Modify the following entries for the Runtime data store:

   oasis.runtime.database.connectionurl=jdbc:oracle:thin:@//oracle-hostname-or-ip:1521/
   oasis.runtime.database.dbname=ServiceName
   oasis.runtime.database.dbhostname=oracle-hostname-or-ip
   

6. Modify the following entries for the Reporting data store:

   oasis.reporting.database.connectionurl=jdbc:oracle:thin:@//oracle-hostname-or-ip:1521/
   oasis.reporting.database.dbname=ServiceName
   oasis.reporting.database.dbhostname=oracle-hostname-or-ip
   

7. Save the OasisConfig.properties file.
8. Start the Orchestrator.

For the connection URL statements, the following notations are also valid:

Referencing an Oracle Hostname using TNS Notation

The following example is not RAC-specific.

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Oracle-hostname-or-ip)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ServiceName)))

Referencing RAC Virtual Host Names using an Address List with TNS Notation

jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=OFF)(FAILOVER=ON)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle-hostname-or-ip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=oracle-hostname-or-ip)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ServiceName)))

Important! When using TNS notation, ensure that the .dbname value for each of the data stores is blank, The .dbname value is appended onto the connection URL statement when connecting to the database. Appending the service name is not desired in this case, as it is included in the TNS notation.