RE: all time worst question I have been ever asked as a DBA

  • From: "Aragon, Gabriel (GE, Corporate, consultant)" <gabriel.aragon@xxxxxx>
  • To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Lyall Barbour
Sent: Martes, 26 de Julio de 2011 02:46 p.m.
To: "ORACLE-L"
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

        To: ORACLE-L

        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:

        -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.'

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 07-2011