| oracle Ora-12203 cannot connect to the destination [message #113239] |
Thu, 31 March 2005 15:54  |
fengq
Messages: 38
Registered: October 2002
|
Member |
|
|
Hi Experts
we had oracle 8.0.5 database on NT just got migrated to windows 2000 server with 9i EE. the clients are in local network domain connect to db fine. but we have one client outside of our network, we opened firewall and port 1521 for this client, the client used to connect no problem until we did the migration. I can do TNSPING get OK no problem, even sqlplus get a time out error. I wonder there is difference on network settings bewteen 8i and 9i? I used the same listener.ora, sqlnet.ora network\admin as old one. in client side they use TNSNAMES to connect as this:
DB.world
=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=edpower.world)(PROTOCOL=TCP)(Host=165.222.32.23)(Port=1521)))(CONNECT_DATA=(SID=DB)(G LOBAL_NAME=DB.world)))
in our side, we use a different global name, other than that, everything remained the same. I don't know why it couldn't get connected any more.
|
|
|
|
|
|
| Re: oracle Ora-12203 cannot connect to the destination [message #116253 is a reply to message #113241] |
Mon, 18 April 2005 18:04  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi
ORA-12203 TNS:Unable to connect to destination
Cause: Invalid TNS address supplied or destination is not listening. This error can also occur because of underlying network transport problems.
Action: Verify that the service name you entered on the command line was correct. Ensure that the listener is running at the remote node and that the ADDRESS parameters specified in TNSNAMES.ORA are correct. Finally, check that all Interchanges needed to make the connection are up and running.
from:- sunil
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
