Cisco Cisco Process Orchestrator 3.1 User Guide
13-81
Cisco Process Orchestrator 3.1 User Guide
Appendix 13 Using Adapters
Database Adapter—Oracle
Defining an Oracle Database Target
Use the Oracle Database target to specify the connection information for an Oracle database. The
connection properties allows customers to connect to a standard Oracle Database target or an Oracle
Database target via RAC support. An Oracle client is required when connecting to a target requiring RAC
support.
connection properties allows customers to connect to a standard Oracle Database target or an Oracle
Database target via RAC support. An Oracle client is required when connecting to a target requiring RAC
support.
Step 1
Choose Definitions > Targets, right-click and choose New > Oracle Database.
Step 2
Click the General tab and enter the required information.
Step 3
Click the Connection tab and enter the required information.
Under the Connect to radio buttons, indicate the database connection type for the target and determine
whether to connect to a target requiring RAC support.
whether to connect to a target requiring RAC support.
•
Hostname—Select this radio button and enter the local network service name, hosting system, or IP
address and other relevant source information for the database.
address and other relevant source information for the database.
–
Port Number—Port number used to access Oracle database
–
SID—Oracle system ID used to identify the Oracle database
•
RAC via TNS—Select this radio button and enter the TNS connection string to indicate the RAC
target connection.
target connection.
Oracle 11g R2 64bit client is required for this connection and the tnsnames.ora is configured with
the TNS RAC target connection. For example, to specify the RAC via TNS connection, enter:
the TNS RAC target connection. For example, to specify the RAC via TNS connection, enter:
TNS RAC target connection name
Step 4
Click Connection Credentials and enter the necessary connection credentials to access the database,
including:
including:
•
Database Owner—Principal owner of the database
•
Default runtime user—The default runtime user account that contains the credentials to connect to
the target.
the target.
•
Connection string—The information needed to establish a connection to the database. For example,
this establishes a direct connection:
this establishes a direct connection:
Data Source=testserver;SID=oracle;port=1521;Unicode=true;
Step 5
Click the Permission tab to define the type of SQL commands that can run on the target.
Step 6
Click OK to close the dialog box and complete the procedure.
Automating Oracle Database Activities
Modifying Oracle DB Instance Case-Sensitive Settings
Use the following script to change the case-sensitive settings in the Oracle database.
Before You Begin
You must have database administrative rights to execute this script.