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

Home -> Community -> Usenet -> c.d.o.server -> Re: SID Change on Oracle 9.2 with spfile

Re: SID Change on Oracle 9.2 with spfile

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 16 Nov 2005 10:17:54 -0800
Message-ID: <1132165074.055202.315390@o13g2000cwo.googlegroups.com> 





Before you shutdown your db make an init.ora from the spfile.  Then
start the renamed instance using the new correctly named init.ora and
then create an spfile from the init.ora



See CREATE PFILE and CREATE SPFILE in SQL manual for syntax.



HTH -- Mark D Powell --
Received on Wed Nov 16 2005 - 12:17:54 CST












Original text of this message













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