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: 

core dump files generated when we issue sqlplus command on HP-UX 11.31 Virtual machine

Gaby1110
Frequent Advisor

core dump files generated when we issue sqlplus command on HP-UX 11.31 Virtual machine

Hi,

We are continuously getting core dump files generated, when we issue sqlplus command from the HP-UX Virtual machine running 11.31 and also bus error messages. Pls see the below message from server.

$ sqlplus "/ as sysdba"
Illegal instruction(coredump)

$ rm -f corea

$ sqlplus "/ as sysdba"

SQL*Plus:Release 10.2.0.4.0 - Production on Wed Oct 7 05:23:43 2009

Copyright (c) 1982,2007, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and real Application Testing options

SQL> select open_mode from v$database;

OPEN_MODE
---------
READ WRITE

Optimizing schema...
./dataimp.ksh[24]: 17007 Illegal instruction(coredump

Kindly help.

Thanks in advance
Gaby
4 REPLIES
Jean-Luc Oudart
Honored Contributor

Re: core dump files generated when we issue sqlplus command on HP-UX 11.31 Virtual machine

Hi

is this a new install ?
is this happening with other oracle utilies ?

found this previous (old) thread on sqlplus core.
http://forums11.itrc.hp.com/service/forums/questionanswer.do?admit=109447626+1254935786596+28353475&threadId=89079

Jean-Luc
fiat lux
Dennis Handly
Acclaimed Contributor

Re: core dump files generated when we issue sqlplus command on HP-UX 11.31 Virtual machine

Have you analyzed it with gdb? Can you get a stack trace?
gdb sqlplus core
Did it say you have a NaT fault?
Gaby1110
Frequent Advisor

Re: core dump files generated when we issue sqlplus command on HP-UX 11.31 Virtual machine

Hi,

Thanks for the reply... This is a virtual machine which we have installed using a net_recovery created from another virtual machine.

The following errors are seen in the alert log, and these errors disappeared when the server was rebooted.

But now we often see â Illegal instruction (core dump)â error and the sessions terminated and when we try the next time it works.

Errors in file /u00/oracle/admin/CRMTRIAL/bdump/crmtrial_psp0_3538.trc:

ORA-07445: exception encountered: core dump [$cold_ksmpga_update_size()+80] [SI

GILL] [Illegal opcode] [0x40000000037DD600] [] []

Thu Oct 8 00:39:55 2009

Errors in file /u00/oracle/admin/CRMTRIAL/bdump/crmtrial_pmon_3536.trc:

ORA-07445: exception encountered: core dump [$cold_qksceParamStrToNum()+880] [S

IGILL] [Illegal opcode] [0x400000000325B220] [] []

MMAN started with pid=4, OS id=3540

DBW0 started with pid=5, OS id=3543

LGWR started with pid=6, OS id=3545

SMON started with pid=8, OS id=3549

Thu Oct 8 00:39:56 2009

Errors in file /u00/oracle/admin/CRMTRIAL/bdump/crmtrial_ckpt_3547.trc:

ORA-07445: exception encountered: core dump [$cold_kspcrec()+2625] [SIGILL] [Il

legal opcode] [0x40000000020F4951] [] []

RECO started with pid=9, OS id=3551

CJQ0 started with pid=10, OS id=3553

MMON started with pid=11, OS id=3555

MMNL started with pid=12, OS id=3557

Thu Oct 8 00:39:58 2009

Errors in file /u00/oracle/admin/CRMTRIAL/bdump/crmtrial_ckpt_3547.trc:

ORA-07445: exception encountered: core dump [kgscDump()+801] [SIGSEGV] [Address

not mapped to object] [0x000001004] [] []

ORA-07445: exception encountered: core dump [$cold_kspcrec()+2625] [SIGILL] [Il

legal opcode] [0x40000000020F4951] [] []

Kindlu help

Thanks
Gaby
Jean-Luc Oudart
Honored Contributor

Re: core dump files generated when we issue sqlplus command on HP-UX 11.31 Virtual machine

Gaby

ORA-07445 is very generic error and is OS dependent.
I would suggest you log a SR with Oracle with the information you provided.
This could be a bug.

Regards
Jean-Luc
fiat lux