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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-15055 Unable to Connect to ASM When Starting an InstanceASM
- Physical Standby Switchover_status Showing Not Allowed. (Doc ID 1392763.1)
- linux vdo驗證 oracle asm diskgroup sector_size 4096 udev asmlibLinuxOracleASMdev
- How to Increase CSS Misscount in single instance ASM installations [ID 729878.1]CSSASM
- ASM磁碟空間假裝耗盡,ORA-15041: diskgroup space exhaustedASM
- A basic Monoid definition gives “No instance for (Semigroup MyMonoid) arising from the superclassesMono
- Linux 6.9 加盤後的Oracle 12c ASM DiskGroup配置過程LinuxOracleASM
- diskgroup "DATADG" cannot be mounted
- WPF implemented Single Instance via mutex and activated the existed window via FindWindow from Microsoft.Win32; namespaceMutexROSWin32namespace
- MySQL案例04:Cause: java.sql.SQLException: Could not retrieve transaction read-only status from serverMySqlJavaExceptionServer
- RDBMS VS XML VS NoSQLXMLSQL
- vertx instance
- GPU InstanceGPU
- Check failed: status == CUDNN_STATUS_SUCCESS (4 vs. 0) CUDNN_STATUS_INTERNAL_ERRORAIDNNError
- 3.2.1 Mounting a Database to an InstanceDatabase
- 3.1.5.6 Forcing an Instance to Start
- Cassandra與RDBMS的設計差別
- 資料庫事務耗時過長導致Could not retrieve transaction read-only status from server異常資料庫Server
- TIC Read Status
- git status 命令Git
- ERROR: failed to establish dependency between database db_name and diskgroupErrorAIDatabase
- C++ instance的使用C++
- RMAN Duplicate RAC to Single Instance
- ORA-15041 IN A DISKGROUP ALTHOUGH FREE_MB REPORTS SUFFICIENT SPACE
- [異常等待事件rdbms ipc reply]-分析說明事件
- 3.1.5.2 Starting an Instance, and Mounting and Opening a DatabaseDatabase
- Property [title] does not exist on this collection instance
- 【ASM】Oracle asm刪除磁碟組注意事項ASMOracle
- 【ASM】ASM磁碟頭被重寫,如何修復ASM
- SAP CRM One order裡user status和system status的mapping邏輯APP
- [20210506]RAC crsctl status ... -v 獲取last started or status changes資訊.txtAST
- goldengate + asm + racGoASM
- gnu inline asminlineASM
- oracle RDBMS Kernel Executable 佔用記憶體過高Oracle記憶體
- oracle自帶指令碼說明(rdbms,ctx,sqlplus,javavm)Oracle指令碼SQLJava
- git status命令詳解Git
- HTTP Status 400 – Bad RequestHTTP
- 【ASM】ASM啟動無法找到spfile問題原因ASM
- 從定位資料塊所在ASM磁碟到ASM strippingASM