From: "Pete Sharman" <peter.sharman@oracle.com>
To: <oracle-l@freelists.org>
Cc: "PETER_SHARMAN" <PETER.SHARMAN@oracle.com>
Subject: RE: Re[4]: Shooting yourself in the spfile
Date: Thu, 19 Feb 2004 16:19:05 +1100
Message-ID: <001401c3f6a7$e4ba93f0$0301470a@au.oracle.com>
MIME-Version: 1.0
Content-type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
In-Reply-To: <18847303619.20040218204728@gennick.com>
Importance: Normal
Sender: oracle-l-bounce@freelists.org
Errors-To: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: oracle-l@freelists.org

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?)  :)

=20
Pete
=20
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
=20
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA

-----Original Message-----
From: oracle-l-bounce@freelists.org =
[mailto:oracle-l-bounce@freelists.org] 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@adelphia.net) 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@gennick.com

Join the Oracle-article list and receive one
article on Oracle technologies per month by=20
email. To join, visit =
http://four.pairlist.net/mailman/listinfo/oracle-article,=20
or send email to Oracle-article-request@gennick.com and=20
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@freelists.org
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@freelists.org
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
-----------------------------------------------------------------