Cisco Cisco Workload Automation 6.3 User Guide
18
Configuring the Oracle Database Adapter
Defining an Oracle Database Connection
Oracle DB Connection Tab
The
Oracle DB Connection
tab defines how CWA will access an Oracle database instance.
DB Instance
– The name of the Oracle database instance. This is also known as the SID.
Connection User
– The domain and name for the runtime user account that accesses the database instance.
Host Name
– The name of the machine hosting the Oracle database instance.
Port
– The port number used by the master to communicate with the database instance.
DB Version
– The version of the Oracle database being used. Only the 10g or 11i versions of Oracle are supported
by this adapter.
Kill Session on job abort
– Select this option to end the current session if the job aborts.
Override JDBC URL
– The basic connection information provided in the earlier fields is used to create the JDBC
URL displayed here. If you wish to modify the Oracle connection with additional options, select this option to add
custom options to the connection.
custom options to the connection.
Separate each connection option with a colon (:), e.g., 10.10.10.10:1521:vis. In most circumstances, the connection
requires no other modifications so this option would not be used.
requires no other modifications so this option would not be used.