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 < 8192MB
then match RAM
else RAM > 8192MB
then .75 times RAM