RE: all time worst question I have been ever asked as a DBA
Date: Tue, 26 Jul 2011 16:02:44 -0400
I have some of those..
User: can you please create this table?
DBA: No, table already exists in your schema.
User: Oh, can you please force create?
User: Pls upgrade to 11g, but not entire database only my schema, I don’t want the other users to be affected
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Lyall Barbour
Sent: Martes, 26 de Julio de 2011 02:46 p.m.
Subject: Re: all time worst question I have been ever asked as a DBA
Well, you made at least half the list's day with this one. From all of us, "thank you"
- Original Message -----
From: Andrew Kerber
Sent: 07/26/11 03:38 PM
Subject: all time worst question I have been ever asked as a DBA
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:Received on Tue Jul 26 2011 - 15:02:44 CDT
-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.'