Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How to make SPFILE in sync with INIT.ORA ?

How to make SPFILE in sync with INIT.ORA ?

From: Prem Khanna J <jprem_at_kssnet.co.jp>
Date: Tue, 15 Jul 2003 11:03:35 +0900
Message-Id: <25920.337704@fatcity.com> 





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,
Received on Mon Jul 14 2003 - 21:03:35 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US