Vidit,
You will need to add the Oracle driver to Manage User Resources.
This is outlined in the Administrator guide under Manage User Resources, then How to deploy JDBC drivers for Database Operators.
Log in to Process Automation as an administrator and select the Configuration tab.
On the left, select the Manage User Resources palette
Select the Orchestrator Resources folder
Click New.
The Add New Resource: "Untitled" pane opens.
Provide upload details in the following fields as appropriate:
a. Enter the name of the resource in the Resource Name field.
The following example is a reasonable way to specify the resource name if you are uploading a JDBC driver:
database_name Driver
database_name
Defines the name of the RDBMS. For example, Oracle Driver, MySQL Driver, or Sybase Driver.
b. Click Browse, navigate to the location where you saved the JAR file, and select the target file. This populates the Resource File field.
c. Select a user-specified module name from the Module Name drop-down list.
d. (Optional) Enter a description of the resource in the Resource Description field.
Verify your entry, and then click Save.
A line with your entry displays.
CA Process Automation copies the uploaded resource to the following paths:
install_dir/server/c2o/ext-lib
install_dir/server/c2o/.c2orepository/.c2oserverresources/lib
install_dir
Defines the directory on the server where the Domain Orchestrator was installed.
Restart the Domain Orchestrator.
When the Domain Orchestrator restarts, the system deploys all jars that you uploaded to the Domain Orchestrator Resources. That is, CA Process Automation puts the jars in the classpath of the Domain Orchestrator.
After mirroring occurs, restart all other Orchestrators.
The system deploys all uploaded jars to all Orchestrators. That is, the system puts the jars in the classpaths of the Orchestrators.
Note: For clustered Orchestrators, restart each node.
~Jennifer