Configuring Control Center Director to use Oracle database schemas
To specify database connection details, on Linux and UNIX operating systems run config.sh and provide the following database connection information:
| Database Connection Parameter | Description |
|---|---|
| Database Host Name |
In case of multimode Oracle RAC, host name of all nodes. |
| Database port |
The port number on which database server listens on. Typically, the port is 1521. In case of multimode Oracle RAC, enter 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 | |
| Database password for the DB User | |
|
Database Name (SID for non-RAC or Service Name for Oracle RAC) |
|
| JDBC Drivers |
These drivers are thin client-based, pure Java JDBC drivers. Copy one of these files to the server where IBM Control Center Director 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 config.sh:
| Configuration Prompt | Description |
|---|---|
|
Is your database in an Oracle RAC environment? |
Enter Y |
|
How many nodes are in your cluster? |
Enter 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 above. |
|
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 above. |