Re[2]: Shooting yourself in the spfile

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Wed, 18 Feb 2004 20:44:43 -0500
Message-ID: <1447139002.20040218204443@gennick.com>

Wednesday, February 18, 2004, 8:27:34 PM, Adam Donahue (adonahue_at_opsware.com) wrote: AD> Are you sure about that?

I thought I was sure, but it turns out I didn't test carefully enough. Shame on me.

AD> I just tested this on a couple local instances, and was
AD> able to create both a pfile from spfile, and spfile from
AD> pfile, on an idle instance.

Sure enough. I was wrong. It can be done:

SQL> connect system/sql8plus4 as sysdba; Connected to an idle instance.
SQL> create pfile='c:\a\init.ora' from spfile='c:\oracle\ora10\database\SPFILEOR CL.ORA'
  2 ;

File created.

Knowing this, it now seems possible to recover from a screwup without having to bother making backups each time I change a parameter.

Life is good again.

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 email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to Oracle-article-request_at_gennick.com 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_at_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

---

Received on Wed Feb 18 2004 - 19:44:43 CST