ORA-15025: could not open disk “/dev/rdsk/emcpower2a” ORA-27041: unable to open file SVR4 Error: 13: Permission denied Additional information: 3


Issue
 ======
 Getting frequent errors as below

Mon Jun 20 18:58:09 2016
 Errors in file /u01/app/oracle/diag/rdbms/aztest/AZTEST1/trace/AZTEST1_ora_16361.trc:
 ORA-15025: could not open disk "/dev/rdsk/emcpower2a"
 ORA-27041: unable to open file
 SVR4 Error: 13: Permission denied
 Additional information: 3
 WARNING: failed to read mirror side 1 of virtual extent 23 logical extent 0 of file 259 in group [1.443862875] from disk DATA_0000 allocation unit 546 reason error; if possible, will try another mirror side
 Cause
 =========

From the AZTEST1_ora_16361.trc
 ---------------------------------------------
 *** SERVICE NAME:(SYS$USERS) 2016-06-20 18:58:09.162
 *** MODULE NAME:() 2016-06-20 18:58:09.162
 *** ACTION NAME:() 2016-06-20 18:58:09.162

WARNING: failed to open a disk[/dev/rdsk/emcpower2a]
 ORA-15025: could not open disk "/dev/rdsk/emcpower2a"
 ORA-27041: unable to open file
 SVR4 Error: 13: Permission denied
 Additional information: 3
 kfk_debug_get_user_groups: uid:503, euid:500, gid:1001, egid:1005<<<<<<<<<<<<<<<<<
 WARNING: failed to open a disk[/dev/rdsk/emcpower2a]
 ORA-15025: could not open disk "/dev/rdsk/emcpower2a"
 ORA-27041: unable to open file
 SVR4 Error: 13: Permission denied
 Additional information: 3
 kfk_debug_get_user_groups: uid:503, euid:500, gid:1001, egid:1005
 WARNING: disk locally closed resulting in I/O error
 WARNING: Read Failed. group:1 disk:0 AU:546 offset:327680 size:8192

User with ID 503 and GID 1001 trying to access the database.

i.e. User ABS with group DBA trying to access the database which is causing the error

Disks were owned by grid:asmadmin and ASM home owned by grid:oinstall and DB home is owned by oracle:oinstall

So User ABS does not have privilege to access the ASM disks hence the errors
 Solution
 =========
 Either add ABS user to group asmdba or use oracle user to access the database
 root@bakuabsutdb1:~# vi /etc/group

root::0:
 other::1:root
 bin::2:root,daemon
 sys::3:root,bin,adm
 adm::4:root,daemon
 uucp::5:root
 mail::6:root
 tty::7:root,adm
 lp::8:root,adm
 nuucp::9:root
 staff::10:
 daemon::12:root
 sysadmin::14:
 games::20:
 smmsp::25:
 gdm::50:
 upnp::52:
 xvm::60:
 netadm::65:
 mysql::70:
 openldap::75:
 webservd::80:
 postgres::90:
 unknown::96:
 nobody::60001:
 noaccess::60002:
 nogroup::65534:
 aiuser::61:
 ftp::21:
 pkg5srv::97:
 mlocate::95:
 oinstall::1000:abs,abstest
 dba::1001:oracle
 oper::1002:oracle
 asmdba::1003:grid,oracle
 asmoper::1004:grid
 asmadmin::1005:oracle,grid

This working fine ..!! Problem Solved..

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

%d bloggers like this: