Members   Search   Help    Register    Login   Home
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 29436
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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 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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 29436
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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 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
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 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
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 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
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 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
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 Go to previous messageGo to next message
tioco
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 Go to previous 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 ?
Report message to a moderator
Previous Topic:OCI Equivalent of EXEC SQL ROLLBACK RELEASE
Next Topic:to retrieve the metadata of prepared statement using OCI calls.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 1 19:50:26 CST 2009

Total time taken to generate the page: 0.42108 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.