Re: Shooting yourself in the spfile

From: Adam Donahue <adonahue_at_opsware.com>
Date: Wed, 18 Feb 2004 17:27:34 -0800
Message-ID: <40341106.2040503@opsware.com>

Are you sure about that? I just tested this on a couple local instances, and was able to create both a pfile from spfile, and spfile from pfile, on an idle instance.

Adam

Jonathan Gennick wrote:

>Wednesday, February 18, 2004, 8:00:29 PM, Alexander.Feinstein_at_mitchell1.com (Alexander.Feinstein_at_mitchell1.com) wrote:
>AFmc> With spfile one can use followin steps:
>AFmc> 1. sqlplus /nolog
>2. SQL>> create pfile='/tmp/pfile' from spfile='?/dbs/spfileSID.ora'
>3. SQL>> host vi /tmp/pfile
>4. SQL>> create spfile='?/dbs/spfileSID.ora' from pfile='/tmp/pfile'
>5. SQL>> host rm /tmp/pfile
>6. SQL>> startup
>
>In my case, I couldn't start my instance at all, so I
>wouldn't have been able to issue the create pfile command in
>step 2.
>
>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
>-----------------------------------------------------------------
>
>

---

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:27:34 CST