11gR2 : SELECT ... FOR UPDATE FAILED ! ORA-01116 ORA-01110 ORA-27041

Sep 5, 2013 1:55PM

Hi ,I have this error on production environment ( AIX 6.1 11.2.0.3) when trying to execute this query :

SELECT * FROM TP_PRODUCTS WHERE cd_prod='FMT' AND id_cat=217 for update ;

ORA-01116: error in opening database file 5

ORA-01110: data file 5 : '/PRODUCTS/idx/indx0002/PRODUCTS_02.dbf'

ORA-27041: unable to open file IBM AIX RISC System/6000 Error: 13: Permission denied

I have also encountered this error :

ORA-01110: data file 1 : '/PRODUCTS/data/osys1/sys01.dbf'

ORA-27041: unable to open file

IBM AIX RISC System/6000 Error: 13: Permission denied

root@server_AIX_61:/PRODUCTS/data/osys1$ ls -l *sys01*.dbf

-rwxr-xr-x 1 oracle dba 4777 Sep 05 17:45 sys01.dbf

-rwxr-xr-x => READ right exists for all users ! so why this error ?

Database Administration (MOSC)