OraFAQ Forum: Networking and Gateways » ora-12203:TNS: unable to connect to destination

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-12203:TNS: unable to connect to destination [message #568833]

Wed, 17 October 2012 01:30

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

Report message to a moderator

Re: ora-12203:TNS: unable to connect to destination [message #568837 is a reply to message #568833]

Wed, 17 October 2012 01:50

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Code: [Select all] [Show/ hide]

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

Report message to a moderator

Re: ora-12203:TNS: unable to connect to destination [message #568842 is a reply to message #568837]

Wed, 17 October 2012 02:12

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

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: ora-12203:TNS: unable to connect to destination [message #568852 is a reply to message #568846]

Wed, 17 October 2012 02:42

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,

Report message to a moderator

Re: ora-12203:TNS: unable to connect to destination [message #568858 is a reply to message #568852]

Wed, 17 October 2012 03:25

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

Could it be Windows security? Win7 can be awkward about permitting network connections.

Report message to a moderator

Previous Topic:	Monitor Clients IP
Next Topic:	Getting error ORA-12560: TNS:protocol adapter error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 19:41:24 CDT 2025