Databases
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