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

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

 

 

--
http://www.freelists.org/webpage/oracle-l