Database Networking (MOSC)

MOSC Banner

ORA-12592 error reported intermittently with Clients after patching the Database to 11.2.0.4 or 12.1

edited Mar 23, 2016 10:15AM in Database Networking (MOSC) 3 comments

Hi all,

If you have patched your Database up to 11.2.0.4 or 12.1 or have a new installation of these versions, you may find that you start getting ORA-12592 errors reported on the Client side.

There may also be other errors or issues such as aborts or timeouts (Client and/or DB side).


This is most likely caused by the following:

Bug 18841764 - Network related error like ORA-12592 or ORA-3137 or ORA-3106 may be signaled (Doc ID 18841764.8)

As an immediate fix pending patching, simply add (or edit) the following single line to the sqlnet.ora file:

SQLNET.SEND_TIMEOUT = 6000

*NOTES:

- This would be done on both Database and Client (if the Client uses SQL*Net to connect)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center