ORA-12203: TNS:unable to connect to destination
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: ORA-12203: TNS:unable to connect to destination

Hybrid View

  1. #1
    Join Date
    Sep 2002
    Posts
    17

    ORA-12203: TNS:unable to connect to destination

    Recently, we've suddenly starting getting this error message when users are trying to connect to our production database from remote clients. However, by the time we are notified we can login without any problems. It is very hard to diagnose this error as we cannot reproduce it. Occasionally, this occurs (several times per week) and is causing production jobs to fail (they have to restarted and usually they are fine). We are using ONames and Oracle8i on Solaris. Has anyone encountered a similar situation and any recommendations?
    Thanks.

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    My initial (help desk educated) gut feeling tells me this is a networking issue. Try pinging the server the next time this happens and see if it times out intermittantly. Net-Op into one of the problem workstations and ping the server from there.

    Aside from that, did you check your alert.log, is the listener going down?

    MH
    I remember when this place was cool.

  3. #3
    Join Date
    Sep 2002
    Posts
    17
    Alert.log does not show any errors. Listener is not going down. The only other thing is the sqlnet.log shows TNS-12547 and TNS-12537. This error occurs for such a small period of time that by the time we notice it it no longer is a problem.

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,027
    Originally posted by axe
    Alert.log does not show any errors. Listener is not going down. The only other thing is the sqlnet.log shows TNS-12547 and TNS-12537. This error occurs for such a small period of time that by the time we notice it it no longer is a problem.
    Look in the sqlnet.ora and the listener.ora for a timeout parameter. If there is a timeout parameter you may want to either increase the number or set it to 0 for infinite. It could be that from time to time there is an increase in network latency If Oracle doesn't wait long enough it might give you that error message. Just a thought.

  5. #5
    Join Date
    Jan 2001
    Posts
    3,131
    Can you stay logged in via your SQL session?
    If you can, than this adds to my initial theory that it is a network glitch.

    I had a DB that had users based at a remote location and they had the same problem, this was due to network problems at the site. When I logged in from my W/S there were no problems. So, as much as they say it is, it is NOT always an Oracle problem.

    MH
    I remember when this place was cool.

  6. #6
    Join Date
    Sep 2002
    Posts
    17
    Alert.log does not show any errors. Listener is not going down. The only other thing is the sqlnet.log shows TNS-12547 and TNS-12537. This error occurs for such a small period of time that by the time we notice it it no longer is a problem.

  7. #7
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Maybe you are having some net8 issues. Try using SQL.EXPIRE=10 in your sqlnet.ora on your server. That might fix this problem
    Also, look at your listener.log
    "High Salaries = Happiness = Project Success."

  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by jlakhani
    Maybe you are having some net8 issues. Try using SQL.EXPIRE=10 in your sqlnet.ora on your server. That might fix this problem
    Also, look at your listener.log
    does that parameter exist?

  9. #9
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Pando. its actually sqlnet.expire_time....
    "High Salaries = Happiness = Project Success."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width