Oracle Connection Diagnostic Tool

The Oracle Connection Diagnostic Tool, ORACONN.EXE, is a utility that determines if Optim™ was installed correctly when it fails to connect to an Oracle database.

The syntax of the command follows:

ORACONN userid password TNSservicename

where

userid
Is the user ID used to connect to the Oracle database. The user ID must be defined in the Oracle database.
password
Is the password used to connect to the Oracle database. The password must be defined for the specified user ID in the Oracle database.
TNSservicename
Is the name of the service associated with the Oracle database.

Test Oracle database connection

To test the connection to an Oracle database:

  1. Open a MS-DOS window.
  2. Change to the drive and directory where the Optim software was installed (usually, C:\Program Files\IBM Optim\RT\BIN).
  3. Run the Oracle Connection Diagnostic Tool with the name of the TNS Service to which you wish to connect. For example, ORACONN internal password beq-local


Feedback