Control File Error while starting Database

Posted: January 12, 2012 in ControlFile

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.

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