首页 » ORACLE » Troubleshooting 11.2.0.4 show error ORA-12592, ORA-3137, ORA-3106

Troubleshooting 11.2.0.4 show error ORA-12592, ORA-3137, ORA-3106

Network/TTC related error ORA-12592, ORA-3137, ORA-3106 may be signaled on SQL*Net TCP/IP transport.
Usually this problem is seen with following circumstances.
Sending large size data to database server, for example, using sqlldr, expdp
– Database version is 11.2.0.4

Rediscovery Information:
If you see ORA-12592, ORA-3137, ORA-3106 when large size data is passed via SQL*Net
using TCP/IP protocol, and no problem is seen on network itself, you might hit this problem.

Workaround
Set sqlnet.send_timeout to any value except 0 on a side which receives large data.
Simply setting this parameter on server and client is good.
Very large value acts as workaround well, thus if you want to workaround problem with
minimum change, setting large value is recommended.

For database version 11.2.0.4 and above, you may encounter this error during a SQL*Net TCP/IP transport.
To determine if you encountered this bug, check your alert log for
ORA-12592 or ORA-3106
and check your incident trace file for
‘SQL*Net TCP/IP’ or ‘TCP/IP’

If any of these exist, proceed with the solution below:
1.The fix for 18841764 will be included in 12.2 database release. This was not available at the time of writing.
2.Download and apply patch 18841764 if it is available for your platform.
3.Workaround the error by setting sqlnet.send_timeout to any value except 0 on the server and client.
In a previous incident setting it to 600 resolved the issue.

Note a few prerequisites:
1,  network no problem
2, send large size data Via SQL*Net
3, db alert show error and trace show TCP/IP

what’s SQL*Net?

SQL*Net (or Net8) is Oracle‘s networking software that allows remote data access between programs and the Oracle Database, or among multiple Oracle Databases. Applications and databases can be distributed physically to different machines and continue to communicate as if they were local.

Client configuration
The Oracle Client software is required on workstations and servers that need to connect to remote Oracle Databases.

Server configuration
The cornerstone of SQL*Net is a process called the listener.

打赏

, ,

目前这篇文章还没有评论(Rss)

我要评论