搜索
首页数据库mysql教程HP UNIX 11.31因为内存耗尽导致ORA-12549错误

通过查询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 then match RAM 
else RAM > 8192MB 
then .75 times RAM

linux

声明
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn
禁用和删除 HP Wolf Security 在 Windows 11 上的方法禁用和删除 HP Wolf Security 在 Windows 11 上的方法Dec 14, 2023 pm 06:49 PM

HP设备通常预装了安全软件,许多人想知道如何在Windows11上禁用HPWolfSecurity。这样做的原因是该软件可能会导致某些问题并与其他应用程序发生冲突,因此今天我们将向您展示如何禁用它。HPWolfSecurity是英国媒体报道软件吗?这是HP的合法应用程序,但它通常预装并导致性能问题并与其他安全软件发生冲突,这就是为什么许多人认为它是英国媒体报道软件的原因。如何在Windows11上禁用HPWolfSecurity?1.使用系统托盘图标在系统托盘中,找到HPWolfSecurity

unix是什么操作系统unix是什么操作系统Jan 05, 2021 am 10:26 AM

unix是一种多用户、多进程的计算机操作系统,支持多种处理器架构,按照操作系统的分类,属于分时操作系统;unix除了作为网络操作系统之外,还可以作为单机操作系统使用。UNIX系统提供了良好的用户界面,具有使用方便、功能齐全、清晰而灵活、易于扩充和修改等特点。

GNU是什么意思GNU是什么意思Jan 02, 2019 am 11:53 AM

GNU是一个基于Unix开发设计,并且是与Unix兼容的类Unix操作系统。GNU由一系列软件应用程序组成,并且和开发人员工具以及一个分配资源并以及硬件或内核通信的程序组成,GNU可以与其他内核一起使用,并且通常与Linux内核一起使用。GNU程序可以移植到许多其他操作系统,包括不同的平台,如Mac OS X和Microsoft Windows。

linux unix为什么相似linux unix为什么相似Mar 13, 2023 am 10:20 AM

Linux的初衷就是要替UNIX,并在功能和用户体验上进行优化,所以Linux模仿了UNIX(但并没有抄袭UNIX的源码),使得Linux在外观和交互上与UNIX 非常类似。因此可以说“UNIX是Linux的父亲”,也正是由于Linux和UNIX有着千丝万缕的联系,所以人们把Linux叫做“类UNIX系统”。

KDE Plasma 6.1 brings many enhancements to the popular Linux desktopKDE Plasma 6.1 brings many enhancements to the popular Linux desktopJun 23, 2024 am 07:54 AM

After several pre-releases, the KDE Plasma development team unveiled version 6.0 of its desktop environment for Linux and BSD systems on 28 February, using the Qt6 framework for the first time. KDE Plasma 6.1 now comes with a number of new features t

Unix哲学之编程原则Unix哲学之编程原则Feb 20, 2024 am 10:54 AM

1Unix哲学Unix哲学强调实用性,源自丰富经验,不受传统方法学或标准限制。这种知识更像是潜在的、半本能的。Unix程序员通过开发经验积累的知识可让其他程序员受益。(1)每个程序应专注于完成一项任务,遇到新任务时应重新开始,避免在原程序中添加新功能而导致复杂性增加。(2)假设程序的输出将成为另一个程序的输入,即使下一个程序尚不清楚,也应确保输出中不包含无关信息。(3)尽早将设计和编写的软件投入试用,对低质量代码应果断放弃并重新编写。(4)使用工具优先于低效的辅助手段来减轻编程任务的负担,精益求

Deal | Affordable HP Victus gaming laptop with RTX 3050-beating RX 6550M gets 40% discount in Best Buy saleDeal | Affordable HP Victus gaming laptop with RTX 3050-beating RX 6550M gets 40% discount in Best Buy saleAug 09, 2024 pm 09:51 PM

The HP Victus 15 is 1 15.6-inch entry-level gaming laptop that ordinarily wouldn't be worth much consideration, however a new Best Buy deal offers 40% off the entry-level gaming laptop, bringing the price down from $799.99 to a very budget-friendly $

HP EliteBook X G1a: Powerful business laptop features Ryzen AI 300 with 40 W TDP & a big batteryHP EliteBook X G1a: Powerful business laptop features Ryzen AI 300 with 40 W TDP & a big batterySep 25, 2024 am 06:18 AM

Of the two big American Windows PC manufacturers, HP has definitely been the one to embrace AMD more readily. Even so, the most expensive HP EliteBook, the EliteBook 1000, has always been exclusive to Intel. Until now, that is: The new HP EliteBook X

See all articles

热AI工具

Undresser.AI Undress

Undresser.AI Undress

人工智能驱动的应用程序,用于创建逼真的裸体照片

AI Clothes Remover

AI Clothes Remover

用于从照片中去除衣服的在线人工智能工具。

Undress AI Tool

Undress AI Tool

免费脱衣服图片

Clothoff.io

Clothoff.io

AI脱衣机

AI Hentai Generator

AI Hentai Generator

免费生成ai无尽的。

热门文章

R.E.P.O.能量晶体解释及其做什么(黄色晶体)
2 周前By尊渡假赌尊渡假赌尊渡假赌
仓库:如何复兴队友
4 周前By尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island冒险:如何获得巨型种子
4 周前By尊渡假赌尊渡假赌尊渡假赌

热工具

螳螂BT

螳螂BT

Mantis是一个易于部署的基于Web的缺陷跟踪工具,用于帮助产品缺陷跟踪。它需要PHP、MySQL和一个Web服务器。请查看我们的演示和托管服务。

DVWA

DVWA

Damn Vulnerable Web App (DVWA) 是一个PHP/MySQL的Web应用程序,非常容易受到攻击。它的主要目标是成为安全专业人员在合法环境中测试自己的技能和工具的辅助工具,帮助Web开发人员更好地理解保护Web应用程序的过程,并帮助教师/学生在课堂环境中教授/学习Web应用程序安全。DVWA的目标是通过简单直接的界面练习一些最常见的Web漏洞,难度各不相同。请注意,该软件中

SublimeText3 英文版

SublimeText3 英文版

推荐:为Win版本,支持代码提示!

适用于 Eclipse 的 SAP NetWeaver 服务器适配器

适用于 Eclipse 的 SAP NetWeaver 服务器适配器

将Eclipse与SAP NetWeaver应用服务器集成。

Dreamweaver Mac版

Dreamweaver Mac版

视觉化网页开发工具