OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » ora-12203 (ORACLE DATEBASE 9I, FORMS RUNTIME 6I)

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

ora-12203 [message #421270]

Mon, 07 September 2009 03:19

emadnabil
Messages: 179
Registered: August 2007

Senior Member

Hii all
i have 2 home for oracle
the first one for the database
the second for the forms runtime

i can connect from the first one to the application
while from the second one i got

ora-12203:TNS:unable to connect to destination

the tnsnames are the same in both home

How can i resolve this?
thanks

Report message to a moderator

Re: ora-12203 [message #421271 is a reply to message #421270]

Mon, 07 September 2009 03:24

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

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.

Regards
Michel

Report message to a moderator

Re: ora-12203 [message #421274 is a reply to message #421270]

Mon, 07 September 2009 03:40

emadnabil
Messages: 179
Registered: August 2007

Senior Member

Please tell me what should I do?

Report message to a moderator

Re: ora-12203 [message #421277 is a reply to message #421274]

Mon, 07 September 2009 03:44

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

Senior Member
Account Moderator

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.

Regards
Michel

Report message to a moderator

Re: ora-12203 [message #421361 is a reply to message #421274]

Mon, 07 September 2009 20:23

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Please tell me what should I do?

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

Report message to a moderator

Re: ora-12203 [message #421415 is a reply to message #421361]

Tue, 08 September 2009 03:43

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Post your TNSPing output & Post your TNS Entry

Report message to a moderator

Re: ora-12203 [message #422851 is a reply to message #421274]

Sun, 20 September 2009 19:08

linlasj
Messages: 98
Registered: August 2005
Location: LinkÃ¶ping

Member

emadnabil wrote on Mon, 07 September 2009 10:40

Please tell me what should I do?

Please veryfy that the TNSNAMES.ORA are equal. Post the entry for the database you are trying to reach.

Also, post the output from the command
tnsping <database_you_are_trying_to_reach>

like this:

TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 21-SEP-2009 02:06:23

Copyright (c) 1997, 2007, Oracle.  All rights reserved.

Använde parameterfilerna:
c:\devsuitehome_1\NETWORK\ADMIN\sqlnet.ora


Använde adaptern TNSNAMES för att tolka aliaset
Attempting to contact (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=the_computer) (PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=the_db_you_are_trying_to_reach)))
TNS-12541: TNS: ingen lyssnare

In this case, there were no listner. Since I did not start it. You should, however, be able to get a response from the database. recognized via [OK] marks.

[Updated on: Sun, 20 September 2009 19:09]

Report message to a moderator

Previous Topic:	Error: ORA-12541: TNS:no listener while loging in to DB
Next Topic:	ora-12170: TNS :connect timeout occurred

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 29 11:14:41 CST 2025