Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interesting ASM Scenario.. Why nobody wants to see this????

DaljitSep 7 2006 — edited Sep 14 2006

We have a box running 10g R2 with ASM on Linux 32 bit and everything was working fine till now. Today we added one more OS account and this user should have permissions to run sqlplus. Then we found that there is a known bug for this related to the permissions and we applied the patch and got it working. Now that other user can run sqlplus but we faced a weird thing. If we issue any command from that other user in sqlplus then it give error that can't read raw device permission denied, but if that data is already cached then it show up. Means it is unable to read from disk but can access all the cached data, we really tested it thoroughly. The error which we are getting is:

SQL> desc dba_objects

ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-01115: IO error reading block from file 1 (block # 768)
ORA-01110: data file 1: '+ORADATA1/oradata/eps2/system_01.dbf'
ORA-15062: ASM disk is globally closed
ORA-15025: could not open disk '/dev/raw/raw1'
ORA-27041: unable to open file
Linux Error: 13: Permission denied
Additional information: 3

SQL> desc patient

ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-01115: IO error reading block from file 1 (block # 27183)
ORA-01110: data file 1: '+ORADATA1/oradata/eps2/system_01.dbf'
ORA-15062: ASM disk is globally closed
ORA-15025: could not open disk '/dev/raw/raw1'
ORA-27041: unable to open file
Linux Error: 13: Permission denied
Additional information: 3

Now if I login as oracle user and run these command then the data get cached and then it allow me to see this data from other OS user too. But if I make a connection using TNS means no bequeth connection from other OS user then it allow me to access data without any error. So my theory is that whenever we establish a bequeth connection then the server process permissions are different then SQL*Net. So I want to know that is it expected behavior or again permission related problems.

Daljit Singh

Message was edited by:
Daljit

Message was edited by:
Daljit

Message was edited by:
Daljit

Message was edited by:
Daljit

Message was edited by:
Daljit

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 12 2006

Added on Sep 7 2006

#general-database-discussions

15 comments

1,736 views