| ora-12203 [message #421270] |
Mon, 07 September 2009 03:19  |
emadnabil
Messages: 52
Registered: August 2007 |
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  |
Michel Cadot
Messages: 29419
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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 #421277 is a reply to message #421274] |
Mon, 07 September 2009 03:44 |
Michel Cadot
Messages: 29419
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
- 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 #422851 is a reply to message #421274] |
Sun, 20 September 2009 19:08 |
linlasj
Messages: 74
Registered: August 2005
Location: Linköping |
Member |
|
|
emadnabil wrote on Mon, 07 September 2009 10:40Please 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]
|
|
|
] 
Members
Search
Help
Register
Login
Home
