Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007

    Unanswered: how to solve ora-12170

    hi there

    i am facing ora-12170 error when i am connecting to the database...

    so can any one help me please


  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    It might be a firewall issue, then again it might be something different.
    12170, 00000, "TNS:Connect timeout occurred"
    // *Cause:  The server shut down because connection establishment or
    // communication with a client failed to complete within the allotted time
    // interval. This may be a result of network or system delays; or this may
    // indicate that a malicious client is trying to cause a Denial of Service
    // attack on the server.
    // *Action: If the error occurred because of a slow network or system,
    // reconfigure one or all of the parameters SQLNET.INBOUND_CONNECT_TIMEOUT,
    // SQLNET.SEND_TIMEOUT, SQLNET.RECV_TIMEOUT in sqlnet.ora to larger values.
    // If a malicious client is suspected, use the address in sqlnet.log to
    // identify the source and restrict access. Note that logged addresses may
    // not be reliable as they can be forged (e.g. in TCP/IP).
    Are you incapable or unwilling to use GOOGLE?
    Last edited by anacedent; 12-30-07 at 17:40.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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