Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Release Notes

Troubleshooting Connections to Oracle

Message Solution

Directory not in path

Ensure that the Oracle bin directory is specified in the path.

Enter the path command in the DOS prompt to check the path. If the directory is not in the path, add it to the path in autoexec.bat and reboot the system.

Oracle Required Support Files not installed

Ensure that at least one of the 32 bit Oracle Required Support Files are installed. These files are installed by default when you install any of the 32 bit Oracle products such as SQL*Net and SQL*Plus.

To verify whether the Required Support Files are installed, start the Oracle installer. All installed components are listed in the right side of the dialog box. If the Required Support Files do not appear on the right-hand side list box, install these files from Oracle software media.

Connect strings for local and remote database

If you are connecting to a local database use 2: (or a blank) as the connect string. If you are connecting to a remote database:

• Ensure that the 32 bit SQL*Net client is installed

• Ensure that the file tnsnames.ora has been properly configured using the SQL*Net Easy Configuration

• Ensure that proper network connectivity is available to the remote computer. Use the TNSPING Utility from Oracle. Open a command prompt and enter tnsping <instance name> 6. If correctly configured, SQL*Net responds with 6 OK messages and measured response times.

• Ensure that the SQL*Net listener application is running on the remote computer.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating