oracle ora-27544,ORA-603,ORA-27544 问题原因讨论

ORA-603,ORA-27544 问题求助

版本：ORACLE9207

架构：ORACLE RAC + DATA GUARD

OS: HPUX 11.23

cluster:HP Service Guard A.11.17

出现错误时，告警日志文件报错如下：

Wed Dec 13 14:42:28 2006

ARC0: Evaluating archive   log 3 thread 1 sequence 210671

ARC0: Beginning to archive log 3 thread 1 sequence 210671

Creating archive destination LOG_ARCHIVE_DEST_2: 'standby'

Creating archive destination LOG_ARCHIVE_DEST_1: '/archlog1/1_210671.arc'

Wed Dec 13 14:42:29 2006

ARC1: Evaluating archive   log 3 thread 1 sequence 210671

ARC1: Unable to archive log 3 thread 1 sequence 210671

Log actively being archived by another process

Wed Dec 13 14:42:31 2006

ARC0: Completed archiving  log 3 thread 1 sequence 210671

Wed Dec 13 14:42:44 2006

Errors in file /oracle9/app/oracle/admin/odsb/udump/odsb1_ora_9192.trc:

ORA-00603: ORACLE server session terminated by fatal error

ORA-27544: Failed to map memory region for export

ORA-27300: OS system dependent operation:socket failed with status: 23

ORA-27301: OS failure message: File table overflow

ORA-27302: failure occurred at: sskgxpcre1

Wed Dec 13 14:42:45 2006

Trace dumping is performing id=[cdmp_20061213144245]

Wed Dec 13 14:42:49 2006

Errors in file /oracle9/app/oracle/admin/odsb/udump/odsb1_ora_9194.trc:

ORA-00603: ORACLE server session terminated by fatal error

ORA-27544: Failed to map memory region for export

ORA-27300: OS system dependent operation:socket failed with status: 23

ORA-27301: OS failure message: File table overflow

ORA-27302: failure occurred at: sskgxpcre1

Wed Dec 13 14:42:52 2006

Errors in file /oracle9/app/oracle/admin/odsb/udump/odsb1_ora_9196.trc:

ORA-00603: ORACLE server session terminated by fatal error

ORA-27544: Failed to map memory region for export

ORA-27300: OS system dependent operation:socket failed with status: 23

ORA-27301: OS failure message: File table overflow

ORA-27302: failure occurred at: sskgxpcre1

Wed Dec 13 14:42:55 2006

Errors in file /oracle9/app/oracle/admin/odsb/udump/odsb1_ora_9198.trc:

ORA-00603: ORACLE server session terminated by fatal error

ORA-27544: Failed to map memory region for export

ORA-27300: OS system dependent operation:socket failed with status: 23

ORA-27301: OS failure message: File table overflow

ORA-27302: failure occurred at: sskgxpcre1

Wed Dec 13 14:42:58 2006

Errors in file /oracle9/app/oracle/admin/odsb/udump/odsb1_ora_9200.trc:

ORA-00603: ORACLE server session terminated by fatal error

ORA-27544: Failed to map memory region for export

ORA-27300: OS system dependent operation:socket failed with status: 23

ORA-27301: OS failure message: File table overflow

ORA-27302: failure occurred at: sskgxpcre1

Wed Dec 13 14:42:59 2006

Trace dumping is performing id=[cdmp_20061213144250]

Wed Dec 13 14:43:00 2006

Trace dumping is performing id=[cdmp_20061213144250]

Wed Dec 13 14:44:26 2006

Errors in file /oracle9/app/oracle/admin/odsb/bdump/odsb1_lgwr_17770.trc:

ORA-00313: open failed for members of log group 2 of thread 1

ORA-00312: online log 2 thread 1: '/dev/vgsys/rlv_redo1_2'

ORA-27041: unable to open file

HPUX-ia64 Error: 23: File table overflow

Additional information: 2

Wed Dec 13 14:44:26 2006

Errors in file /oracle9/app/oracle/admin/odsb/bdump/odsb1_lgwr_17770.trc:

ORA-00313: open failed for members of log group 2 of thread 1

ORA-00312: online log 2 thread 1: '/dev/vgsys/rlv_redo1_2'

ORA-27041: unable to open file

HPUX-ia64 Error: 23: File table overflow

Additional information: 2

Wed Dec 13 14:44:26 2006

LGWR: terminating instance due to error 313

Wed Dec 13 14:44:26 2006

Errors in file /oracle9/app/oracle/admin/odsb/bdump/odsb1_lms2_17746.trc:

ORA-00313: open failed for members of log group  of thread

Wed Dec 13 14:44:26 2006

Errors in file /oracle9/app/oracle/admin/odsb/bdump/odsb1_lms0_17740.trc:

ORA-00313: open failed for members of log group  of thread

Wed Dec 13 14:44:26 2006

Errors in file /oracle9/app/oracle/admin/odsb/bdump/odsb1_lmd0_17734.trc:

ORA-00313: open failed for members of log group  of thread

Wed Dec 13 14:44:26 2006

Errors in file /oracle9/app/oracle/admin/odsb/bdump/odsb1_lms3_17748.trc:

ORA-00313: open failed for members of log group  of thread

Wed Dec 13 14:44:26 2006

Errors in file /oracle9/app/oracle/admin/odsb/bdump/odsb1_lmon_17732.trc:

ORA-00313: open failed for members of log group  of thread

Wed Dec 13 14:44:26 2006

Errors in file /oracle9/app/oracle/admin/odsb/bdump/odsb1_lms1_17742.trc:

ORA-00313: open failed for members of log group  of thread

Wed Dec 13 14:44:26 2006

System state dump is made for local instance

Wed Dec 13 14:44:29 2006

Trace dumping is performing id=[cdmp_20061213144426]

Wed Dec 13 14:44:31 2006

Instance terminated by LGWR, pid = 17770

Wed Dec 13 14:49:24 2006

Starting ORACLE instance (normal)

Wed Dec 13 14:49:24 2006

Global Enqueue Service Resources = 36677, pool = 16

Wed Dec 13 14:49:24 2006

Global Enqueue Service Enqueues = 54997

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

SCN scheme 3

Using log_archive_dest parameter default value

LICENSE_MAX_USERS = 0

SYS auditing is disabled