Site icon IT Tutorial

ORA-12592: TNS bad packet

Hi,

Sometimes You can get “ORA-12592: TNS:bad packet ” error.

 

Details of error are as follows.

ORA-12592: TNS:bad packet
Cause: An ill-formed packet has been detected by the TNS software.
Action: For further details, turn on tracing and reexecute the operation.
If error persists, contact Oracle Customer Support.

 

 

This may have started after a recent upgrade to database version 11.2.0.4 or a new installation of 11.2.0.4 or 12.1.0.x

The cause was identified as unpublished  Bug 18841764 ORA-12592 TNS:BAD PACKET OR ORA-3137 (or many other “abort” type error codes).

The fix is included in 12.2.x On Windows.   Interim patches for this defect are available on most platforms for versions 11.2.0.4 and 12.1.0.x.

 

To solve this error, perform the following steps.

1. Apply Patch 18841764 available on 11.2.0.4 on various platforms. The patch does not conflict with any 11.2.0.4 PSU, so it can be applied on top of any 11.2.0.4 PSU.

2. The following workaround has been proven to resolve the issue (in most cases) until the patch can be applied, but with a warning and important note:

Add this parameter to the sqlnet.ora file at BOTH the origin (or client) and at the Database server / instance:

SQLNET.SEND_TIMEOUT=n

* Where n is a value in seconds. The setting itself, and not the value, should resolve this issue, so a relatively high setting should eliminate this problem but with no impact to normal functions.

E.g.

SQLNET.SEND_TIMEOUT=60000

 

 

Or This error may be related with the Firewall settings.

To solve this error, Disable the firewall in Windows or Linux reading the following post.

 

 

Do you want to learn more details about RMAN, then read the following articles.

https://ittutorial.org/rman-backup-restore-and-recovery-tutorials-for-beginners-in-the-oracle-database/

 

Exit mobile version