Home » RDBMS Server » Networking and Gateways » ORA-12203
ORA-12203 [message #219209] Tue, 13 February 2007 10:15 Go to next message
Messages: 21
Registered: September 2006
Location: UK
Junior Member
I've just installed Oracle 8i client on my PC - I can use SQL+ to access all the database instance on the tnsnames.ora file so no problem with my tnsnames.ora working.

I've also just installed Quest Toad for Oracle (vers and on trying to log in I'm getting an ORA-12203 error.

Toad is trying to connect using the DEFAULT_HOME (Oracle Root).

The only change I've made is setting up a new environment variable TNS_ADMIN with a hard-coded reference to the C:\orant\network\ADMIN folder.

Any advice / suggestions on how to clear the Toad error?
Re: ORA-12203 [message #219213 is a reply to message #219209] Tue, 13 February 2007 10:24 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

ORA-12203: TNS:unabel to connect to destination.

1.Are you sure correct tnsnames.ora file is point. i think you have more than one oracle_home or tnsnames.ora files in your system.

2.check firewall setting ON SERVER.


Previous Topic: JDBC Connectivity problem
Next Topic: ora-03134 when connecting from 10gR2 to 8.1.7
Goto Forum:

Current Time: Fri Jul 28 06:36:09 CDT 2017

Total time taken to generate the page: 0.12447 seconds