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
ホットAIツール
Undresser.AI Undress
リアルなヌード写真を作成する AI 搭載アプリ
AI Clothes Remover
写真から衣服を削除するオンライン AI ツール。
Undress AI Tool
脱衣画像を無料で
Clothoff.io
AI衣類リムーバー
AI Hentai Generator
AIヘンタイを無料で生成します。
人気の記事
ホットツール
メモ帳++7.3.1
使いやすく無料のコードエディター
SublimeText3 中国語版
中国語版、とても使いやすい
ゼンドスタジオ 13.0.1
強力な PHP 統合開発環境
ドリームウィーバー CS6
ビジュアル Web 開発ツール
SublimeText3 Mac版
神レベルのコード編集ソフト（SublimeText3）
ホットトピック
7467
15
1376
52
77
11
18
20
Windows 11 で HP Wolf Security を無効にして削除する方法
Dec 14, 2023 pm 06:49 PM
通常、HP デバイスにはセキュリティ ソフトウェアがプリインストールされており、多くの人が Windows 11 で HPWolfSecurity を無効にする方法を疑問に思っています。その理由は、このソフトウェアが特定の問題を引き起こしたり、他のアプリケーションと競合したりする可能性があるためです。そこで、今日はそれを無効にする方法を説明します。 HPWolfSecurity はブロートウェアですか?これは HP の正規のアプリケーションですが、プリインストールされていることが多く、パフォーマンスの問題や他のセキュリティ ソフトウェアとの競合を引き起こすため、多くの人がこれをブロートウェアとみなしています。 Windows 11 で HPWolfSecurity を無効にする方法は? 1. システム トレイ アイコンを使用して、システム トレイで HPWolfSecurity を見つけます。
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 などのさまざまなプラットフォームを含む、他の多くのオペレーティング システムに移植できます。
KDE Plasma 6.1 は、人気のある Linux デスクトップに多くの機能強化をもたらします
Jun 23, 2024 am 07:54 AM
数回のプレリリースを経て、KDE Plasma 開発チームは 2 月 28 日に、初めて Qt6 フレームワークを使用した Linux および BSD システム用のデスクトップ環境のバージョン 6.0 を発表しました。 KDE Plasma 6.1 には、多数の新機能が追加されました。
なぜ Linux と UNIX は似ているのでしょうか?
Mar 13, 2023 am 10:20 AM
Linux の本来の目的は、UNIX を置き換え、その機能とユーザー エクスペリエンスを最適化することであったため、Linux は UNIX を模倣し (ただし、UNIX のソース コードを盗用したわけではありません)、外観と操作性が UNIX に非常に似ています。したがって、「UNIX は Linux の父」と言えます。Linux と UNIX は切っても切れない関係にあるからこそ、人々は Linux を「UNIX 風のシステム」と呼びます。
Unix の哲学 プログラミング原則
Feb 20, 2024 am 10:54 AM
1Unix の哲学 Unix の哲学は実用性を重視しており、豊富な経験に基づいており、伝統的な方法論や標準に制限されません。この知識はより潜在的で、半ば本能的なものです。 Unix プログラマが開発経験を通じて蓄積した知識は、他のプログラマにも役立ちます。 (1) 元のプログラムに新しい機能が追加されて複雑さが増すことを避けるために、各プログラムは 1 つのタスクを完了することに重点を置き、新しいタスクが発生した場合は最初からやり直す必要があります。 (2) プログラムの出力が別のプログラムの入力になることを想定し、次のプログラムが明確でない場合でも、出力に無関係な情報が含まれないようにする。 (3) 設計・作成したソフトウェアは速やかに試用し、低品質なコードは思い切って捨てて書き直してください。 (4) 非効率的な補助手段よりも先にツールを使用して、プログラミング作業の負担を軽減し、卓越性を追求します。
HP EliteBook X G1a: 強力なビジネス ラップトップは、40 W TDP と大容量バッテリーを備えた Ryzen AI 300 を搭載
Sep 25, 2024 am 06:18 AM
アメリカの 2 大 Windows PC メーカーのうち、HP が AMD をより積極的に受け入れているのは間違いありません。それでも、最も高価な HP EliteBook である EliteBook 1000 は、常に Intel 専用でした。これまでは: 新しい HP EliteBook X
取引 | RTX 3050 を上回る RX 6550M を搭載した手頃な価格の HP Victus ゲーミング ラップトップが Best Buy セールで 40% 割引
Aug 09, 2024 pm 09:51 PM
HP Victus 15 は 15.6 インチのエントリーレベルのゲーム用ラップトップで、通常はあまり検討する価値はありませんが、新しい Best Buy の取引によりエントリーレベルのゲーム用ラップトップが 40% オフとなり、価格が 799.99 ドルから非常に安くなりました。予算に優しい $
