Re[2]: Shooting yourself in the spfile
- From: Jonathan Gennick <jonathan@xxxxxxxxxxx>
- To: "Alexander.Feinstein@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 18 Feb 2004 20:21:22 -0500
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
http://Gennick.com * 906.387.1698 * mailto:jonathan@xxxxxxxxxxx
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@xxxxxxxxxxx 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@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:
