Re: How to make SPFILE in sync with INIT.ORA ?

From: Kirtikumar Deshpande <kirtikumar_deshpande_at_yahoo.com>
Date: Mon, 14 Jul 2003 19:22:19 -0700 (PDT)
Message-Id: <25920.337706@fatcity.com>

make spfile from pfile;

something like that.....

I would suggest just deleting it altogether. :)

• Kirti
  • Prem Khanna J <jprem_at_kssnet.co.jp> wrote:
    > Guys,
    >
    > i have a 9iR2/win2k test instance.
    > i just renamed CONTROL01.CTL once and tried to start the instance.
    >
    > SQL>startup
    > But it gave a ORA-00205 error.
    >
    > so i removed CONTROL01.CTL from INIT.ORA file and started the instance
    > SQL>startup pfile='d:\oracle\admin\pe92\pfile\init.ora'
    > Now it worked fine.
    >
    > BUT:
    > SQL>startup
    > This is not possible because the SPFILE still has CONTROL01.CTL in it.
    >
    > How do i make my SPFILE in sync with the INIT.ORA ?
    >
    > Regards,
    > Jp.
    >
    >
    >
    > --
    > Please see the official ORACLE-L FAQ: http://www.orafaq.net
    > --
    > Author: Prem Khanna J
    > INET: jprem_at_kssnet.co.jp
    >
    > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    > San Diego, California -- Mailing list and web hosting services
    > ---------------------------------------------------------------------
    > To REMOVE yourself from this mailing list, send an E-Mail message
    > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    > the message BODY, include a line containing: UNSUB ORACLE-L
    > (or the name of mailing list you want to be removed from). You may
    > also send the HELP command for other information (like subscribing).
    

    ---

Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month! Received on Mon Jul 14 2003 - 21:22:19 CDT