-
I am trying to connect to my server however I get the following error:-
ORA-12203: TNS:unable to connect to destination
I can log onto the server using SQLPlus with the same SQL-Net Alias owever using another application I am unable to connect.
I've checked my tnsnames.ora and as far as i can tell everything is OK
Please Help
Thankyou
Hummy
-
In my vast Oracle experience (all 6 weeks) whenever I had this problem I had to specify the entire connect string.
instance.oracledb.mycompany.com
Hope this helps.
MH
-
Try doing tnsping and confirm that your connection to the host reaches. Use the same application user name and password and try connecting to the instance through sqlplus.
Check your tnsnames.ora and sqlnet.ora files to see there are no decrepsencies in the parameters... Make sure the service name defined in the tnsnames.ora was what used in establishing the connection. Confirm that the listener for that service is up and running. In the tnsnames.ora, if the CONNECT_DATA(service...), try changing it to CONNECT_DATA(SID=instance name on the db server)
Hope these might help you to trouble shoot things
Sam
Thanx
Sam
Life is a journey, not a destination!
-
I just had the same error. I was working with WinNT and 8.1.7.1
The following thread was who I fixed my error:
http://www.dbasupport.com/forums/sho...threadid=13557
Gary
-
I tried the tnsping and it was working fine, however from the client machine
there was TNS-12541: TNS:no listener
Then I thought may be the proxy server is the problem, unsinstalled the proxy
on the server, then the server get the No listener message too.
I reinstalled the proxy and still have no access to the database from the Server
and the client machine.
-
check the sqlnet.ora for the names.default_domain sometimes it creates problem if u have a different db_domain in the initSID.ora.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|