Operating System - HP-UX
1748132 Members
3503 Online
108758 Solutions
New Discussion

SIGSEGV - HP-UX 11.31 Oracle error ORA-00445

 
p0r0p3z4
Visitor

SIGSEGV - HP-UX 11.31 Oracle error ORA-00445

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

3 REPLIES 3
Dennis Handly
Acclaimed Contributor

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.

p0r0p3z4
Visitor

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. 

 

Dennis Handly
Acclaimed Contributor

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.