RAC GRID Root.sh ORA-27091 ORA-15081 unable to queue I/O

RAC GRID Root.sh ORA-27091 ORA-15081 unable to queue I/O

ERROR:

[root@node-01 install]# /u01/app/11.2.0/grid/root.sh
Running Oracle 11g root script...

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/11.2.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
LOCAL ADD MODE
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
OLR initialization - successful
Adding daemon to inittab
ACFS-9200: Supported
ACFS-9300: ADVM/ACFS distribution files found.
ACFS-9307: Installing requested ADVM/ACFS software.
ACFS-9308: Loading installed ADVM/ACFS drivers.
ACFS-9321: Creating udev for ADVM/ACFS.
ACFS-9323: Creating module dependencies - this may take some time.
ACFS-9327: Verifying ADVM/ACFS devices.
ACFS-9309: ADVM/ACFS installation correctness verified.
CRS-2672: Attempting to start 'ora.mdnsd' on 'node-01'
CRS-2676: Start of 'ora.mdnsd' on 'node-01' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'node-01'
CRS-2676: Start of 'ora.gpnpd' on 'node-01' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'node-01'
CRS-2672: Attempting to start 'ora.gipcd' on 'node-01'
CRS-2676: Start of 'ora.cssdmonitor' on 'node-01' succeeded
CRS-2676: Start of 'ora.gipcd' on 'node-01' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'node-01'
CRS-2672: Attempting to start 'ora.diskmon' on 'node-01'
CRS-2676: Start of 'ora.diskmon' on 'node-01' succeeded
CRS-2676: Start of 'ora.cssd' on 'node-01' succeeded

ASM created and started successfully.

Disk Group OCR_VOTE created successfully.

Errors in file :
ORA-27091: unable to queue I/O
ORA-15081: failed to submit an I/O operation to a disk
ORA-06512: at line 4
PROT-1: Failed to initialize ocrconfig
PROC-26: Error while accessing the physical storage
ORA-27091: unable to queue I/O
ORA-15081: failed to submit an I/O operation to a disk
ORA-06512: at line 4

Failed to create Oracle Cluster Registry configuration, rc 255
Oracle Clusterware Repository configuration failed at /u01/app/11.2.0/grid/crs/install/crsconfig_lib.pm line 6471.
/u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/rootcrs.pl execution failed
[root@node-01 install]#


Solution:

The ASM Lib configuration was done with oracle id,But the grid installation i am doing with grid user.

[root@node-02 11202stage]# /usr/sbin/oracleasm configure
ORACLEASM_ENABLED=true
ORACLEASM_UID=oracle
ORACLEASM_GID=dba
ORACLEASM_SCANBOOT=true
ORACLEASM_SCANORDER=""
ORACLEASM_SCANEXCLUDE=""
ORACLEASM_USE_LOGICAL_BLOCK_SIZE="false"

[root@node-02 11202stage]#

Update the configuration of ASMlib

/usr/sbin/oracleasm configure -u grid 

[root@node-02 11202stage]# /usr/sbin/oracleasm configure
ORACLEASM_ENABLED=true
ORACLEASM_UID=grid
ORACLEASM_GID=asmadmin
ORACLEASM_SCANBOOT=true
ORACLEASM_SCANORDER=""
ORACLEASM_SCANEXCLUDE=""
ORACLEASM_USE_LOGICAL_BLOCK_SIZE="false"

[root@node-02 11202stage]#

For fresh installation delete the Disk group at asmlib.

/usr/sbin/oracleasm deletedisk OCR_VOTE01
/usr/sbin/oracleasm deletedisk ASM_DATA01
/usr/sbin/oracleasm deletedisk ASM_FRA01

And Recreate

/usr/sbin/oracleasm createdisk OCR_VOTE01 /dev/sde1
/usr/sbin/oracleasm createdisk ASM_DATA01 /dev/sdf1

/usr/sbin/oracleasm createdisk ASM_FRA01 /dev/sdg1

/usr/sbin/oracleasm listdisks

/usr/sbin/oracleasm scandisks

Now rerun the root.sh

 

 

http://oracletechdba.blogspot.com/2014/09/rac-grid-rootsh-ora-27091-ora-15081.html

ORA-12012,ORA-20001 AND ORA-06512 FROM ORA$AT_OS_OPT_SY_XXX

Problem :

========

ORA-12012: error on auto execute of job “SYS”.”ORA$AT_OS_OPT_SY_936″
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: at “SYS.DBMS_STATS”, line 47207
ORA-06512: at “SYS.DBMS_STATS_ADVISOR”, line 882
ORA-06512: at “SYS.DBMS_STATS_INTERNAL”, line 20059
ORA-06512: at “SYS.DBMS_STATS_INTERNAL”, line 22201
ORA-06512: at “SYS.DBMS_STATS”, line 47197
2017-03-13T00:47:21.394481+00:00

Cause :
========

This issue is happening because of the unavailability of the Stats Advisor Tasks from the created database.

Resolution :
=============

1. Connect to the created database using the SYSDBA privilege and run the following command:
2.

SQL>select name, ctime, how_created
from sys.wri$_adv_tasks
where owner_name = ‘SYS’
and name in (‘AUTO_STATS_ADVISOR_TASK’,’INDIVIDUAL_STATS_ADVISOR_TASK’);

no rows selected

3.

SQL> EXEC dbms_stats.init_package();

PL/SQL procedure successfully completed.

4.

SQL>select name, ctime, how_created
from sys.wri$_adv_tasks
where owner_name = ‘SYS’
and name in (‘AUTO_STATS_ADVISOR_TASK’,’INDIVIDUAL_STATS_ADVISOR_TASK’);

NAME                                                            CTIME             HOW_CREATED
——————–                                                —————–     ———————
AUTO_STATS_ADVISOR_TASK                  13-MAR-17       CMD
INDIVIDUAL_STATS_ADVISOR_TASK     13-MAR-17       CMD

 

5. Once the Stats Advisor Tasks are available in database, the database alert log no longer has: – ORA-06512 FROM ORA$AT_OS_OPT_SY_XXX