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
Outils d'IA chauds
Undresser.AI Undress
Application basée sur l'IA pour créer des photos de nu réalistes
AI Clothes Remover
Outil d'IA en ligne pour supprimer les vêtements des photos.
Undress AI Tool
Images de déshabillage gratuites
Clothoff.io
Dissolvant de vêtements AI
AI Hentai Generator
Générez AI Hentai gratuitement.
Article chaud
Outils chauds
Bloc-notes++7.3.1
Éditeur de code facile à utiliser et gratuit
SublimeText3 version chinoise
Version chinoise, très simple à utiliser
Envoyer Studio 13.0.1
Puissant environnement de développement intégré PHP
Dreamweaver CS6
Outils de développement Web visuel
SublimeText3 version Mac
Logiciel d'édition de code au niveau de Dieu (SublimeText3)
Comment désactiver et supprimer HP Wolf Security sous Windows 11
Dec 14, 2023 pm 06:49 PM
Les appareils HP sont généralement livrés avec un logiciel de sécurité préinstallé, et de nombreuses personnes se demandent comment désactiver HPWolfSecurity sur Windows 11. La raison en est que ce logiciel peut provoquer certains problèmes et entrer en conflit avec d'autres applications, nous allons donc vous montrer aujourd'hui comment le désactiver. HPWolfSecurity est-il un bloatware ? Il s'agit d'une application légitime de HP, mais elle est souvent préinstallée et entraîne des problèmes de performances et des conflits avec d'autres logiciels de sécurité, c'est pourquoi de nombreuses personnes la considèrent comme un bloatware. Comment désactiver HPWolfSecurity sur Windows 11 ? 1. Utilisez l'icône de la barre d'état système pour trouver HPWolfSecurity dans la barre d'état système.
Quel système d'exploitation est Unix ?
Jan 05, 2021 am 10:26 AM
Unix est un système d'exploitation informatique multi-utilisateurs et multi-processus qui prend en charge plusieurs architectures de processeurs. Selon la classification des systèmes d'exploitation, il s'agit d'un système d'exploitation à temps partagé. En plus d'être un système d'exploitation réseau, Unix peut également. être utilisé comme système d’exploitation autonome. Le système UNIX offre une bonne interface utilisateur, facile à utiliser, entièrement fonctionnelle, claire et flexible, et facile à étendre et à modifier.
Que signifie GNU ?
Jan 02, 2019 am 11:53 AM
GNU est un système d'exploitation de type Unix développé et conçu sur la base d'Unix et est compatible avec Unix. GNU se compose d'un ensemble d'applications logicielles et d'outils de développement et d'un programme qui alloue des ressources et communique avec le matériel ou le noyau. GNU peut être utilisé avec d'autres noyaux et est généralement utilisé avec le noyau Linux. Les programmes GNU peuvent être portés sur de nombreux autres systèmes d'exploitation, y compris différentes plates-formes telles que Mac OS X et Microsoft Windows.
KDE Plasma 6.1 apporte de nombreuses améliorations au populaire bureau Linux
Jun 23, 2024 am 07:54 AM
Après plusieurs pré-versions, l'équipe de développement de KDE Plasma a dévoilé le 28 février la version 6.0 de son environnement de bureau pour les systèmes Linux et BSD, utilisant pour la première fois le framework Qt6. KDE Plasma 6.1 est désormais livré avec un certain nombre de nouvelles fonctionnalités
Pourquoi Linux et Unix sont-ils similaires ?
Mar 13, 2023 am 10:20 AM
L'intention initiale de Linux était de remplacer UNIX et d'optimiser ses fonctions et l'expérience utilisateur. Par conséquent, Linux a imité UNIX (mais n'a pas plagié le code source d'UNIX), ce qui rend Linux très similaire à UNIX en termes d'apparence et d'interaction. On peut donc dire que « UNIX est le père de Linux ». C'est précisément parce que Linux et UNIX sont inextricablement liés que les gens appellent Linux un « système de type UNIX ».
Principes de programmation de la philosophie Unix
Feb 20, 2024 am 10:54 AM
1Philosophie Unix La philosophie Unix met l'accent sur l'aspect pratique, est issue d'une riche expérience et n'est pas limitée par les méthodologies ou les normes traditionnelles. Cette connaissance est plus latente et semi-instinctive. Les connaissances que les programmeurs Unix accumulent grâce à leur expérience de développement peuvent profiter à d’autres programmeurs. (1) Chaque programme doit se concentrer sur l'accomplissement d'une tâche et recommencer lorsqu'il est confronté à une nouvelle tâche afin d'éviter d'ajouter de nouvelles fonctions au programme d'origine, ce qui entraînerait une complexité accrue. (2) En supposant que la sortie d'un programme deviendra l'entrée d'un autre programme, même si le programme suivant n'est pas clair, assurez-vous que la sortie ne contient pas d'informations non pertinentes. (3) Mettez le logiciel conçu et écrit en essai dès que possible, éliminez de manière décisive le code de mauvaise qualité et réécrivez-le. (4) Utiliser des outils avant des moyens auxiliaires inefficaces pour réduire le fardeau des tâches de programmation et viser l'excellence.
HP EliteBook X G1a : ordinateur portable professionnel puissant doté du Ryzen AI 300 avec un TDP de 40 W et une grosse batterie
Sep 25, 2024 am 06:18 AM
Parmi les deux grands fabricants américains de PC Windows, HP est certainement celui qui a adopté le plus volontiers AMD. Malgré cela, le HP EliteBook le plus cher, l'EliteBook 1000, a toujours été exclusif à Intel. Jusqu'à présent, c'est : le nouveau HP EliteBook X
Offre | L'ordinateur portable de jeu HP Victus abordable équipé du RX 6550M, qui bat le RTX 3050, bénéficie d'une réduction de 40 % dans la vente Best Buy
Aug 09, 2024 pm 09:51 PM
Le HP Victus 15 est un ordinateur portable de jeu d'entrée de gamme de 15,6 pouces qui ne mériterait normalement pas beaucoup d'attention, mais une nouvelle offre Best Buy offre 40 % de réduction sur l'ordinateur portable de jeu d'entrée de gamme, ramenant le prix de 799,99 $ à un prix très bas. économique $
