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:
- Open a MS-DOS window.
- Change to the drive and directory where the Optim software was installed (usually,
C:\Program Files\IBM Optim\RT\BIN).
- 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