Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

SIGSEGV - HP-UX 11.31 Oracle error ORA-00445

Highlighted
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
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.