Home » Developer & Programmer » Precompilers, OCI & OCCI » 11g pro*c appliation crashes while 10g is ok, why? (AIX)
11g pro*c appliation crashes while 10g is ok, why? [message #382768] Sat, 24 January 2009 09:01 Go to next message
IndianScorpion
Messages: 8
Registered: January 2009
Junior Member
Hi,

My 10g pro*c application works perfectly, recently
I upgraded it to 11g, but it keep crashing, why?

How to resolve this issue?

Thanks,
Joe
Re: 11g pro*c appliation crashes while 10g is ok, why? [message #382769 is a reply to message #382768] Sat, 24 January 2009 09:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you think there is enough information to answer?

Regards
Michel
Re: 11g pro*c appliation crashes while 10g is ok, why? [message #382796 is a reply to message #382768] Sat, 24 January 2009 19:33 Go to previous messageGo to next message
IndianScorpion
Messages: 8
Registered: January 2009
Junior Member
Why I am posting this way is

I want to know if there any known bug for 11g to support pro*c?

Because my application works perfectly under 10g.
while compile using 11g it always crash on query, insert etc.
My app is linking the library clntsh

any idea?
Joe
Re: 11g pro*c appliation crashes while 10g is ok, why? [message #382808 is a reply to message #382796] Sun, 25 January 2009 01:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are there bugs? No doubt, the answer is yes.

Regards
Michel
Re: 11g pro*c appliation crashes while 10g is ok, why? [message #382956 is a reply to message #382808] Mon, 26 January 2009 13:22 Go to previous messageGo to next message
IndianScorpion
Messages: 8
Registered: January 2009
Junior Member
Further study my issue, found it crashed on opening cursor.

ORACLE is quite strange on if there's not enough cursor.
9i will give a error message.
10g will be ok, no error.
11g will crash.

I am really just confused.
should I add the MAXOPENCURSORS to specify the cursors?

Thanks,
Joe
Re: 11g pro*c appliation crashes while 10g is ok, why? [message #382975 is a reply to message #382956] Mon, 26 January 2009 19:58 Go to previous messageGo to next message
IndianScorpion
Messages: 8
Registered: January 2009
Junior Member
My env of 10g is:
$ ls -lt libclntsh.so*
lrwxrwxrwx 1 oracle oinstall 17 Nov 4 12:36 libclntsh.so -> libclntsh.so.10.1
-rwxrwxr-x 1 oracle oinstall 21524515 Nov 4 12:36 libclntsh.so.10.1

11g is
$ ls -lt libclntsh.so*
-rwxrwxr-x 1 oracle oinstall 36972682 Dec 4 11:42 libclntsh.so
-rwxrwxr-x 1 oracle oinstall 0 Nov 7 2007 libclntsh.so.11.1


why libclntsh.so.11.1 is size 0? Anything wrong with the env?

Urgent, Thanks,
Joe
Re: 11g pro*c appliation crashes while 10g is ok, why? [message #383191 is a reply to message #382975] Tue, 27 January 2009 11:54 Go to previous messageGo to next message
IndianScorpion
Messages: 8
Registered: January 2009
Junior Member
Is that because of the stack size?
I am still struggling for the oracle bug.
maybe I should wait for 11.2.0

Any ideas?
Joe
Re: 11g pro*c appliation crashes while 10g is ok, why? [message #383219 is a reply to message #383191] Tue, 27 January 2009 16:40 Go to previous messageGo to next message
IndianScorpion
Messages: 8
Registered: January 2009
Junior Member
Below is the core dump detail:
(gdb) bt
#0 0xd79e43e0 in skgdbgcra () from /vg12/vol1/oracle/app/oracle/product/11.1.0/client/lib32/libclntsh.a(shr.o)
#1 0xd7a44af0 in skgesigCrash () from /vg12/vol1/oracle/app/oracle/product/11.1.0/client/lib32/libclntsh.a(shr.o)
#2 0xd7a44e58 in skgesig_sigactionHandler () from /vg12/vol1/oracle/app/oracle/product/11.1.0/client/lib32/libclntsh.a(shr.o)
#3 <signal handler called>

Thanks,
Joe
Re: 11g pro*c appliation crashes while 10g is ok, why? [message #418277 is a reply to message #383219] Thu, 13 August 2009 15:39 Go to previous messageGo to next message
TSull
Messages: 1
Registered: August 2009
Junior Member
Ever find the source to your issue? I have a similar situation with an oracle 11 process I am building. Here is the stack trace:

=>[1] _kill(0x0, 0x6, 0x1, 0x3e388, 0x1d2a1e4, 0xfef6e308), at 0xfef4559c
[2] skgdbgcra(0x2, 0x249bef4, 0x1, 0x1d32d20, 0x1c4f018, 0x249bef0), at 0xbc1c54
[3] skgesig_sigactionHandler(0x1, 0xdac00, 0x8c70, 0x0, 0x0, 0x1), at 0xbc2934
[4] __sighndlr(0xb, 0x249d3b8, 0x249d100, 0xbc26d8, 0x0, 0x1), at 0xfef44b28
---- called from signal handler with signal 11 (SIGSEGV) ------
[5] srv__scheduler(0x249d480, 0x6dd298, 0xff36aa2c, 0x0, 0xff3f42f0, 0x0), at 0xff36cbd8
[6] srv__spawnfunc(0x1e449a8, 0x0, 0x0, 0x8, 0x1eb0fe8, 0x1ea22a4), at 0xff368dc4
[7] 0x1d2a0c0(0x301e947, 0x70000000, 0x1e927, 0x1801e634, 0x9801e90a, 0x88000000), at 0x1d2a0c0
[8] 0xb8024dd5(), at 0xb8024dd5

Any assistance is appreciated.
Re: 11g pro*c appliation crashes while 10g is ok, why? [message #428713 is a reply to message #383219] Thu, 29 October 2009 10:38 Go to previous messageGo to next message
skins4bowl
Messages: 1
Registered: October 2009
Junior Member
I am having similar issue. Can you please tell me did you resolve this issue in 11g ?
Re: 11g pro*c appliation crashes while 10g is ok, why? [message #461883 is a reply to message #428713] Tue, 22 June 2010 01:29 Go to previous message
sumit_goyal
Messages: 2
Registered: May 2008
Junior Member
Hi,

I am also facing the same issue.
Did anyone found a solution to it.

My stack trace is :-

#0 0xc0214128 in kill+0x10 () from /usr/lib/libc.2
#1 0xdc58fa18 in skgdbgcra+0x198 () from /isvdb/oracle/11.1.0.6/lib32/libclntsh.sl
#2 0xdc2ac0c0 in kpeDbgCrash+0x64 () from /isvdb/oracle/11.1.0.6/lib32/libclntsh.sl
#3 0xdc2ab314 in kpeDbgSignalHandler+0x224 () from /isvdb/oracle/11.1.0.6/lib32/libclntsh.sl
#4 0xdc29d088 in skgesig_sigactionHandler+0xe4 () from /isvdb/oracle/11.1.0.6/lib32/libclntsh.sl

This happens when i exit from the thread running the oracle query.

Regards,
sumit
Previous Topic: Indicator Values for DATES
Next Topic: Getting trailing characters inserted for the blob data.
Goto Forum:
  


Current Time: Fri Mar 29 05:02:07 CDT 2024