Shooting yourself in the spfile 2004-02-18 - By Kirtikumar Deshpande
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@(protected) > 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@(protected) > wrote:
> > > Wednesday, February 18, 2004, 8:27:34 PM, Adam Donahue (adonahue@(protected)) 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@(protected)
> > >
> >
> > __ ____ ____ ____ ____ ____ ______
> > 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@(protected)
> > 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@(protected)
> 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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
