Re: How to change the SID

cschang wrote:

> I have a 9.2.0.5 databse set up locally. I wan to change the SID so my
> weblogic 8.1.4 can talk to it. Sorry I can not change Weblogic side to
> match Oracle side. When I look into the solutions (most of them are for
> 8i and before), most of them mention to change alter the controlfile so
> that they can be called by new SID. But how? the .ctl file under 9.2
> are binary coded and can not be read. Follwoing steps were I did before
> I stuck.
>
> C:\>sqplus 'sys/<password>@local as sysdba'
> SQL>create pfile='%path%\pfile<oldSID>.ora' from
> spfile='%path%\spfile<oldSID>.ora';
>
> file created
> SQL>shutdown immediate
>
> Then i used the notepad to open the pfile<oldSID>.ora and change all the
> <oldSID> to <newSID> inside the file and save as a pfile<newSID>.ora in
> the a new oracle\admin\newSID\ and also rename the
> d:\oracle\oradata\oldSID\ to d:\oracle\oradata\newSID\ where all the DBF
> and CTL are located.
>
> SQL>startup pfile=d:\oracle\admin\newSID\pfile<newSID>.ora
>
> SQL>....
> ...
> error : unable to open the file
> error: control file can not be located or something like such.
>
> I can understood why error, because the new pfile includes a new CTL
> which can be found no where. Those new CTl files were supposely
> modified from old ones. But I could not modifed them. Although I have
> tried one with
> SQL>alter database backup controlfile to trace;
>
> As some article suggested. I really have no clue what this did. what it
> related to the new controlfile. Can someone give me some real steps for
> this change on 9i. Thanks.
>
> Chisoon

http://www.psoug.org
click on Morgan's Library
click on NID

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)