Re: SIGSEGV - HP-UX 11.31 Oracle error ORA-00445 (112 Views)
Reply
Occasional Visitor
p0r0p3z4
Posts: 2
Registered: ‎06-06-2014
Message 1 of 4 (184 Views)

SIGSEGV - HP-UX 11.31 Oracle error ORA-00445

[ Edited ]

Hi, HP Gurus

 

I'm having issues with an oracle data base in my productive environment when we try to bring up application after its weekly maintanance with command satartsap with adm app user id, we are getting the following error:

 

/usr/sap/environment/SYS/exe/run/startdb: Terminating with error code 12

 

And in the database alert log we see the oracle error ORA-00445, in fact the exact message in the log appears like:

 

USER (ospid: 513): terminating the instance due to error 445

 

I had open a ticket with response center and after running tusc, we catch the following error message:

 

[4805]   Received signal 11, SIGSEGV, in user mode, [caught], partial siginfo

[4805]     Siginfo: si_code: SEGV_MAPERR, faulting address: 0xffffffffbebea703, si_errno: 0

[4805]      PC: 00000001000000a0.0              break.m 0x16000

[4805] (0.000037) sigsetstatemask(0x17, 0x9ffffffffffc4ac0, 0) ............................................... = 0

[4805] (0.000035) sigaction(SIGBUS, 0x600000000016e700, NULL) ................................................ = 0

[4805] (0.000036) sigaction(SIGSEGV, 0x600000000016e730, NULL) ............................................... = 0

[4805] (0.000035) sigprocmask(SIG_SETMASK, 0x9ffffffffffc4990, NULL) ......................................... = 0

[4805] (0.000040) write(14, "k s e d m p ( ) + 6 4           ".., 62) ........................................ = 62

 

It looks like a memory faulting, oracle is recommending to install patch PHSS_40631, but I recently made a refresh of my productive environment in a sandbox server and we don't see same issue, problem is randonmly sometimes shows sometimes app came's up with no issues in my productive server.

 

Hope someone has any recommendation that can help me figure out how to fix this issue?

 

Thanks in advance for your help.

 

P.S. This thread has been moved from Community Feedback & Suggestions to HP-UX > databases. -HP Forum Moderator

Please use plain text.
Acclaimed Contributor
Dennis Handly
Posts: 24,888
Registered: ‎03-06-2006
Message 2 of 4 (135 Views)

Re: SIGSEGV - HP-UX 11.31 Oracle error ORA-00445

>I had open a ticket with response center and after running tusc

 

tusc is the wrong tool here, you need to use gdb and get a corefile and a stack trace.

 

>oracle is recommending to install patch PHSS_40631

 

Not sure how a newer compiler will help, unless you can rebuild your application.

Please use plain text.
Occasional Visitor
p0r0p3z4
Posts: 2
Registered: ‎06-06-2014
Message 3 of 4 (118 Views)

Re: SIGSEGV - HP-UX 11.31 Oracle error ORA-00445

Hi Dennis;

 

Thanks for reply, response center is recommending to run dumponsignalIA to obtained dump files, what do you mean by rebuilding my application?

 

Thanks. 

 

Please use plain text.
Acclaimed Contributor
Dennis Handly
Posts: 24,888
Registered: ‎03-06-2006
Message 4 of 4 (112 Views)

Re: SIGSEGV - HP-UX 11.31 Oracle error ORA-00445

>what do you mean by rebuilding my application?

 

Oracle's suggestion of installing PHSS_40631 will not help unless you already have purchased the aC++ compiler and can rebuild your applications.

Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation