Home » RDBMS Server » Networking and Gateways » ora-12203 (ORACLE DATEBASE 9I, FORMS RUNTIME 6I)
ora-12203 [message #421270] Mon, 07 September 2009 03:19 Go to next message
emadnabil
Messages: 163
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
Re: ora-12203 [message #421271 is a reply to message #421270] Mon, 07 September 2009 03:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
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.

Regards
Michel
Re: ora-12203 [message #421274 is a reply to message #421270] Mon, 07 September 2009 03:40 Go to previous messageGo to next message
emadnabil
Messages: 163
Registered: August 2007
Senior Member
Please tell me what should I do?
Re: ora-12203 [message #421277 is a reply to message #421274] Mon, 07 September 2009 03:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ora-12203 [message #421361 is a reply to message #421274] Mon, 07 September 2009 20:23 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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.
Re: ora-12203 [message #421415 is a reply to message #421361] Tue, 08 September 2009 03:43 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Post your TNSPing output & Post your TNS Entry
Re: ora-12203 [message #422851 is a reply to message #421274] Sun, 20 September 2009 19:08 Go to previous message
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:
  


Current Time: Thu Dec 08 01:53:34 CST 2016

Total time taken to generate the page: 0.09185 seconds