Shooting yourself in the spfile 2004-02-18 - By Mladen Gogala
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
