ORA-07445

Nutss
Дата: 08.06.2006 09:14:50
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

Раз в сутки происходит вот такая ошибка
Thu Jun  8 04:52:28 2006
Errors in file /opt/oracle/app/admin/BILL3/bdump/bill3_s000_12937.trc:
ORA-07445: обнаружено прерывание: core dump [qmhGetVersionString()+17] [SIGSEGV] [Address not mapped to object] [0xC5C] [] []
Thu Jun  8 04:52:39 2006
found dead shared server 'S000', pid = (11, 106)
Thu Jun  8 04:52:41 2006
Errors in file /opt/oracle/app/admin/BILL3/bdump/bill3_s000_4965.trc:
ORA-00942: таблица или представление пользователя не существует

в trc файле
[root@db bdump]# cat /opt/oracle/app/admin/BILL3/bdump/bill3_s000_4965.trc
/opt/oracle/app/admin/BILL3/bdump/bill3_s000_4965.trc
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /opt/oracle/app/product/10.1.0
System name:    Linux
Node name:      db.dion.ru
Release:        2.4.26-std-smp-alt6
Version:        #1 SMP Tue Aug 3 20:29:56 MSD 2004
Machine:        i686
Instance name: BILL3
Redo thread mounted by this instance: 1
Oracle process number: 11
Unix process pid: 4965, image: oracle@db.dion.ru (S000)

*** SERVICE NAME:(SYS$USERS) 2006-06-08 04:52:41.223
*** SESSION ID:(223.59726) 2006-06-08 04:52:41.223
XML DB HTTP Server: Sending error response(HTTP error code = 401)
Error stack is:
ORA-00942: таблица или представление пользователя не существует

что это? в чем может быть причина?
SY
Дата: 08.06.2006 16:49:17
Well, ORA-07445 tells us an error occured in qmhGetVersionString(). SIGSEGV indicates segmentation fault whic caused shared server (I guess you are using MTS) to crash:

found dead shared server 'S000', pid = (11, 106)

I do not know if it is your case, but there is a bug 3243584 - Shared Servers Crash If Hs (Heterogeneous Services routine, which is used by external procedures) Session Can Migrate. Patch is available on MetaLink. In any case, ORA-07445 requires a TAR.

SY.
Nutss
Дата: 09.06.2006 07:57:32
Спасибо, SY!