SQL> startup nomount
ORA-01565: error in identifying file '+DATA/rzora11g/spfilerzora11g.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/rzora11g/spfilerzora11g.ora
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15040: diskgroup is incomplete

alert日志如下
NOTE: Loaded library: System
ORA-15025: could not open disk "/dev/asm-diskf"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
Sat May 03 20:11:40 2014
SUCCESS: diskgroup DATA was dismounted
ERROR: diskgroup DATA was not mounted
ORA-01565: Unable to open Spfile +DATA/rzora11g/spfilerzora11g.ora.
USER (ospid: 5171): terminating the instance due to error 1565
Instance terminated by USER, pid = 5171
 

DatabaseWill Not Mount: ORA-15025, ORA-27041, 'Permission denied', ORA-15081 [ID1378747.1]

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
The Database software owner has proper Primary Group, Database OSDBA, DatabaseOPER, and ASM OSDBA groups assigned to it:
# id oracle
The ASM disks have the proper user:group and file permissions:
# ls -ltra /dev/asm*
Proper SETUID (SETGID), owner for each of the Oracle Homes' oracle executable:
Cause
However the problem is that the Databaseoracle executable is not assigned to the ASM OSASM group (instead is assignedto the 'oinstall' group):
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

[grid@node2 ~]$ cd /u01/app/11.2.0/grid/bin/
[grid@node2 bin]$ ls -tlr setasmgidwrap
-rwxr-xr-x 1 grid oinstall 2324 Apr  2 01:32 setasmgidwrap
[grid@node2 bin]$
[grid@node2 bin]$
[grid@node2 bin]$ ./setasmgidwrap o=/u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle




Related posts

coded by nessus
分享:  DeliciousGReader鲜果豆瓣CSDN网摘
Trackback

2 comments untill now

  1. aides@unnecessary.snakes” rel=”nofollow”>.…

    tnx for info….

  2. turks@generalized.alphabetic” rel=”nofollow”>.…

    ñýíêñ çà èíôó….

Add your comment now

无觅相关文章插件