1.参照以下文档确认ASM磁盘权限问题
DatabaseWill Not Mount: ORA-15025, ORA-27041, 'Permission denied', ORA-15081 [ID1378747.1]
In this Document
Applies to:
Oracle Database -Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
Symptoms
Database instance will not mount:
alert_ORCL.log:
~~~~~~~~~~~~~~~~~~
...
Thu Nov 17 14:32:28 2011
Starting ORACLE instance (normal)
...
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options.
...
Thu Nov 17 14:32:33 2011
ALTER DATABASE MOUNT
NOTE: Loaded library: System
ORA-15025: could not open disk '/dev/oracleasm/disks/DATA01'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
SUCCESS: diskgroup DATA was mounted
NOTE: dependency between database ORCL and diskgroup resource ora.DATA.dg isestablished
ORA-15025: could not open disk '/dev/oracleasm/disks/FLASH01'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
SUCCESS: diskgroup FLASH was mounted
ORA-00204 : error in reading (block 1, # blocks 1) of control file
ORA-00202 : control file: '+FLASH/orcl/controlfile/current.256.711293457'
ORA-15081 : failed to submit an I/O operation to a disk
ORA-00204 : error in reading (block 1, # blocks 1) of control file
ORA-00202 : control file: '+DATA/orcl/controlfile/current.256.711293457'
ORA-15081 : failed to submit an I/O operation to a disk
NOTE: dependency between database ORCL and diskgroup resource ora.FLASH.dg isestablished
Thu Nov 17 14:32:36 2011
Checker run found 2 new persistent data failures
ORA-205 signalled during: ALTER DATABASE MOUNT...
Sat Nov 19 02:51:01 2011
SUCCESS: diskgroup DATA was dismounted
SUCCESS: diskgroup FLASH was dismounted
The ASM instance has all necessary ASM diskgroups mounted.
Changes
Job role separation between the ASM and theDatabase software owners, check fine (see exception further below):
The ASM softwareowner has proper Primary Group, ASM OSASM, ASM OSDBA, ASM OSPER and DatabaseOSDBA groups assigned to it:
# id grid
uid=27637( grid ) gid=7101( oinstall ) groups=106( dba ),787( asmadmin ),788(asmdba ),789(asmoper),7101(oinstall)
The Database software owner has proper Primary Group, Database OSDBA, DatabaseOPER, and ASM OSDBA groups assigned to it:
# id oracle
uid=19114( oracle ) gid=7101( oinstall ) groups=106( dba ),786(oper),788( asmdba),7101(oinstall)
The ASM disks have the proper user:group and file permissions:
# ls -ltra /dev/oracleasm/disks/*
brw-rw---- 1 grid asmadmin 8, 161 Nov 19 05:08/dev/oracleasm/disks/DATA01
brw-rw---- 1 grid asmadmin 8, 177 Nov 19 05:08/dev/oracleasm/disks/FLASH01
Proper SETUID (SETGID), owner for each of the Oracle Homes' oracle executable:
-rwsr-s--x 1 grid oinstall 184437523 Sep 13 2010/appl/oraasm/OracleHomes/asm_1/bin/ oracle
-rwsr-s--x 1 oracle oinstall 210973186 May 31 21:25/appl/oracle/OracleHomes/11.2.0/bin/ oracle
Cause
However the problem is that the Databaseoracle executable is not assigned to the ASM OSASM group (instead is assignedto the 'oinstall' group):
-rwsr-s--x 1 oracle oinstall 210973186 May 31 21:25 /appl/oracle/OracleHomes/11.2.0/bin/oracle
It needs to be:
-rwsr-s--x 1 oracle asmadmin 210973186 May 31 21:25 /appl/oracle/OracleHomes/11.2.0/bin/oracle
Solution
To correct the proper group for the Databaseoracle executable, do:
As the<asm_home sfw owner>:
$ cd <asm_home>/bin
$ ./setasmgidwrap o=<db_home>/bin/oracle
Now check that the primary group for the Database oracle executable is nowasmadmin (not oinstall).
If done, restart the database.
2.查看ORACLE用户环境变量NLS_LANG,尝试注释该环境变量,重新进行dbca