搜尋
首頁資料庫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尊渡假赌尊渡假赌尊渡假赌

熱工具

SublimeText3 Mac版

SublimeText3 Mac版

神級程式碼編輯軟體(SublimeText3)

DVWA

DVWA

Damn Vulnerable Web App (DVWA) 是一個PHP/MySQL的Web應用程序,非常容易受到攻擊。它的主要目標是成為安全專業人員在合法環境中測試自己的技能和工具的輔助工具,幫助Web開發人員更好地理解保護網路應用程式的過程,並幫助教師/學生在課堂環境中教授/學習Web應用程式安全性。 DVWA的目標是透過簡單直接的介面練習一些最常見的Web漏洞,難度各不相同。請注意,該軟體中

SecLists

SecLists

SecLists是最終安全測試人員的伙伴。它是一個包含各種類型清單的集合,這些清單在安全評估過程中經常使用,而且都在一個地方。 SecLists透過方便地提供安全測試人員可能需要的所有列表,幫助提高安全測試的效率和生產力。清單類型包括使用者名稱、密碼、URL、模糊測試有效載荷、敏感資料模式、Web shell等等。測試人員只需將此儲存庫拉到新的測試機上,他就可以存取所需的每種類型的清單。

Atom編輯器mac版下載

Atom編輯器mac版下載

最受歡迎的的開源編輯器

ZendStudio 13.5.1 Mac

ZendStudio 13.5.1 Mac

強大的PHP整合開發環境