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 Hentai를 무료로 생성하십시오.
인기 기사
뜨거운 도구
메모장++7.3.1
사용하기 쉬운 무료 코드 편집기
SublimeText3 중국어 버전
중국어 버전, 사용하기 매우 쉽습니다.
스튜디오 13.0.1 보내기
강력한 PHP 통합 개발 환경
드림위버 CS6
시각적 웹 개발 도구
SublimeText3 Mac 버전
신 수준의 코드 편집 소프트웨어(SublimeText3)
뜨거운 주제
7540
15
1381
52
83
11
55
19
21
86
Windows 11에서 HP Wolf Security를 비활성화하고 제거하는 방법
Dec 14, 2023 pm 06:49 PM
HP 장치에는 일반적으로 보안 소프트웨어가 사전 설치되어 제공되며 많은 사람들이 Windows 11에서 HPWolfSecurity를 비활성화하는 방법을 궁금해합니다. 그 이유는 이 소프트웨어가 특정 문제를 일으키고 다른 응용 프로그램과 충돌할 수 있기 때문에 오늘은 이 소프트웨어를 비활성화하는 방법을 알려 드리겠습니다. HPWolfSecurity는 블로트웨어인가요? 이는 HP의 합법적인 응용 프로그램이지만 사전 설치되어 제공되는 경우가 많으며 성능 문제 및 다른 보안 소프트웨어와 충돌을 일으키기 때문에 많은 사람들이 이를 블로트웨어로 간주합니다. Windows 11에서 HPWolfSecurity를 비활성화하는 방법은 무엇입니까? 1. 시스템 트레이 아이콘을 사용하여 시스템 트레이에서 HPWolfSecurity를 찾습니다.
유닉스는 어떤 운영체제인가요?
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 플라즈마 개발 팀은 2월 28일 처음으로 Qt6 프레임워크를 사용하는 Linux 및 BSD 시스템용 데스크탑 환경 버전 6.0을 공개했습니다. KDE Plasma 6.1에는 이제 여러 가지 새로운 기능이 포함되어 있습니다.
리눅스와 유닉스는 왜 비슷한가요?
Mar 13, 2023 am 10:20 AM
Linux의 원래 의도는 UNIX를 대체하고 그 기능과 사용자 경험을 최적화하는 것이었습니다. 따라서 Linux는 UNIX를 모방했지만(그러나 UNIX의 소스 코드를 표절하지는 않았습니다) Linux는 외관과 상호 작용에서 UNIX와 매우 유사하게 되었습니다. 따라서 "UNIX는 Linux의 아버지"라고 할 수 있습니다. Linux를 "UNIX 계열 시스템"이라고 부르는 것은 바로 Linux와 UNIX가 불가분의 관계에 있기 때문입니다.
HP EliteBook X G1a: 40W TDP 및 대용량 배터리를 갖춘 Ryzen AI 300을 갖춘 강력한 비즈니스 노트북
Sep 25, 2024 am 06:18 AM
미국의 두 대형 Windows PC 제조업체 중에서 HP는 분명히 AMD를 더 쉽게 수용한 업체였습니다. 그럼에도 불구하고 가장 비싼 HP EliteBook인 EliteBook 1000은 항상 Intel의 독점 제품이었습니다. 지금까지는 새로운 HP EliteBook X가 그렇습니다.
유닉스 철학 프로그래밍 원리
Feb 20, 2024 am 10:54 AM
1유닉스 철학 유닉스 철학은 실용성을 강조하고, 풍부한 경험에서 나오며, 전통적인 방법론이나 표준에 얽매이지 않습니다. 이 지식은 더 잠복적이고 반 본능적입니다. 유닉스 프로그래머가 개발 경험을 통해 축적한 지식은 다른 프로그래머에게도 도움이 될 수 있습니다. (1) 각 프로그램은 하나의 작업을 완료하는 데 중점을 두고 원래 프로그램에 새로운 기능을 추가하여 복잡성이 증가하는 것을 피하기 위해 새로운 작업이 발생할 때 다시 시작해야 합니다. (2) 프로그램의 출력이 다른 프로그램의 입력이 된다고 가정하면, 다음 프로그램이 명확하지 않더라도 출력에 관련 없는 정보가 포함되지 않도록 하십시오. (3) 설계 및 작성된 소프트웨어를 가능한 한 빨리 시험 사용하고, 품질이 낮은 코드는 단호히 버리고 다시 작성합니다. (4) 비효율적인 보조 수단에 앞서 도구를 사용하여 프로그래밍 작업의 부담을 줄이고 우수성을 추구합니다.
유닉스와 윈도우의 차이점은 무엇입니까
Sep 07, 2023 pm 01:27 PM
차이점은 다음과 같습니다. 1. UNIX는 오픈 소스인 반면 Win은 독점 소프트웨어이며 소스 코드는 공개되지 않습니다. 2. UNIX는 다중 사용자, 다중 작업 환경용으로 설계된 반면 Win은 개인에게 적합합니다. 3. Win은 UNIX보다 강력합니다. 시작하기 쉽습니다. 4. UNIX는 성능과 안정성 측면에서 더 우수합니다. 5. Win은 UNIX보다 더 넓은 응용프로그램과 소프트웨어 호환성을 제공합니다. 6. UNIX 라이센스는 일반적으로 Win보다 비쌉니다. 7. UNIX는 보안이 더 좋습니다. 성능은 Win보다 좋습니다. 8. UNIX 설치는 Win보다 간단합니다.
