Windows system ORA-15055 ORA-21561 error Handling-Increase SharedSection value

Source: Internet
Author: User
Tags error handling oracle database


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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.