The Oracle Database Appliance: ORA-15025: could not open disk


1. Wrong ASM Permissions

Szenario

A new ODA with Single Instance deploment for a failover configuration. During initial start of the database on, the other node, the database will die as it switches into MOUNT mode:

...
ORA-15025: could not open disk "/dev/mapper/HDD_E0_S00_531029776p1"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
ORA-15025: could not open disk "/dev/mapper/HDD_E0_S01_530979052p1"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
...

The problem is, that the deployment set the ASM GID, according to the deployment type. In a RAC deployment the problem should not exist. To solve the problem:

Startingpoint

[grid@oak1 ~]$ ls -l /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/oracle
-rwsr-s--x 1 oracle asmadmin 232472632 Feb 5 13:42 /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/oracle
[grid@oak2 ~]$ ls -l /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/oracle
-rwsr-s--x 1 oracle oinstall 232472632 Feb 5 13:43 /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/oracle

 Solution

[grid@oak2 ~]$ setasmgidwrap o=/u01/app/oracle/product/11.2.0.3/dbhome_1/bin/oracle
[grid@oak2 ~]$ ls -l /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/oracle
-rwsr-s--x 1 oracle asmadmin 232472632 Feb 5 13:43 /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/oracle
[grid@oak2 ~]$

Check

[grid@oak1 ~]$ ls -l /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/oracle
-rwsr-s--x 1 oracle asmadmin 232472632 Feb 5 13:42 /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/oracle
[grid@oak2 ~]$ ls -l /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/oracle
-rwsr-s--x 1 oracle asmadmin 232472632 Feb 5 13:43 /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/oracle

2. Wrong Group Permissions

Szenario

A new ODA with NO DATABASE deploment. During initial start of the database on one of both nodes you will get:

...
ORA-15025: could not open disk "/dev/mapper/HDD_E0_S00_531029776p1"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
ORA-15025: could not open disk "/dev/mapper/HDD_E0_S01_530979052p1"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
...

The problem is, that the oracle group permissions are not deployed correctly. To solve the problem:

Startinpoint

[bash ~]# id oracle
uid=1001(oracle) gid=1001(oinstall) groups=1001(oinstall),1002(dba),1003(racoper),1004(asmdba)

ASM Disk permission

[bash ~]# ls -l /dev/mapper/HDD_E0_S*
brw-rw---- 1 grid asmadmin 252,  0 Feb 21 15:55 /dev/mapper/HDD_E0_S00_1128733508
...

Solution
Change /etc/group from

oinstall:x:1001:grid,oracle
dba:x:1002:oracle
racoper:x:1003:grid,oracle
asmdba:x:1004:grid,oracle
asmoper:x:1005:grid
asmadmin:x:1006:grid

to

oinstall:x:1001:grid,oracle
dba:x:1002:oracle
racoper:x:1003:grid,oracle
asmdba:x:1004:grid,oracle
asmoper:x:1005:grid,oracle
asmadmin:x:1006:grid,oracle

Repeat on the second node.
Check

[bash ~]# id oracle
uid=1001(oracle) gid=1001(oinstall) groups=1001(oinstall),1002(dba),1003(racoper),1004(asmdba),1005(asmoper),1006(asmadmin)

One thought on “The Oracle Database Appliance: ORA-15025: could not open disk

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s