Check with your database administrator that the Oracle listener is running.
If the listener is running, is the Oracle ODBC driver connecting to the correct listener port?
By default, the Oracle ODBC driver tries to connect to the default listener port, 1521. However, when connecting to machines where multiple Oracle instances or versions are running, you may need to specify a different port. Check with your database administrator to find out the correct listener port. Specify this port with the Port
attribute in your ODBC data source. For example:
Port = 1522
You can use telnet
to check that you can connect to the listener port from your client machine. For example:
telnet myoracleserver 1522
If the listener is listening on the port you specify, the output is similar to:
Connected to myoracleserver Escape character is '^]'
To exit from telnet, type CTRL-] and then quit
.
If your output is different to this or a "Connection refused" error displays, the Oracle listener is not listening on the specified port.