当前位置:Gxlcms > mysql > HPUNIX11.31因为内存耗尽导致ORA-12549错误

HPUNIX11.31因为内存耗尽导致ORA-12549错误

时间:2021-07-01 10:21:17 帮助过:54人阅读

通过查询metalink给出了以下解决方案,目前系统交换分区跟内存一样都是8G,就没有扩充;最后通过在不过度影响数据库性能的方式减

有个数据库因为内存耗尽导致重启,,以下为alert日志记录的错误信息:

Mon Jun 13 15:27:47 EAT 2011

ERROR: Failed to connect with connect string:(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/Oracle/product/10.2.0/db_tmp/bin/oracle)(ARGV0=orac

le+ASM1)(ENVS='ORACLE_HOME=/oracle/product/10.2.0/db_tmp,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=

setuser))

ERROR: Failed to connect with connect string:(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/product/10.2.0/db_tmp/bin/oracle)(ARGV0=orac

le+ASM1)(ENVS='ORACLE_HOME=/oracle/product/10.2.0/db_tmp,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=

setuser))

ERROR: Failed to connect with connect string:(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/product/10.2.0/db_tmp/bin/oracle)(ARGV0=orac

le+ASM1)(ENVS='ORACLE_HOME=/oracle/product/10.2.0/db_tmp,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=

setuser))

ERROR: Failed to connect with connect string:(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/product/10.2.0/db_tmp/bin/oracle)(ARGV0=orac

le+ASM1)(ENVS='ORACLE_HOME=/oracle/product/10.2.0/db_tmp,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=

setuser))

Mon Jun 13 15:27:47 EAT 2011

Unexpected communication failure with ASM instance:

error 12549 (ORA-12549: TNS:operating system resource quota exceeded

)

NOTE: ASMB process state dumped to trace file /oracle/admin/scrk/bdump/scrk1_arc1_4251.trc

Mon Jun 13 15:27:48 EAT 2011

ERROR: Failed to connect with connect string:(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/product/10.2.0/db_tmp/bin/oracle)(ARGV0=orac

le+ASM1)(ENVS='ORACLE_HOME=/oracle/product/10.2.0/db_tmp,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=

setuser))

ERROR: Failed to connect with connect string:(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/product/10.2.0/db_tmp/bin/oracle)(ARGV0=orac

le+ASM1)(ENVS='ORACLE_HOME=/oracle/product/10.2.0/db_tmp,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=

setuser))

ERROR: Failed to connect with connect string:(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/product/10.2.0/db_tmp/bin/oracle)(ARGV0=orac

le+ASM1)(ENVS='ORACLE_HOME=/oracle/product/10.2.0/db_tmp,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=

setuser))

ERROR: Failed to connect with connect string:(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/product/10.2.0/db_tmp/bin/oracle)(ARGV0=orac

le+ASM1)(ENVS='ORACLE_HOME=/oracle/product/10.2.0/db_tmp,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=

setuser))

Mon Jun 13 15:27:49 EAT 2011

Unexpected communication failure with ASM instance:

error 12549 (ORA-12549: TNS:operating system resource quota exceeded

)

NOTE: ASMB process state dumped to trace file /oracle/admin/scrk/bdump/scrk1_arc1_4251.trc

Mon Jun 13 15:27:50 EAT 2011

Errors in file /oracle/admin/scrk/bdump/scrk1_arc1_4251.trc:

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

ORA-00312: online log 3 thread 1: '+SCRKDATA01/scrk/onlinelog/group_3.980.728931221'

ORA-17503: ksfdopn:2 Failed to open file +SCRKDATA01/scrk/onlinelog/group_3.980.728931221

ORA-12549: TNS:operating system resource quota exceeded

ORA-00312: online log 3 thread 1: '+SCRKDATA01/scrk/onlinelog/group_3.971.728928961'

ORA-17503: ksfdopn:2 Failed to open file +SCRKDATA01/scrk/onlinelog/group_3.971.728928961

ORA-12549: TNS:operating system resource quota exceeded

Mon Jun 13 15:27:50 EAT 2011

Errors in file /oracle/admin/scrk/bdump/scrk1_arc1_4251.trc:

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

ORA-00312: online log 3 thread 1: '+SCRKDATA01/scrk/onlinelog/group_3.980.728931221'

ORA-17503: ksfdopn:2 Failed to open file +SCRKDATA01/scrk/onlinelog/group_3.980.728931221

ORA-12549: TNS:operating system resource quota exceeded

ORA-00312: online log 3 thread 1: '+SCRKDATA01/scrk/onlinelog/group_3.971.728928961'

ORA-17503: ksfdopn:2 Failed to open file +SCRKDATA01/scrk/onlinelog/group_3.971.728928961

ORA-12549: TNS:operating system resource quota exceeded

Mon Jun 13 15:28:55 EAT 2011

Archiver process freed from errors. No longer stopped

Mon Jun 13 15:28:55 EAT 2011

Thread 1 advanced to log sequence 457996 (LGWR switch)

Current log# 3 seq# 457996 mem# 0: +SCRKDATA01/scrk/onlinelog/group_3.971.728928961

Current log# 3 seq# 457996 mem# 1: +SCRKDATA01/scrk/onlinelog/group_3.980.728931221

Mon Jun 13 15:28:55 EAT 2011

Process startup failed, error stack:

Mon Jun 13 15:28:55 EAT 2011

Errors in file /oracle/admin/scrk/bdump/scrk1_psp0_3767.trc:

ORA-27300: OS system dependent operation:fork failed with status: 11

ORA-27301: OS failure message: Resource temporarily unavailable

ORA-27302: failure occurred at: skgpspawn5

ORA-27303: additional information: skgpspawn5

Mon Jun 13 15:28:56 EAT 2011

Process O001 died, see its trace file

Mon Jun 13 15:28:56 EAT 2011

ksvsubmit: Process(O001) creation failed

Mon Jun 13 15:29:06 EAT 2011

Process startup failed, error stack:

Mon Jun 13 15:29:06 EAT 2011

Errors in file /oracle/admin/scrk/bdump/scrk1_psp0_3767.trc:

ORA-27300: OS system dependent operation:fork failed with status: 11

ORA-27301: OS failure message: Resource temporarily unavailable

ORA-27302: failure occurred at: skgpspawn5

ORA-27303: additional information: skgpspawn5

Mon Jun 13 15:29:06 EAT 2011

Thread 1 cannot allocate new log, sequence 457997

Checkpoint not complete

Current log# 3 seq# 457996 mem# 0: +SCRKDATA01/scrk/onlinelog/group_3.971.728928961

Current log# 3 seq# 457996 mem# 1: +SCRKDATA01/scrk/onlinelog/group_3.980.728931221

Mon Jun 13 15:29:07 EAT 2011

Process PZ97 died, see its trace file

Mon Jun 13 15:29:08 EAT 2011

Thread 1 advanced to log sequence 457997 (LGWR switch)

Current log# 2 seq# 457997 mem# 0: +SCRKDATA01/scrk/onlinelog/group_2.972.728929483

Current log# 2 seq# 457997 mem# 1: +SCRKDATA01/scrk/onlinelog/group_2.979.728931207

Mon Jun 13 15:29:18 EAT 2011

Thread 1 cannot allocate new log, sequence 457998

Checkpoint not complete

Current log# 2 seq# 457997 mem# 0: +SCRKDATA01/scrk/onlinelog/group_2.972.728929483

Current log# 2 seq# 457997 mem# 1: +SCRKDATA01/scrk/onlinelog/group_2.979.728931207

Mon Jun 13 15:29:20 EAT 2011

Thread 1 advanced to log sequence 457998 (LGWR switch)

Current log# 1 seq# 457998 mem# 0: +SCRKDATA01/scrk/onlinelog/group_1.976.728930203

Current log# 1 seq# 457998 mem# 1: +SCRKDATA01/scrk/onlinelog/group_1.978.728931175

Mon Jun 13 15:29:23 EAT 2011

Process startup failed, error stack:

Mon Jun 13 15:29:23 EAT 2011

Errors in file /oracle/admin/scrk/bdump/scrk1_psp0_3767.trc:

ORA-27300: OS system dependent operation:fork failed with status: 11

ORA-27301: OS failure message: Resource temporarily unavailable

ORA-27302: failure occurred at: skgpspawn5

ORA-27303: additional information: skgpspawn5

Mon Jun 13 15:29:24 EAT 2011

Process P000 died, see its trace file

Mon Jun 13 15:29:24 EAT 2011

Process startup failed, error stack:

Mon Jun 13 15:29:24 EAT 2011

Errors in file /oracle/admin/scrk/bdump/scrk1_psp0_3767.trc:

ORA-27300: OS system dependent operation:fork failed with status: 11

ORA-27301: OS failure message: Resource temporarily unavailable

ORA-27302: failure occurred at: skgpspawn5

ORA-27303: additional information: skgpspawn5

Mon Jun 13 15:29:25 EAT 2011

Process P001 died, see its trace file

Mon Jun 13 15:29:30 EAT 2011

Thread 1 cannot allocate new log, sequence 457999

Checkpoint not complete

Current log# 1 seq# 457998 mem# 0: +SCRKDATA01/scrk/onlinelog/group_1.976.728930203

Current log# 1 seq# 457998 mem# 1: +SCRKDATA01/scrk/onlinelog/group_1.978.728931175

Mon Jun 13 15:29:32 EAT 2011

Thread 1 advanced to log sequence 457999 (LGWR switch)

Current log# 3 seq# 457999 mem# 0: +SCRKDATA01/scrk/onlinelog/group_3.971.728928961

Current log# 3 seq# 457999 mem# 1: +SCRKDATA01/scrk/onlinelog/group_3.980.728931221

Mon Jun 13 15:29:42 EAT 2011

Thread 1 cannot allocate new log, sequence 458000

Checkpoint not complete

Current log# 3 seq# 457999 mem# 0: +SCRKDATA01/scrk/onlinelog/group_3.971.728928961

Current log# 3 seq# 457999 mem# 1: +SCRKDATA01/scrk/onlinelog/group_3.980.728931221

Mon Jun 13 15:29:44 EAT 2011

Thread 1 advanced to log sequence 458000 (LGWR switch)

Current log# 2 seq# 458000 mem# 0: +SCRKDATA01/scrk/onlinelog/group_2.972.728929483

Current log# 2 seq# 458000 mem# 1: +SCRKDATA01/scrk/onlinelog/group_2.979.728931207

Mon Jun 13 15:29:54 EAT 2011

Process startup failed, error stack:

Mon Jun 13 15:29:54 EAT 2011

Errors in file /oracle/admin/scrk/bdump/scrk1_psp0_3767.trc:

ORA-27300: OS system dependent operation:fork failed with status: 11

ORA-27301: OS failure message: Resource temporarily unavailable

ORA-27302: failure occurred at: skgpspawn5

ORA-27303: additional information: skgpspawn5

Mon Jun 13 15:29:54 EAT 2011

Thread 1 cannot allocate new log, sequence 458001

Checkpoint not complete

Current log# 2 seq# 458000 mem# 0: +SCRKDATA01/scrk/onlinelog/group_2.972.728929483

Current log# 2 seq# 458000 mem# 1: +SCRKDATA01/scrk/onlinelog/group_2.979.728931207

Mon Jun 13 15:29:55 EAT 2011

Process J001 died, see its trace file

Mon Jun 13 15:29:55 EAT 2011

kkjcre1p: unable to spawn jobq slave process

Mon Jun 13 15:29:55 EAT 2011

Errors in file /oracle/admin/scrk/bdump/scrk1_cjq0_3796.trc:

Mon Jun 13 15:29:56 EAT 2011

Thread 1 advanced to log sequence 458001 (LGWR switch)

Current log# 1 seq# 458001 mem# 0: +SCRKDATA01/scrk/onlinelog/group_1.976.728930203

Current log# 1 seq# 458001 mem# 1: +SCRKDATA01/scrk/onlinelog/group_1.978.728931175

Mon Jun 13 15:30:06 EAT 2011

Thread 1 advanced to log sequence 458002 (LGWR switch)

Current log# 3 seq# 458002 mem# 0: +SCRKDATA01/scrk/onlinelog/group_3.971.728928961

Current log# 3 seq# 458002 mem# 1: +SCRKDATA01/scrk/onlinelog/group_3.980.728931221

Mon Jun 13 15:30:16 EAT 2011

Thread 1 cannot allocate new log, sequence 458003

Checkpoint not complete

Current log# 3 seq# 458002 mem# 0: +SCRKDATA01/scrk/onlinelog/group_3.971.728928961

Current log# 3 seq# 458002 mem# 1: +SCRKDATA01/scrk/onlinelog/group_3.980.728931221

Mon Jun 13 15:30:17 EAT 2011

Thread 1 advanced to log sequence 458003 (LGWR switch)

Current log# 2 seq# 458003 mem# 0: +SCRKDATA01/scrk/onlinelog/group_2.972.728929483

Current log# 2 seq# 458003 mem# 1: +SCRKDATA01/scrk/onlinelog/group_2.979.728931207

Mon Jun 13 15:30:28 EAT 2011

Thread 1 advanced to log sequence 458004 (LGWR switch)

Current log# 1 seq# 458004 mem# 0: +SCRKDATA01/scrk/onlinelog/group_1.976.728930203

Current log# 1 seq# 458004 mem# 1: +SCRKDATA01/scrk/onlinelog/group_1.978.728931175

Mon Jun 13 15:30:38 EAT 2011

Thread 1 advanced to log sequence 458005 (LGWR switch)

Current log# 3 seq# 458005 mem# 0: +SCRKDATA01/scrk/onlinelog/group_3.971.728928961

Current log# 3 seq# 458005 mem# 1: +SCRKDATA01/scrk/onlinelog/group_3.980.728931221

Mon Jun 13 15:30:40 EAT 2011

Process startup failed, error stack:

Mon Jun 13 15:30:40 EAT 2011

Errors in file /oracle/admin/scrk/bdump/scrk1_psp0_3767.trc:

ORA-27300: OS system dependent operation:fork failed with status: 12

ORA-27301: OS failure message: Not enough space

ORA-27302: failure occurred at: skgpspawn3

Mon Jun 13 15:30:41 EAT 2011

Process m001 died, see its trace file

Mon Jun 13 15:30:41 EAT 2011

ksvcreate: Process(m001) creation failed

Mon Jun 13 15:30:46 EAT 2011

Process startup failed, error stack:

Mon Jun 13 15:30:46 EAT 2011

Errors in file /oracle/admin/scrk/bdump/scrk1_psp0_3767.trc:

ORA-27300: OS system dependent operation:fork failed with status: 12

ORA-27301: OS failure message: Not enough space

ORA-27302: failure occurred at: skgpspawn3

Mon Jun 13 15:30:47 EAT 2011

Process P000 died, see its trace file

Mon Jun 13 15:30:49 EAT 2011

Thread 1 advanced to log sequence 458006 (LGWR switch)

Current log# 2 seq# 458006 mem# 0: +SCRKDATA01/scrk/onlinelog/group_2.972.728929483

Current log# 2 seq# 458006 mem# 1: +SCRKDATA01/scrk/onlinelog/group_2.979.728931207

Mon Jun 13 15:30:55 EAT 2011

Process startup failed, error stack:

Mon Jun 13 15:30:55 EAT 2011

Errors in file /oracle/admin/scrk/bdump/scrk1_psp0_3767.trc:

ORA-27300: OS system dependent operation:fork failed with status: 12

ORA-27301: OS failure message: Not enough space

ORA-27302: failure occurred at: skgpspawn3

Mon Jun 13 15:30:56 EAT 2011

Process J000 died, see its trace file

Mon Jun 13 15:30:56 EAT 2011

kkjcre1p: unable to spawn jobq slave process

Mon Jun 13 15:30:56 EAT 2011

Errors in file /oracle/admin/scrk/bdump/scrk1_cjq0_3796.trc:

Mon Jun 13 15:30:59 EAT 2011

Thread 1 advanced to log sequence 458007 (LGWR switch)

Current log# 1 seq# 458007 mem# 0: +SCRKDATA01/scrk/onlinelog/group_1.976.728930203

Current log# 1 seq# 458007 mem# 1: +SCRKDATA01/scrk/onlinelog/group_1.978.728931175

Mon Jun 13 15:31:05 EAT 2011

Process startup failed, error stack:

Mon Jun 13 15:31:05 EAT 2011

Errors in file /oracle/admin/scrk/bdump/scrk1_psp0_3767.trc:

ORA-27300: OS system dependent operation:fork failed with status: 12

ORA-27301: OS failure message: Not enough space

ORA-27302: failure occurred at: skgpspawn3

Mon Jun 13 15:31:06 EAT 2011

Process P000 died, see its trace file

Mon Jun 13 15:31:10 EAT 2011

Thread 1 cannot allocate new log, sequence 458008

Checkpoint not complete

Current log# 1 seq# 458007 mem# 0: +SCRKDATA01/scrk/onlinelog/group_1.976.728930203

Current log# 1 seq# 458007 mem# 1: +SCRKDATA01/scrk/onlinelog/group_1.978.728931175

Mon Jun 13 15:31:10 EAT 2011

Thread 1 advanced to log sequence 458008 (LGWR switch)

Current log# 3 seq# 458008 mem# 0: +SCRKDATA01/scrk/onlinelog/group_3.971.728928961

Current log# 3 seq# 458008 mem# 1: +SCRKDATA01/scrk/onlinelog/group_3.980.728931221

Mon Jun 13 15:31:21 EAT 2011

Thread 1 advanced to log sequence 458009 (LGWR switch)

Current log# 2 seq# 458009 mem# 0: +SCRKDATA01/scrk/onlinelog/group_2.972.728929483

Current log# 2 seq# 458009 mem# 1: +SCRKDATA01/scrk/onlinelog/group_2.979.728931207

Mon Jun 13 15:31:26 EAT 2011

Process startup failed, error stack:

Mon Jun 13 15:31:26 EAT 2011

Errors in file /oracle/admin/scrk/bdump/scrk1_psp0_3767.trc:

ORA-27300: OS system dependent operation:fork failed with status: 12

ORA-27301: OS failure message: Not enough space

ORA-27302: failure occurred at: skgpspawn3

Mon Jun 13 15:31:27 EAT 2011

Process P000 died, see its trace file

Mon Jun 13 15:31:31 EAT 2011

Thread 1 cannot allocate new log, sequence 458010

Checkpoint not complete

Current log# 2 seq# 458009 mem# 0: +SCRKDATA01/scrk/onlinelog/group_2.972.728929483

Current log# 2 seq# 458009 mem# 1: +SCRKDATA01/scrk/onlinelog/group_2.979.728931207

Mon Jun 13 15:31:33 EAT 2011

Thread 1 advanced to log sequence 458010 (LGWR switch)

Current log# 1 seq# 458010 mem# 0: +SCRKDATA01/scrk/onlinelog/group_1.976.728930203

Current log# 1 seq# 458010 mem# 1: +SCRKDATA01/scrk/onlinelog/group_1.978.728931175

Mon Jun 13 15:31:38 EAT 2011

Process startup failed, error stack:

Mon Jun 13 15:31:38 EAT 2011

Errors in file /oracle/admin/scrk/bdump/scrk1_psp0_3767.trc:

ORA-27300: OS system dependent operation:fork failed with status: 12

ORA-27301: OS failure message: Not enough space

ORA-27302: failure occurred at: skgpspawn3

Mon Jun 13 15:31:39 EAT 2011

Process P000 died, see its trace file

Mon Jun 13 15:31:43 EAT 2011

Thread 1 cannot allocate new log, sequence 458011

Checkpoint not complete

Current log# 1 seq# 458010 mem# 0: +SCRKDATA01/scrk/onlinelog/group_1.976.728930203

Current log# 1 seq# 458010 mem# 1: +SCRKDATA01/scrk/onlinelog/group_1.978.728931175

Mon Jun 13 15:31:45 EAT 2011

Thread 1 advanced to log sequence 458011 (LGWR switch)

Current log# 3 seq# 458011 mem# 0: +SCRKDATA01/scrk/onlinelog/group_3.971.728928961

Current log# 3 seq# 458011 mem# 1: +SCRKDATA01/scrk/onlinelog/group_3.980.728931221

Mon Jun 13 15:31:54 EAT 2011

Terminating process 3779, due to ORA-4030 raised in ASM I/O path

Mon Jun 13 15:31:54 EAT 2011

Errors in file /oracle/admin/scrk/bdump/scrk1_dbw0_3779.trc:

ORA-04030: out of process memory when trying to allocate 1049136 bytes (KSFD vec heap,KSFD contig I/O buf)

Mon Jun 13 15:31:55 EAT 2011

Process startup failed, error stack:

Mon Jun 13 15:31:55 EAT 2011

Errors in file /oracle/admin/scrk/bdump/scrk1_psp0_3767.trc:

ORA-27300: OS system dependent operation:fork failed with status: 11

ORA-27301: OS failure message: Resource temporarily unavailable

ORA-27302: failure occurred at: skgpspawn5

ORA-27303: additional information: skgpspawn5

Mon Jun 13 15:31:55 EAT 2011

Thread 1 cannot allocate new log, sequence 458012

Checkpoint not complete

Current log# 3 seq# 458011 mem# 0: +SCRKDATA01/scrk/onlinelog/group_3.971.728928961

Current log# 3 seq# 458011 mem# 1: +SCRKDATA01/scrk/onlinelog/group_3.980.728931221

Mon Jun 13 15:31:55 EAT 2011

Errors in file /oracle/admin/scrk/bdump/scrk1_pmon_3757.trc:

ORA-00471: DBWR process terminated with error

Mon Jun 13 15:31:55 EAT 2011

PMON: terminating instance due to error 471

Mon Jun 13 15:31:58 EAT 2011

System state dump is made for local instance

System State dumped to trace file /oracle/admin/scrk/bdump/scrk1_diag_3765.trc

Mon Jun 13 15:32:03 EAT 2011

Shutting down instance (abort)

License high water mark = 307

Mon Jun 13 15:32:05 EAT 2011

Termination issued to instance processes. Waiting for the processes to exit

Instance terminated by PMON, pid = 3757

Mon Jun 13 15:32:08 EAT 2011

Instance terminated by USER, pid = 10948

Mon Jun 13 15:32:13 EAT 2011

Starting ORACLE instance (normal)

Mon Jun 13 15:32:13 EAT 2011

通过查询metalink给出了以下解决方案,目前系统交换分区跟内存一样都是8G,就没有扩充;最后通过在不过度影响数据库性能的方式减小SGA给系统保留更多的内存。有点郁闷的是据说HP UNIX 11.31很吃内存,但是也不能保留3个多G都不够用吧。

ASM ORA-12549: TNS:Operating System Resource Quota Exceeded [ID 738855.1]


--------------------------------------------------------------------------------

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7
This problem can occur on any platform.

Symptoms

In the ASM alert.log file the next error was reported:
=========================================================
Sun Sep 14 01:04:38 2008
Errors in file /u01/app/oracle/admin/CLEADB/bdump/cleadb1_arc5_20944.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '+DISKGROUPMIRROR/cleadb/redot102.log'
ORA-17503: ksfdopn:2 Failed to open file +DISKGROUPMIRROR/cleadb/redot102.log
ORA-12549: TNS:operating system resource quota exceeded
Sun Sep 14 01:04:38 20
=========================================================

Cause

System (Unix or Linux) was running out of swap therefore the next error was reported:

The ORA-12549: TNS:operating system resource quota exceeded error was raised due to the OS was
running out of swap space.

Solution

Please ask your SA to resize the Swap area following the next formula:

If RAM = 1024MB to 2048Mb
then 1.5 times RAM
elseif RAM > 2048MB and < 8192MB
then match RAM
else RAM > 8192MB
then .75 times RAM

linux

人气教程排行