?WARNING: ASM communication error: op 0 state 0x0 (15055)
資料庫日誌大量錯誤如下:
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
解決方法:
ASM Database Instance Is Reporting: “[WARNING: ASM communication error: op 0 state 0x0 (15055)]” (文件 ID 1665311.1)
SOLUTION
1) Please add the patrolag OS user in the "asmdba" OS group on all the nodes.
+ASM1@bdwswu1:/optware/oracle/11.2.0.2/grid/bin> grep asmdba /etc/group
asmdba:!:1300:grid,oracle,patrolag
asmdba:!:1300:grid,oracle,patrolag
2) Once customer you add the "patrolag" OS user into the "asmdba" OS group the alerts/warnings will stop:
Wed Apr 09 14:45:26 2014
Thread 1 advanced to log sequence 12690 (LGWR switch)
Current log# 2 seq# 12690 mem# 0: +DATA/mstru/redo02.log
Wed Apr 09 14:45:26 2014
Archived Log entry 20828 added for thread 1 sequence 12689 ID 0x4cae0d0f dest 1
Thread 1 advanced to log sequence 12690 (LGWR switch)
Current log# 2 seq# 12690 mem# 0: +DATA/mstru/redo02.log
Wed Apr 09 14:45:26 2014
Archived Log entry 20828 added for thread 1 sequence 12689 ID 0x4cae0d0f dest 1
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26442936/viewspace-1368539/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- error:slave communication error with ASMErrorASM
- ERROR: slave communication error with ASMErrorASM
- (Error -1170 @ 0x0) Unable to access the DAP)Error
- Memory for crash kernel (0x0 to 0x0) notwithin permissible range的解決辦法
- SP2-0642: SQL*Plus internal error state 2130, context 0:0:0SQLErrorContext
- MySQL ERROR Got an error reading communication packetsMySqlErrorGo
- Unable To Create Database Using ASM ORA-15055DatabaseASM
- SP2-0642: SQL*Plus internal error state 2130, context 0:0:0 Unsafe to proceedSQLErrorContext
- [ASP.NET State service] errorASP.NETError
- 對XML 進行 parse 時的Invalid Unicode character (0x0) 分析XMLUnicode
- ORA-15055 Unable to Connect to ASM When Starting an InstanceASM
- Error: 9002, Severity: 17, State: 6Error
- Error: 17803, Severity: 20, State: 12Error
- ORA-15055 ASM Diskgroup Status Showing Dismounted From RDBMS InstanceASM
- SAP Java Connector 錯誤 - JCO_ERROR_COMMUNICATIONJavaError
- Lost connection to MySQL server at ‘reading initial communication packet', system error: 0 mysql遠端連線問題MySqlServerError
- ASM ORA-15055,ORA-00020問題解決(原)ASM
- ORA-12157: TNS:internal network communication errorError
- ORA-15055: unable to connect to ASM instance 造成 RAC的db不能啟動ASM
- ORA-15055 ORA-12549 Unable To Connect To ASM Instance問題ASM
- C++ Programming Error/Warning Analysis (2) extra qualificationC++Error
- 【故障處理】Bug : ASM FAILS WITH CHECKRESOURCE ERROR ERROR CODE = 139ASMAIError
- vipca報錯 Error 0PCAError
- Redis Cluster [WARNING] Node 127.0.0.1:7003 has slots in migrating state (15495).Redis127.0.0.1
- 【RAC】ORA-15055: unable to connect to ASM instanceORA-12547: TNS:lost contactASM
- ONS自動offline - Authentication OSD error, op: scls_auth_client_response_setErrorclient
- SP2-0642: SQL*Plus internal error state 2165SQLError
- Error: 17803, Severity: 20, State: 7 Insufficient memory availableErrorAI
- ORA-15137: The ASM cluster is in rolling patch stateASM
- oracle asm diskgroup add datafile error problemOracleASMError
- ORA-15055: unable to connect to ASM instanceORA-12547: TNS:lost contact(轉載)ASM
- 11g rac multipath asmlib ASM asm_open error Operation not permittedASMErrorMIT
- tensorflow.python.framework.errors_impl.InvalidArgumentError: assertion failed: [0] [Op:Assert] namePythonFrameworkErrorAI
- ORA-15186: ASMLIB error function = [asm_open], error = [1]ASMErrorFunction
- 360 Atals:Cause: java.sql.SQLException: Proxy Warning - near “status“: syntax errorJavaSQLExceptionError
- C++ Programming Error/Warning Analysis (1) cannot have cv-qualifierC++Error
- [MobX State Tree資料元件化開發][0]:開篇元件化
- OP code彙總