Well, heck, I 'm sure there 's a lot more things that I should be ashamed of myself for not knowing than there is for you! :)
Actually, I 'm surprised I remembered this since I first learnt about it when I was running the 9i New Features for Administrators training when that came out. I thought all the brain cells I had that were that old died off under the influence of drunken Oak Table meetings (or is that a tautology?) :)
Pete
"Controlling developers is like herding cats. "
Kevin Loney, Oracle DBA Handbook
"Oh no, it 's not. It 's much harder than that! "
Bruce Pihlamae, long-term Oracle DBA
-- --Original Message-- --
From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] On Behalf Of Jonathan Gennick
Sent: Thursday, 19 February 2004 12:47 PM
To: Mladen Gogala
Subject: Re[4]: Shooting yourself in the spfile
Wednesday, February 18, 2004, 8:37:03 PM, Mladen Gogala (mgogala@(protected)) wrote:
MG > Jonathan, you should be ashamed of yourself! I thought you know
MG > by now always to keep a usable version of parameter file on the
MG > system
Well, if you go back to my original note, you 'll find that I
*did* have a current init.ora file to fall back on. After I
screwed up my spfile, I restarted the instance using my
init.ora file.
What I 'm ashamed of is not knowing that I could have issued
a CREATE PFILE command with my instance sitting idle. That
important fact has somehow eluded me until now.
Best regards,
Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:jonathan@(protected)
Join the Oracle-article list and receive one
article on Oracle technologies per month by
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article,
or send email to Oracle-article-request@(protected) and
include the word "subscribe " in either the subject or body.
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
