RE: Re[2]: Shooting yourself in the spfile
- From: Alexander.Feinstein@xxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 18 Feb 2004 17:37:03 -0800
Jonathan,
You do not need any connection, nor any instance. Just SQL*Plus.
Alex.
-----Original Message-----
From: Jonathan Gennick [mailto:jonathan@xxxxxxxxxxx]
Sent: Wednesday, February 18, 2004 5:21 PM
To: Alexander.Feinstein@xxxxxxxxxxxxx
Subject: Re[2]: Shooting yourself in the spfile
Wednesday, February 18, 2004, 8:00:29 PM, Alexander.Feinstein@xxxxxxxxxxxxx
(Alexander.Feinstein@xxxxxxxxxxxxx) 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
