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
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1378
52
How to disable and remove HP Wolf Security on Windows 11
Dec 14, 2023 pm 06:49 PM
HP devices usually come with security software pre-installed, and many people wonder how to disable HPWolfSecurity on Windows 11. The reason for this is that this software can cause certain problems and conflict with other applications, so today we will show you how to disable it. Is HPWolfSecurity bloatware? This is a legitimate application from HP, but it often comes pre-installed and causes performance issues and conflicts with other security software, which is why many people consider it bloatware. How to disable HPWolfSecurity on Windows 11? 1. Use the system tray icon to find HPWolfSecurity in the system tray
What operating system is unix?
Jan 05, 2021 am 10:26 AM
Unix is a multi-user, multi-process computer operating system that supports multiple processor architectures. According to the classification of operating systems, it is a time-sharing operating system. In addition to being a network operating system, Unix can also be used as a stand-alone operating system. The UNIX system provides a good user interface, which is easy to use, fully functional, clear and flexible, and easy to expand and modify.
What does GNU mean?
Jan 02, 2019 am 11:53 AM
GNU is a Unix-like operating system developed and designed based on Unix and is compatible with Unix. GNU consists of a set of software applications and developer tools and a program that allocates resources and communicates with hardware or the kernel. GNU can be used with other kernels, and is usually used with the Linux kernel. GNU programs can be ported to many other operating systems, including different platforms such as Mac OS X and Microsoft Windows.
KDE Plasma 6.1 brings many enhancements to the popular Linux desktop
Jun 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
Why are linux and unix similar?
Mar 13, 2023 am 10:20 AM
The original intention of Linux was to replace UNIX and optimize its functions and user experience. Therefore, Linux imitated UNIX (but did not plagiarize the source code of UNIX), making Linux very similar to UNIX in appearance and interaction. Therefore, it can be said that "UNIX is the father of Linux". It is precisely because Linux and UNIX are inextricably linked that people call Linux a "UNIX-like system."
Unix Philosophy Programming Principles
Feb 20, 2024 am 10:54 AM
1Unix philosophy The Unix philosophy emphasizes practicality, comes from rich experience, and is not restricted by traditional methodologies or standards. This knowledge is more latent and semi-instinctive. The knowledge that Unix programmers accumulate through development experience can benefit other programmers. (1) Each program should focus on completing one task and start over when encountering a new task to avoid adding new functions to the original program, resulting in increased complexity. (2) Assuming that the output of a program will become the input of another program, even if the next program is not clear, make sure that the output does not contain irrelevant information. (3) Put the designed and written software into trial use as soon as possible, and discard low-quality code decisively and rewrite it. (4) Use tools prior to inefficient auxiliary means to reduce the burden of programming tasks and strive for excellence.
HP EliteBook X G1a: Powerful business laptop features Ryzen AI 300 with 40 W TDP & a big battery
Sep 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
Deal | Affordable HP Victus gaming laptop with RTX 3050-beating RX 6550M gets 40% discount in Best Buy sale
Aug 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 $
