Impact on Oracle filesystem permission changed
402451Feb 27 2009 — edited Feb 27 2009My database is on cluster file system. I have changed permission of file system where my all files datafiles,controlfiles and redologs are stored. I have changed filesystem permission from oracle user to root user. It still allow me all DML operation like insert ,delete and update on table. Oracle also allow me to commit transaction.
My question is, at time of commit LGWR write redo buffer to redo log files, if filesystem don’t have permission to write on it then how commit operation is allowed.
As soon as I execute “alter system checkpoint” my database showing permission error on alert file.
Why it is showing permission error at the time of checkpoint and why don’t at the time of commit, even though it is writing on filesytem on both operation.