In this Document
Symptoms
Changes
Cause
Solution
While checking from the RDBMS instance the status of ASM diskgroup is shown as DISMOUNTED.
From ASM instance the status is shown as MOUNTED.
Following messages are present in the alert log of RDBMS instance.
SUCCESS: diskgroup ASMDISK02 was mounted
SUCCESS: diskgroup ASMDISK02 was dismounted
SUCCESS: diskgroup ASMDISK02 was mounted
SUCCESS: diskgroup ASMDISK02 was dismounted
SUCCESS: diskgroup ASMDISK02 was mounted
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '+ASMDISK01/cnf2/redo01.log'
ORA-17503: ksfdopn:2 Failed to open file +ASMDISK01/cnf2/redo01.log
ORA-15055: unable to connect to ASM instance
ORA-00020: maximum number of processes () exceeded
ORA-15055: unable to connect to ASM instance
ORA-00020: maximum number of processes () exceeded
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '+ASMDISK01/cnf2/redo01.log'
ORA-17503: ksfdopn:2 Failed to open file +ASMDISK01/cnf2/redo01.log
ORA-12549: TNS:operating system resource quota exceeded
The problem is due to RDBMS instance not able to communicate to ASM
instance. Whenever it is trying to communicate it is running out of OS
resources. It is not able to fork new process at OS level.
From the RDBMS instance, if we check the STATE of diskgroup:
SQL > select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
ASMDISK01 CONNECTED
ASMDISK02 DISMOUNTED
The state CONNECTED means that rdbms instance is currently using
this particular diskgroup and the state DISMOUNTED means that rdbms
instance is seeing the diskgroup not available for use.
In this case new processes from ASM instance cannot be started as it has reached its maximum limit, thus RDBMS instance is not able to communicate to ASM instance.
The default number of ASM processes is 40. To solve this we need to set the processes parameter to a large value (100 etc.)
|
产品
|
|||
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/38267/viewspace-705475/ ,如需转载,请注明出处,否则将追究法律责任。