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 22.214.171.124 or a new installation of 126.96.36.199 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 188.8.131.52 and 12.1.0.x.
To solve this error, perform the following steps.
1. Apply Patch 18841764 available on 184.108.40.206 on various platforms. The patch does not conflict with any 220.127.116.11 PSU, so it can be applied on top of any 18.104.22.168 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.
986 views last month, 3 views today