Sometimes You can get “TNS-12592: TNS:bad packet ” error.
Details of error are as follows.
TNS-12592: TNS:bad packet
This may have started after a recent upgrade to database version 220.127.116.11 or a new installation of 18.104.22.168 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 22.214.171.124 and 12.1.0.x.
To solve this error, perform the following steps.
1. Apply Patch 18841764 available on 126.96.36.199 on various platforms. The patch does not conflict with any 188.8.131.52 PSU, so it can be applied on top of any 184.108.40.206 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:
* 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.
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.
1,783 views last month, 1 views today