Configuring IBM Control Center to use Oracle database schemas

To configure IBM® Control Center to use Oracle database schemas, you need to specify database connection details.

Specify database connection details for the three different IBM Control Center database schemas using one of the following methods:
  • On Windows operating systems - Either as part of the installation or later when configCC is run, you can specify the database connection details for the three IBM Control Center database schemas.
  • On a UNIX operating system- After installing IBM Control Center, when you run configCC, you can specify the database details for the three IBM Control Center database schemas.
Provide the following database connection information when you are configuring IBM Control Center to use Oracle database schemas:
Table 1. Connection information for Oracle database schemas
DB connection information Description Note

Database Host Name

 

In case of multimode Oracle RAC, host name of all nodes

If you do not want to use a staging database, enter 0.0.0.0 as the database hostname for the staging database.

Database port

The port number on which database server listens on

Typically, the port is 1521.

In case of multimode Oracle RAC, this is the port number of all the nodes.

Ensure that the database server is listening on that port.

From the server where you are installing the IBM Control Center engine, you can try to establish a “telnet” connection to the db host and port.

telnet <<dbhost>> <<dbPort>>

Database User ID

 

When using the same Oracle instance for production, staging, and reports schemas, the user ID must be set for each schema.

Database password for the DB User

   

Database Name(SID for non-RAC or Service Name for Oracle RAC)

 

The same Oracle instance can be used for all three schemas.

JDBC Drivers

Use one of the following JDBC driver files: ojdbc5.jar or ojdbc6.jar.

These drivers are thin client-based, pure Java™ JDBC drivers.

Copy one of these files to the server where IBM Control Center will be installed

These files are located under <<oracleDBHome>>/ jdbc/lib.

To use Single Client Access Name (SCAN) feature of the Oracle RAC, provide the following settings when you run configCC:
Table 2. Oracle SCAN configuration
Setting question Description Note
Is your database in an Oracle RAC environment? Specify Y.  
How many nodes are in your cluster Specify 1. Only one node should be in the Oracle RAC if SCAN is used.
Provide the database host name for cluster host #1 Specify the host name of the Oracle node that enables the SCAN feature. The host name should be the same as the Database Host Name specified in Table 1.
Provide the database port number for cluster host #1 Specify the port number of the Oracle node that enables the SCAN feature. The port number should be the same as the Database port specified in Table 1.