Oracle connection problems [message #8791] |
Thu, 25 September 2003 13:48 |
Derren Seah
Messages: 6 Registered: September 2003
|
Junior Member |
|
|
My machine has an Oracle 8.1.6 client connecting to an Oracle 9.2 database. Is there any reason why I can connect to the database using sql*plus, but not using TOAD (a third party product) ? Toad uses sql*net, not odbc. I have another machine with a 7.3.4 client which can connect using Toad. The Listener.ora, sqlnet.ora and Tnsnames.ora files are identical on both machines.
|
|
|
|
Re: Oracle connection problems [message #8797 is a reply to message #8794] |
Thu, 25 September 2003 15:05 |
Derren Seah
Messages: 6 Registered: September 2003
|
Junior Member |
|
|
The error message is Ora-12541 TNS: No Listener. I have checked the listener service and I can connect from sql*plus on my machine and from Toad on a different machine, just not from this machine. In Toad, everything listed in sql*net config is valid, and it says my installation is correct and no changes are necessary.
|
|
|
|
|