SV: Re[2]: Shooting yourself in the spfile

From: Jesper Haure Norrevang <jhn.aida_at_cbs.dk>
Date: Thu, 19 Feb 2004 13:19:38 +0100
Message-id: <000001c3f6e2$a4deea20$4a28e282@AIDA.local>

Hi Jonathan,

The instance does not need to be running in order to do a CREATE PFILE = FROM
SPFILE. I just tested it on version 9.2.0.

Regards
Jesper Norrevang

-----Oprindelig meddelelse-----

Fra: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org] P=E5 vegne af Jonathan Gennick
Sendt: 19. februar 2004 02:21
Til: Alexander.Feinstein_at_mitchell1.com
Emne: Re[2]: Shooting yourself in the spfile

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=3D'/tmp/pfile' from spfile=3D'?/dbs/spfileSID.ora'
3. SQL>> host vi /tmp/pfile
4. SQL>> create spfile=3D'?/dbs/spfileSID.ora' from pfile=3D'/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=20 email. To join, visit
http://four.pairlist.net/mailman/listinfo/oracle-article,=20 or send email to Oracle-article-request_at_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_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 Thu Feb 19 2004 - 06:19:38 CST