But, of course!
In RAC environment 'strings' is the one to go with.
We don't RAC, so either one works for me !!
Cheers!
- Kirti
- Mladen Gogala <mgogala_at_adelphia.net> wrote:
> Kirti, that's what "strings" command is for.
> strings spfile>/tmp/init.ora and you're good to
> go.
>
> On 02/18/2004 09:39:51 PM, Kirtikumar Deshpande wrote:
> > 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
> > -----------------------------------------------------------------
> >
>
> --
> Mladen Gogala
> Oracle DBA
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
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 - 21:11:36 CST