all time worst question I have been ever asked as a DBA
From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Tue, 26 Jul 2011 14:38:04 -0500
Message-ID: <CAJvnOJYbu6VCMKpsdFhrWDio2TqGnbW5Byae4ErrW=0HkL144Q_at_mail.gmail.com>
So, I am getting this error on one of our virtual Linux servers:
Date: Tue, 26 Jul 2011 14:38:04 -0500
Message-ID: <CAJvnOJYbu6VCMKpsdFhrWDio2TqGnbW5Byae4ErrW=0HkL144Q_at_mail.gmail.com>
So, I am getting this error on one of our virtual Linux servers:
ORA-00210: cannot open the specified control file ORA-00202: control file: '/u01/app/oracle/datafiles/devdb/control01.ctl' ORA-27086: unable to lock file - already in use
Its probably due to a stale NFS lock. The question from my sys admin:
-rw-r----- 1 oracle oinstall 10076160 Jul 22 13:33 control01.ctl
can that file just be removed
Ok, I am a little frustrated with him...
-- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 26 2011 - 14:38:04 CDT