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

From: <Alexander.Feinstein_at_mitchell1.com>
Date: Wed, 18 Feb 2004 17:37:03 -0800
Message-ID: <27C31DE9ADF1D211A7C300E0B1041E23015115A4@discovery.mitchellrepair.com>

Jonathan,
You do not need any connection, nor any instance. Just SQL*Plus. Alex.
-----Original Message-----

From: Jonathan Gennick [mailto:jonathan_at_gennick.com] Sent: Wednesday, February 18, 2004 5:21 PM To: Alexander.Feinstein_at_mitchell1.com
Subject: 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='/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

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:37:03 CST