ORA-15055 ASM Diskgroup Status Showing Dismounted From RDBMS Instance
在資料庫例項中檢查asm 磁碟組的狀態時,顯示 DISMOUNTED,但是在asm 例項上卻顯示MOUNTED
在資料庫例項的alert 日誌中會出現如下資訊:
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
原因:
這個問題是由於資料庫例項不能和asm 例項進行通訊,不管何時嘗試連線asm,它都用盡os 資源。在系統級別上不能建立新的程式。
在 資料庫例項上檢查磁碟組的狀態:
SQL > select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
ASMDISK01 CONNECTED
ASMDISK02 DISMOUNTED
CONNECTED 意味著資料庫例項正在使用這個磁碟組
DISMOUNTED 意味著資料庫例項將磁碟組視為不可用。
解決辦法:
在這種情況下由於asm 程式數已經達到上限,新的asm程式不能建立導致資料庫例項不能夠連線到asm上。預設的ASM程式數為40,可以將 程式相關的引數設定為更高一些 比如150
在資料庫例項的alert 日誌中會出現如下資訊:
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
原因:
這個問題是由於資料庫例項不能和asm 例項進行通訊,不管何時嘗試連線asm,它都用盡os 資源。在系統級別上不能建立新的程式。
在 資料庫例項上檢查磁碟組的狀態:
SQL > select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
ASMDISK01 CONNECTED
ASMDISK02 DISMOUNTED
CONNECTED 意味著資料庫例項正在使用這個磁碟組
DISMOUNTED 意味著資料庫例項將磁碟組視為不可用。
解決辦法:
在這種情況下由於asm 程式數已經達到上限,新的asm程式不能建立導致資料庫例項不能夠連線到asm上。預設的ASM程式數為40,可以將 程式相關的引數設定為更高一些 比如150
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22664653/viewspace-689078/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Why Archive, FRA Diskgroup Gets Mounted / DismountedHive
- How to move ASM database files from one diskgroup to anotherASMDatabase
- ORA-15055 Unable to Connect to ASM When Starting an InstanceASM
- How to free space from an ASM diskgroup? (Doc ID 1553744.1)ASM
- 【RAC】Diskgroup shows offline after restart even it is mounted in ASM instanceRESTASM
- Physical Standby Switchover_status Showing Not Allowed
- STATUS OF ORACLE INSTANCEOracle
- ORA-15055: unable to connect to ASM instance 造成 RAC的db不能啟動ASM
- ORA-15055 ORA-12549 Unable To Connect To ASM Instance問題ASM
- Physical Standby Switchover_status Showing Not Allowed._1392763.1
- Asm diskgroup 的修復ASM
- script of check repair ASM DISKGROUPAIASM
- Physical Standby Switchover_status Showing Not Allowed. (Doc ID 1392763.1)
- 給ASM例項增加diskgroupASM
- Manage ASM instance-creating diskgroup,adding/dropping/resizing disks_270066.1ASM
- [Shell] monitor oracle database listener & instance statusOracleDatabase
- Oracle ASM Partnership and Status TableOracleASM
- ASM管理 - 如何重新命名diskgroupASM
- Unable To Create Database Using ASM ORA-15055DatabaseASM
- ASM Spfile Is Not Used when ASM Instance StartsASM
- Using FTP Transferring Non-ASM Datafiles to ASM diskgroupFTPASM
- 7.monitor oracle database listener & instance statusOracleDatabase
- oracle asm diskgroup add datafile error problemOracleASMError
- 學習ASM技術(三)--diskgroup管理ASM
- 學習ASM技術(二)--diskgroup管理ASM
- 新建或修改ASM diskgroup 的問題ASM
- votedisk在ASM diskgroup上的存放規律ASM
- asm 相容性、asm instance 主要引數管理ASM
- ASMCA fails to create 11.2 ASM instance when upgrading from 10.2 [ID 1125053.1]ASMAI
- 檢查asm磁碟組狀態的檢視v$asm_diskgroupASM
- Linux 磁碟對應 ASM diskgroup 中的磁碟LinuxASM
- 在ASM Diskgroup間移動資料檔案ASM
- 向ASM diskgroup中新增磁碟的例行檢查ASM
- ASM Diskgroup Can Not Be Shown When Creating Database With DBCAASMDatabase
- solaris 10_oracle asm_diskgroup_failgroup_相關OracleASMAI
- CRS-215 Srvctl unable to start ASM, Listener, RDBMS ResourcesASM
- Move datafile:From File System to ASMASM
- Move datafile:From ASM to File SystemASM