Re: all time worst question I have been ever asked as a DBA
- From: Marco Gralike <Marco.Gralike@xxxxxxx>
- To: "Stephens, Chris" <Chris.Stephens@xxxxxxx>, "andrew.kerber@xxxxxxxxx" <andrew.kerber@xxxxxxxxx>, Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 27 Jul 2011 19:26:40 +0200
BTW
I also never use those file extensions anymore, but then again DBCA still has
that practice and I would not be surprised if it turned up in OCP manuals etc.
I once created an enhancement request saying that "this new APEX core
directory, regarding naming is probably not a good idea to implement".
They didn't get the point, or I didn't got my point across, that old unix admin
methods / people (maybe still also on linux nowadays) have a practice to delete
from time to time core files and core directories on their filesystems…
From: "Stephens, Chris" <Chris.Stephens@xxxxxxx<mailto:Chris.Stephens@xxxxxxx>>
Date: Wed, 27 Jul 2011 17:02:52 +0200
To: Marco Gralike <marco.gralike@xxxxxxx<mailto:marco.gralike@xxxxxxx>>,
"andrew.kerber@xxxxxxxxx<mailto:andrew.kerber@xxxxxxxxx>"
<andrew.kerber@xxxxxxxxx<mailto:andrew.kerber@xxxxxxxxx>>, Oracle-L
<oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>>
Subject: RE: all time worst question I have been ever asked as a DBA
Which is the #1 reason I no longer allow redo logs to end in ‘.log’! ☺
I have that as a check implemented in a procedure that runs each night to
ensure every database in our environment complies with a few standards that I
don’t consider to be debatable.
From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Marco Gralike
Sent: Wednesday, July 27, 2011 9:57 AM
To: andrew.kerber@xxxxxxxxx<mailto:andrew.kerber@xxxxxxxxx>; ORACLE-L
Subject: RE: all time worst question I have been ever asked as a DBA
Be happy that he asked. Sometimes they just delete log files because they need
the space.
________________________________
Van:oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>] namens
Andrew Kerber [andrew.kerber@xxxxxxxxx<mailto:andrew.kerber@xxxxxxxxx>]
Verzonden: dinsdag 26 juli 2011 21:38
Aan: ORACLE-L
Onderwerp: 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.'
CONFIDENTIALITY NOTICE:
This message is intended for the use of the individual or entity to which it is
addressed and may contain information that is privileged, confidential and
exempt from disclosure under applicable law. If the reader of this message is
not the intended recipient or the employee or agent responsible for delivering
this message to the intended recipient, you are hereby notified that any
dissemination, distribution or copying of this communication is strictly
prohibited. If you have received this communication in error, please notify us
immediately by email reply.
Other related posts:
- » all time worst question I have been ever asked as a DBA- Andrew Kerber
- » Re: all time worst question I have been ever asked as a DBA- Lyall Barbour
- » Re: all time worst question I have been ever asked as a DBA- Paul Drake
- » Re: all time worst question I have been ever asked as a DBA- Thomas Roach
- » RE: all time worst question I have been ever asked as a DBA- Aragon, Gabriel (GE, Corporate, consultant)
- » RE: all time worst question I have been ever asked as a DBA- Walker, Jed S
- » RE: all time worst question I have been ever asked as a DBA- Walker, Jed S
- » Re: all time worst question I have been ever asked as a DBA- Guillermo Alan Bort
- » Re: all time worst question I have been ever asked as a DBA- Hans Forbrich
- » Re: all time worst question I have been ever asked as a DBA- Robert Freeman
- » Re: all time worst question I have been ever asked as a DBA- Ram Srinivasan
- » RE: all time worst question I have been ever asked as a DBA- Goulet, Richard
- » RE: all time worst question I have been ever asked as a DBA- Marco Gralike
- » RE: all time worst question I have been ever asked as a DBA- Stephens, Chris
- » Re: all time worst question I have been ever asked as a DBA- S. Anthony Sequeira
- » Re: all time worst question I have been ever asked as a DBA- Kevin Lidh
- » Re: all time worst question I have been ever asked as a DBA- Brian Anderson
- » Re: all time worst question I have been ever asked as a DBA- Nilo Segura
- » RE: all time worst question I have been ever asked as a DBA- Amaral, Rui
- » RE: all time worst question I have been ever asked as a DBA- Lange, Kevin G
- » Re: all time worst question I have been ever asked as a DBA- Bill Ferguson
- » Re: all time worst question I have been ever asked as a DBA- Kellyn Pot'vin
- » Re: all time worst question I have been ever asked as a DBA - Marco Gralike
- » Re: all time worst question I have been ever asked as a DBA- Ram Srinivasan
- » Re: all time worst question I have been ever asked as a DBA- David Fitzjarrell
- » Re: all time worst question I have been ever asked as a DBA- Guillermo Alan Bort
- » RE: all time worst question I have been ever asked as a DBA- Aragon, Gabriel (GE, Corporate, consultant)
- » Re: all time worst question I have been ever asked as a DBA- Robert Freeman
- » Re: all time worst question I have been ever asked as a DBA- Robert Freeman
- » Re: all time worst question I have been ever asked as a DBA- Adric Norris
- » Re: all time worst question I have been ever asked as a DBA- Robert Freeman
- » Re: all time worst question I have been ever asked as a DBA- Eric Jenkinson
- » Re: all time worst question I have been ever asked as a DBA- Robert Freeman
- » RE: all time worst question I have been ever asked as a DBA- Goulet, Richard
- » Re: all time worst question I have been ever asked as a DBA- Mark Brinsmead
- » Re: all time worst question I have been ever asked as a DBA- Kellyn Pot'Vin
- » RE: all time worst question I have been ever asked as a DBA- Upendra N
- » Re: all time worst question I have been ever asked as a DBA- rjamya
- » RE: all time worst question I have been ever asked as a DBA- Bobak, Mark
- » Re: all time worst question I have been ever asked as a DBA- David Fitzjarrell