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/

 

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *