OraFAQ Forum: Precompilers, OCI & OCCI » 11g pro*c appliation crashes while 10g is ok, why?

Home » Developer & Programmer » Precompilers, OCI & OCCI » 11g pro*c appliation crashes while 10g is ok, why? (AIX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

11g pro*c appliation crashes while 10g is ok, why? [message #382768]

Sat, 24 January 2009 09:01

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

Report message to a moderator

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

Michel Cadot
Messages: 68756
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Do you think there is enough information to answer?

Regards
Michel

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68756
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Are there bugs? No doubt, the answer is yes.

Regards
Michel

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

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.

Report message to a moderator

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

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 ?

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	Indicator Values for DATES
Next Topic:	Getting trailing characters inserted for the blob data.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 10 20:11:45 CDT 2025