Home » Developer & Programmer » JDeveloper, Java & XML » ORA-24324: service handle not initialized (Oracle 10g, Java 1.6.0_24, Linux 2.6.18-348.6.1.el5)
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

Previous Topic: Licensing for Java Development
Next Topic: how to get last record value from a xml file
Goto Forum:
  


Current Time: Thu Mar 28 10:12:52 CDT 2024