A set of win environment of RAC, irregular anomaly, alert log often reported ORA-15055 ORA-21561 error, after analysis is due to win default desktop Heap size is too small to cause this problem, to remind you win platform run Oracle Attention of friends.
Alert Log Error
Current log# 6 seq# 1820 mem# 0: +data/rac/onlinelog/group_6.3110.876059421
Thread 2 advanced to log sequence 1821 (LGWR switch)
Current log# 5 seq# 1821 mem# 0: +data/rac/onlinelog/group_5.3109.876059417
Mon 06 14:11:34 2015
Warning:asm Communication Error:op 0 State 0x0 (15055)
Error:direct connection failure with ASM
Warning:asm Communication Error:op 0 State 0x0 (15055)
Error:direct connection failure with ASM
note:deferred Communication with ASM instance
Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\rac\rac2\trace\rac2_arc0_276.trc:
ORA-15055: Unable to connect to ASM instance
ORA-21561: Failed to generate OID
ORA-15055: Unable to connect to ASM instance
ORA-21561: Failed to generate OID
note:deferred map free for map ID 28882
Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\rac\rac2\trace\rac2_arc0_276.trc:
ORA-00313: Unable to open the members of Log Group 6 (for thread 2)
ORA-00312: Online Log 6 thread 2: ' +data/rac/onlinelog/group_6.3110.876059421 '
Ora-17503:ksfdopn:2 failed to open file +data/rac/onlinelog/group_6.3110.876059421
ORA-15055: Unable to connect to ASM instance
ORA-21561: Failed to generate OID
Arch:archival stopped, error occurred. would continue retrying
Warning:asm Communication Error:op 0 State 0x0 (15055)
Error:direct connection failure with ASM
Warning:asm Communication Error:op 0 State 0x0 (15055)
Error:direct connection failure with ASM
note:deferred Communication with ASM instance
Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\rac\rac2\trace\rac2_arc0_276.trc:
ORA-15055: Unable to connect to ASM instance
ORA-21561: Failed to generate OID
ORA-15055: Unable to connect to ASM instance
ORA-21561: Failed to generate OID
note:deferred map free for map ID 28883
Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\rac\rac2\trace\rac2_arc0_276.trc:
ORA-00313: Unable to open the members of Log Group 6 (for thread 2)
ORA-00312: Online Log 6 thread 2: ' +data/rac/onlinelog/group_6.3110.876059421 '
Ora-17503:ksfdopn:2 failed to open file +data/rac/onlinelog/group_6.3110.876059421
ORA-15055: Unable to connect to ASM instance
ORA-21561: Failed to generate OID
Database version
Sql> select * from V$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition release 11.2.0.3.0-64bit Production
Pl/sql Release 11.2.0.3.0-production
CORE 11.2.0.3.0 Production
TNS for 64-bit windows:version 11.2.0.3.0-production
Nlsrtl Version 11.2.0.3.0-production
OS Version
Sql> Host SystemInfo
Host Name: RAC2
OS Name: Microsoft Windows Server 2008 R2 Enterprise
OS version: 6.1.7601 Service Pack 1 Build 7601
OS Manufacturer: Microsoft Corporation
OS Configuration: Standalone server
OS Widget type: Multiprocessor free
Registered Owner: Windows user
By querying MoS, it is found that the problem is mainly due to a lack of sharedsection settings for win, which may also cause other errors, such as: TNS12531:TNS:cannot allocate memory.
Recommendation: For the Microsoft Windows platform database, the database version 11.2.0.1 to 12.1.0.2 system, the appropriate increase in sharedsection size according to the actual situation.
For example: Modify \hkey_local_machine\system\currentcontrolset\control\session manager\subsystems\: SharedSection= 1024,20480,1024.
The second one here is the interactive desktop Heap size, the third non-interactive desktop Heap size, we mainly modify the third value
Contact: Mobile Phone (13429648788) QQ (107644445)
Link: http://www.xifenfei.com/5981.html