Setting up an Oracle database instance

To set up an Oracle database instance, take the following steps:

1. Access the DEST wizard.
2. On the Database Information wizard screen, under Database Types, select Oracle.

   The dialog refreshes to show information fields related to the Oracle Group.

3. Complete the following fields in the Oracle Group section:
   • Oracle home: The location of the ojdbc JAR file. Click Browse to locate the ojdbc5.jar file.
   • Database Name: The service name.
     Note: To find the services, use the lsnrctl utility. For example, if Oracle is installed on a Linux machine, run the command lsnrctl serv.
   • Database Administrator User: The user ID that has administrative privileges for this database.
   • Database Administrator Password: The password for the Database Administrator user.
   • Application Database User: The database user who owns the InfoSphere® MDM Custom Domain Hub database objects created in this Oracle database, such as tables, triggers, and indexes.
   • Application Database Password: The password for the Application Database user.
   • Database Host Name: The Oracle database host:
     • When the Oracle database is on the same machine where WebSphere® Application Server (WAS) and Rational® Software Architect (RSA) are installed, enter LOCALHOST or an IP address as the value for this field.
     • When Oracle database server is installed on a remote machine, enter the IP address of the machine where Oracle database server is running.
   • Database Port: The network port that the Oracle database listener uses. The default value for this field is 1521.
   • TNS Name: The net_service_name stored in the file tnsnames.ora. For example, if the value of this field is ORCL_QA, the corresponding tnsnames.ora file entry would be:

     ORCL_QA=
       (DESCRIPTION =
         (ADDRESS = (PROTOCOL = TCP)(HOST = <IP_address>)(PORT = <port>))
         (CONNECT_DATA =
           (SERVER = DEDICATED)
           (SERVICE_NAME = <service_name>)
         )
       )

   • Test Connection: This value validates the following:

     sqlplus -L <Database Administrator User>/<Database Administrator Password>@
          //<Database Host Name>:<Database Port>/Database Name 

     sqlplus -L <Database Administrator User>/<Database Administrator Password>@
     //<TNS Name>

     The result of this connection validation is a message box that states whether the test was successful or caused an input error. You can not proceed to the next step until you successfully validate the connection.
4. Click Next to complete this section of the DEST wizard and continue.