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/ANARTEST/ANARTEST1/trace/ANARTEST1_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 ANARTEST1_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,ANARTEST

 dba::1001:oracle

 oper::1002:oracle

 asmdba::1003:grid,oracle

 asmoper::1004:grid

 asmadmin::1005:oracle,grid




This working fine ..!! Problem Solved..
Advertisements

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: