| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re[2]: Shooting yourself in the spfile
Well, that's the whole point isn't it? You don't NEED to have the =
instance running to be able to issue either the create pfile or create =
spfile commands.
=20
Pete
=20
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
=20
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jonathan Gennick
Sent: Thursday, 19 February 2004 12: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=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.
 |
 |