On UNIX
grep '^*' spfileSID.ora > initSID.ora
will also get you going...
- Kirti
- Jonathan Gennick <jonathan_at_gennick.com> wrote:
> Wednesday, February 18, 2004, 8:27:34 PM, Adam Donahue (adonahue_at_opsware.com) wrote:
> AD> Are you sure about that?
>
> I thought I was sure, but it turns out I didn't test
> carefully enough. Shame on me.
>
> AD> I just tested this on a couple local instances, and was
> AD> able to create both a pfile from spfile, and spfile from
> AD> pfile, on an idle instance.
>
> Sure enough. I was wrong. It can be done:
>
> SQL> connect system/sql8plus4 as sysdba;
> Connected to an idle instance.
> SQL> create pfile='c:\a\init.ora' from spfile='c:\oracle\ora10\database\SPFILEOR
> CL.ORA'
> 2 ;
>
> File created.
>
> Knowing this, it now seems possible to recover from a
> screwup without having to bother making backups each time I
> change a parameter.
>
> Life is good again.
>
> Best regards,
>
> Jonathan Gennick --- Brighten the corner where you are
> http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com
>
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
http://antispam.yahoo.com/tools
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 - 20:39:51 CST
