Thursday, October 23, 2008

Unix Oracle database core file

Scenario:
The Scheduler,Call Object,Queue Kernels were crashing inside OCI code with the following call stack...

Core was generated by `jdenet_k 6014'.
Program terminated with signal 11, Segmentation fault.
#0 0x00000000 in ?? ()
(gdb) where
#0 0x00000000 in ?? ()
#1 0xf2a06506 in ttcdrv () from /oracle/product/10.2.0/client_1/lib32/libclntsh.so.10.1
#2 0xf28a7c91 in nioqwa () from /oracle/product/10.2.0/client_1/lib32/libclntsh.so.10.1
#3 0xf2719862 in upirtrc () from /oracle/product/10.2.0/client_1/lib32/libclntsh.so.10.1
#4 0xf26b0519 in kpurcsc () from /oracle/product/10.2.0/client_1/lib32/libclntsh.so.10.1
#5 0xf266c7ea in kpuexecv8 () from /oracle/product/10.2.0/client_1/lib32/libclntsh.so.10.1
#6 0xf266eb90 in kpuexec () from /oracle/product/10.2.0/client_1/lib32/libclntsh.so.10.1
#7 0xf26e336a in OCIStmtExecute () from /oracle/product/10.2.0/client_1/lib32/libclntsh.so.10.1
#8 0xf308c6df in BFOCIStmtExecute () from /jdedwards/e812/system/lib/libora101.so
#9 0xf30858ad in performRequestInternal () from /jdedwards/e812/system/lib/libora101.so
#10 0xf30861f7 in DBPerformRequest () from /jdedwards/e812/system/lib/libora101.so
#11 0xf7d34e47 in JDB_DBPerformRequest () from /jdedwards/e812/system/lib/libjdb.so
#12 0xf79db157 in TM_DBPerformRequest () from /jdedwards/e812/system/lib/libtransmon.so
#13 0xf7d3aa1e in SelectKeyed () from /jdedwards/e812/system/lib/libjdb.so
#14 0xf7d3c882 in FetchKeyed () from /jdedwards/e812/system/lib/libjdb.so
#15 0xf7d3df02 in JDB_FetchKeyed () from /jdedwards/e812/system/lib/libjdb.so
#16 0xf7ba86bb in jdeSCFetchControlRecord () from /jdedwards/e812/system/lib/libjdeschr.so
#17 0xf7ba4213 in jdeSCJobLauncher () from /jdedwards/e812/system/lib/libjdeschr.so
#18 0xf7b9dc68 in JDEK_DispatchScheduler () from /jdedwards/e812/system/lib/libjdeschr.so
#19 0xf7ef8d04 in callDispatchFunction () from /jdedwards/e812/system/lib/libjdenet.so

If you are facing a crash in your application running on Unix[be it HP Unix,AIX, Solaris etc.,] while connecting to Oracle database make sure that the Oracle client installed on that machine is of same version as the Oracle Database and your application is linked to the same version of libraries.

Related: Analyzing core dumps in AIX

No comments: