Home » RDBMS Server » Networking and Gateways » ora-12203:TNS: unable to connect to destination (Server: Oracle Database 11g, developer 6i, Windows 7 64bit and Client : developer 6i, windows xp 32bit)
ora-12203:TNS: unable to connect to destination [message #568833] Wed, 17 October 2012 01:30 Go to next message
adeel_ans786
Messages: 22
Registered: September 2012
Location: United Arab Emirates
Junior Member
I install oracle database 11g and developer 6i on windows7 64bit server everything is working fine on the server and i install developer 6i on windows XP on client now i'm getting "ora-12203:TNS: unable to connect to destination" when trying to connect the server. i have check the TNSNAMES.ORA file the configuration is fine. then why i'm getting this message?

can any one help?

Regards
Re: ora-12203:TNS: unable to connect to destination [message #568837 is a reply to message #568833] Wed, 17 October 2012 01:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12203: TNS:unable to connect to destination
 *Cause: Invalid address specified or destination is not listening.
 This error can also occur because of underlying network or network
 transport problems.
 *Action: Verify that the net service name you entered was correct.
 Verify that the ADDRESS portion of the connect descriptor which
 corresponds to the net service name is correct.  Ensure that the
 destination process (for example the listener) is running at the
 remote node.

You have now 2 tnsnames.ora, one on each home, copy the correct one into the other home.

Regards
Michel
Re: ora-12203:TNS: unable to connect to destination [message #568842 is a reply to message #568837] Wed, 17 October 2012 02:12 Go to previous messageGo to next message
adeel_ans786
Messages: 22
Registered: September 2012
Location: United Arab Emirates
Junior Member
AGCEW =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = AGCEW)
)
)

i'm using the above TNS setting for the developer on the server it is working fine. and the same i copied to the client but on client it is not working.
i try to ping the server from the client side i'm able to ping the server but i'm not able to run the application.

i have check the listner on the server. that is also working.

Any help

[Updated on: Wed, 17 October 2012 02:15]

Report message to a moderator

Re: ora-12203:TNS: unable to connect to destination [message #568846 is a reply to message #568842] Wed, 17 October 2012 02:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Either
- your client can't reach this IP
- your client reaches this IP but for another server
- your client does not point to this tnsnames.ora to connect

Regards
Michel
Re: ora-12203:TNS: unable to connect to destination [message #568852 is a reply to message #568846] Wed, 17 October 2012 02:42 Go to previous messageGo to next message
adeel_ans786
Messages: 22
Registered: September 2012
Location: United Arab Emirates
Junior Member
1. i have check on the server the ip is same
2. i have tried with server name also "ftp-server"
3. on a client i have two tnsnames.ora file i have updated the both

but still getting the same error message

please help me with this issue?

Regards,
Re: ora-12203:TNS: unable to connect to destination [message #568858 is a reply to message #568852] Wed, 17 October 2012 03:25 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Could it be Windows security? Win7 can be awkward about permitting network connections.
Previous Topic: Monitor Clients IP
Next Topic: Getting error ORA-12560: TNS:protocol adapter error
Goto Forum:
  


Current Time: Thu Mar 28 06:25:54 CDT 2024