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
Alat AI Hot
Undresser.AI Undress
Apl berkuasa AI untuk mencipta foto bogel yang realistik
AI Clothes Remover
Alat AI dalam talian untuk mengeluarkan pakaian daripada foto.
Undress AI Tool
Gambar buka pakaian secara percuma
Clothoff.io
Penyingkiran pakaian AI
AI Hentai Generator
Menjana ai hentai secara percuma.
Artikel Panas
Alat panas
Notepad++7.3.1
Editor kod yang mudah digunakan dan percuma
SublimeText3 versi Cina
Versi Cina, sangat mudah digunakan
Hantar Studio 13.0.1
Persekitaran pembangunan bersepadu PHP yang berkuasa
Dreamweaver CS6
Alat pembangunan web visual
SublimeText3 versi Mac
Perisian penyuntingan kod peringkat Tuhan (SublimeText3)
Topik panas
Bagaimana untuk melumpuhkan dan mengalih keluar HP Wolf Security pada Windows 11
Dec 14, 2023 pm 06:49 PM
Peranti HP biasanya disertakan dengan perisian keselamatan yang diprapasang, dan ramai orang tertanya-tanya bagaimana untuk melumpuhkan HPWolfSecurity pada Windows 11. Sebabnya ialah perisian ini boleh menyebabkan masalah tertentu dan konflik dengan aplikasi lain, jadi hari ini kami akan menunjukkan kepada anda cara untuk melumpuhkannya. Adakah bloatware HPWolfSecurity? Ini adalah aplikasi yang sah daripada HP, tetapi ia sering diprapasang dan menyebabkan isu prestasi dan konflik dengan perisian keselamatan lain, itulah sebabnya ramai orang menganggapnya bloatware. Bagaimana untuk melumpuhkan HPWolfSecurity pada Windows 11? 1. Gunakan ikon dulang sistem untuk mencari HPWolfSecurity dalam dulang sistem
unix是什么操作系统
Jan 05, 2021 am 10:26 AM
unix是一种多用户、多进程的计算机操作系统，支持多种处理器架构，按照操作系统的分类，属于分时操作系统；unix除了作为网络操作系统之外，还可以作为单机操作系统使用。UNIX系统提供了良好的用户界面，具有使用方便、功能齐全、清晰而灵活、易于扩充和修改等特点。
GNU是什么意思
Jan 02, 2019 am 11:53 AM
GNU是一个基于Unix开发设计，并且是与Unix兼容的类Unix操作系统。GNU由一系列软件应用程序组成，并且和开发人员工具以及一个分配资源并以及硬件或内核通信的程序组成，GNU可以与其他内核一起使用，并且通常与Linux内核一起使用。GNU程序可以移植到许多其他操作系统，包括不同的平台，如Mac OS X和Microsoft Windows。
Mengapa linux dan unix serupa?
Mar 13, 2023 am 10:20 AM
Niat asal Linux adalah untuk menggantikan UNIX dan mengoptimumkan fungsi dan pengalaman penggunanya Oleh itu, Linux meniru UNIX (tetapi tidak memplagiat kod sumber UNIX), menjadikan Linux sangat serupa dengan UNIX dalam penampilan dan interaksi. Oleh itu, boleh dikatakan bahawa "UNIX ialah bapa kepada Linux". Justru kerana Linux dan UNIX berkait rapat, orang ramai memanggil Linux sebagai "sistem seperti UNIX."
KDE Plasma 6.1 membawa banyak peningkatan pada desktop Linux yang popular
Jun 23, 2024 am 07:54 AM
Selepas beberapa prakeluaran, pasukan pembangunan KDE Plasma melancarkan versi 6.0 persekitaran desktopnya untuk sistem Linux dan BSD pada 28 Februari, menggunakan rangka kerja Qt6 buat kali pertama. KDE Plasma 6.1 kini hadir dengan beberapa ciri baharu t
Prinsip Pengaturcaraan Falsafah Unix
Feb 20, 2024 am 10:54 AM
1Falsafah Unix Falsafah Unix menekankan kepraktisan, datang daripada pengalaman yang kaya, dan tidak dihadkan oleh metodologi atau piawaian tradisional. Pengetahuan ini lebih terpendam dan separa naluri. Pengetahuan yang dikumpul pengaturcara Unix melalui pengalaman pembangunan boleh memberi manfaat kepada pengaturcara lain. (1) Setiap program harus menumpukan pada menyelesaikan satu tugasan dan memulakan semula apabila menghadapi tugasan baharu untuk mengelak daripada menambah fungsi baharu pada atur cara asal, menyebabkan kerumitan meningkat. (2) Dengan mengandaikan bahawa output program akan menjadi input program lain, walaupun program seterusnya tidak jelas, pastikan output tidak mengandungi maklumat yang tidak relevan. (3) Letakkan perisian yang direka bentuk dan bertulis ke dalam penggunaan percubaan secepat mungkin, dan dengan tegas meninggalkan serta menulis semula kod berkualiti rendah. (4) Gunakan alat sebelum cara bantu yang tidak cekap untuk mengurangkan beban tugas pengaturcaraan dan berusaha untuk kecemerlangan.
Tawaran | Komputer riba permainan HP Victus mampu milik dengan RTX 3050-beating RX 6550M mendapat diskaun 40% dalam jualan Best Buy
Aug 09, 2024 pm 09:51 PM
HP Victus 15 ialah 1 komputer riba permainan peringkat permulaan bersaiz 15.6-inci yang biasanya tidak bernilai banyak pertimbangan, namun tawaran Best Buy baharu menawarkan potongan 40% daripada komputer riba permainan peringkat permulaan, menurunkan harga daripada $799.99 kepada harga yang sangat tinggi. mesra bajet $
HP EliteBook X G1a: Komputer riba perniagaan berkuasa menampilkan Ryzen AI 300 dengan TDP 40 W & bateri besar
Sep 25, 2024 am 06:18 AM
Daripada dua pengeluar PC Windows Amerika yang besar, HP pastinya yang menerima AMD dengan lebih mudah. Walaupun begitu, HP EliteBook yang paling mahal, EliteBook 1000, sentiasa eksklusif untuk Intel. Sehingga kini, iaitu: HP EliteBook X baharu
