RE: major blunders
Date: Wed, 7 Oct 2009 16:52:32 +0100
Message-ID: <A4AF649BCC498F47B854200B42DEC1190606D39D_at_MSAS-LDN90P.global.gam.com>
Some of the stupid things I have done in years gone by, only once I might add!
Don't manually NID a 9i DB while it's open and running.
Always fuser a DB file, before you rm it.
Always check the full session info of that process you are about to
"kill session".
Check the SID on that DB before you issue shutdown command. ( Once
killed a 700 user prod DB once and on monthly reporting day just make
sure the effect was complete! )
Check the server hostname before you issue "rm -rf *"
An ex-colleague once rm -rf the test DB at 2am, well he thought is was test...
It was closely followed by lots of frantic calls and a final trip to HR.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of April Sims
Sent: 07 October 2009 16:42
To: oracle-l_at_freelists.org
Subject: major blunders
Compiling a list of major blunders to avoid:
Don't use the number 8 for scripting or ORACLE_SID due to the wild card
character * above it.
Don't use rm *.*
....
Anyone else have some to contribute?
thanks
April Sims
SELECT IOUG Contributing Editor
http://aprilcsims.wordpress.com
OCP 8i, 9i, 10g DBA
Southern Utah University
sims_at_suu.edu
940-484-4276
--
http://www.freelists.org/webpage/oracle-l
Please consider the environment before printing
This message contains confidential information and is intended only for the individual or entity named. If you are not the named addressee you should not disseminate, distribute or copy this email. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. This message is provided for informational purposes and should not be construed as an invitation or offer to buy or sell any securities or related financial instruments. GAM operates in many jurisdictions and is regulated or licensed in those jurisdictions as required. To the extent this email has been sent to you by any GAM company domiciled in the EU, being GAM (U.K.) Limited, GAM Sterling Management Limited, GAM International Management Limited, GAM London Limited, GAM Fund Management Limited, or GAM Fonds Marketing GmbH i.L., please note the following details in respect of each such company: - GAM (U.K.) Limited (a company limited by shares and registered in England and Wales with company number 01664573); - GAM Sterling Management Limited (a company limited by shares and registered in England and Wales with company number 01750352); - GAM International Management Limited (a company limited by shares and registered in England and Wales with company number 01802911); - GAM London Limited (a company limited by shares and registered in England and Wales with company number with Company Number 00874802) Each of Registered Office: 12 St. James's Place, London, SW1A 1NX GAM Sterling Management Limited, GAM International Management Limited and GAM London Limited are each authorised and regulated by the Financial Services Authority. GAM Fund Management Limited (a company limited by shares and registered in Ireland with no. 156828) of Registered Office: George's Court 54-62 Townsend Street Dublin 2, Ireland GAM Fonds Marketing GmbH, i.L. (a company limited by shares and registered in Germany under No. HRB 66857) of Friedrichstrasse 154, D-10117 Berlin, Germany. The competent Commercial Register is "Amtsgericht Charlottenburg" in Berlin. Liquidator: Daniel Durrer.
--
http://www.freelists.org/webpage/oracle-l Received on Wed Oct 07 2009 - 10:52:32 CDT