Made from the SAP dataservices etl, often quote ora - 12592 error, but sometimes it can succeed, can't find the reason, the database information is as follows:

The PRODUCT VERSION STATUS
1 NLSRTL 11.2.0.4.0 Production
Two Oracle Database 11 g Enterprise Edition 64 - bit 11.2.0.4.0 Production
3 PL/SQL 11.2.0.4.0 Production
4 TNS for Linux: 11.2.0.4.0 Production


PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT
1 the DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED
2 the DEFAULT SESSIONS_PER_USER KERNEL UNLIMITED
3 the DEFAULT CPU_PER_SESSION KERNEL UNLIMITED
4 the DEFAULT CPU_PER_CALL KERNEL UNLIMITED
5 the DEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITED
6 the DEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITED
7 the DEFAULT IDLE_TIME KERNEL UNLIMITED
8 the DEFAULT CONNECT_TIME KERNEL UNLIMITED
9 the DEFAULT PRIVATE_SGA KERNEL UNLIMITED

CodePudding user response:

May be a firewall or network connection interruption, ping a try

CodePudding user response:

Excuse me solve the problem? How to solve the

CodePudding user response:

, I met today with PL/SQL also checked on the net, I am using this method, on the server and the client file sqlnet. Add sqlnet. Ora SEND_TIMEOUT=600, after the restart PL/SQL, successfully imported, said this approach to restart to monitor online, but I don't have to restart to monitor,

CodePudding user response:

Try playing patch:
Bug 18841764

CodePudding user response:

Try to modify the packet size, may be not in the package is too big