ORA-24324: service handle not initialized [message #602365] |
Tue, 03 December 2013 08:08 |
k_mitra100
Messages: 28 Registered: October 2007 Location: Kolkata
|
Junior Member |
|
|
I am updating bulk amount of rows from a java program and this program is executed from shell script.
From a feed source table it is reading data and validating it by giving some more call to database and finally calling vendor given API to update a complete transaction.
Shell script is executed in parallel (10 instances).
When load is high (say 15000 records are processed and they are divided in 10 group and at a time 10 records are processed at same time), following error is occurred:
Error obtained in fetching values from registry ORA-03114: not connected to ORACLE
30172:ERROR-----PFLogOCIUtils.pcc:0168:02/12/13 18:49:43 > OCI_ERROR
30172:ERROR-----PFLogOCIUtils.pcc:0169:02/12/13 18:49:43 > ORA-24324: service handle not initialized
Error obtained in fetching values from registry ORA-03114: not connected to ORACLE
30172:ERROR-----PFLogOCIUtils.pcc:0175:02/12/13 18:49:43 > OCI_INVALID_HANDLE
ERROR-----sqlca.h:0128:02/12/13 18:49:43 > GDB_ORACLE_ERROR -12537 ORA-12537: TNS:connection closed
30172:ERROR-----PFLogOCIUtils.pcc:0175:02/12/13 18:49:43 > OCI_INVALID_HANDLE
Error obtained in fetching values from registry ORA-03114: not connected to ORACLE
30172:ERROR-----PFLogOCIUtils.pcc:0175:02/12/13 18:49:43 > OCI_INVALID_HANDLE
ERROR-----GDBconnect.pc:0456:02/12/13 18:49:43 > GDB_CONNECT_ORA_ERR
Can anyone please help me in this regard?
Regards,
[Updated on: Tue, 03 December 2013 08:09] Report message to a moderator
|
|
|