SIGSEGV - HP-UX 11.31 Oracle error ORA-00445 (348 Views)
Reply
Occasional Visitor
p0r0p3z4
Posts: 2
Registered: ‎06-06-2014
Message 1 of 4 (348 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

Acclaimed Contributor
Dennis Handly
Posts: 25,290
Registered: ‎03-06-2006
Message 2 of 4 (299 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.

Occasional Visitor
p0r0p3z4
Posts: 2
Registered: ‎06-06-2014
Message 3 of 4 (282 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. 

 

Acclaimed Contributor
Dennis Handly
Posts: 25,290
Registered: ‎03-06-2006
Message 4 of 4 (276 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.

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.