Archive for the ‘ControlFile’ Category

While starting one of database, i faced the below error:

ORA-00202: control file: ‘/u09/oradata/MYTEST/TEST1/control02.ctl’
ORA-27086: unable to lock file – already in use
IBM AIX RISC System/6000 Error: 13: Permission denied
Additional information: 8
Mon Dec 19 10:29:03 2011
ORA-205 signalled during: ALTER DATABASE MOUNT…

My first thought is that some oracle process is┬ástill using the controlfile even after the successful shutdown immediate. Since, only one database was running on this server, so i simply checked for processes running from OS user owining database. In this case OS user “oracle” owns the database.

/home/oracle => ps -ef|grep oracle

No process comes from above command which is related to database and could have locks on control file.

So, next step is to involve AIX administrator. Since, /u09 is NFS mounted file system, i asked AIX Admin to check for NFS service and Bingooo…..

To resolve this error, one should clear the NFS Demon process from OS, if the mount points having controlfile are NFS mounted.