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
>

Why?!?

What mechanism uses WebLogic to talk to Oracle? (If this does not show I'm a no-no on WebLogic....) I would assume some network stack.

Wouldn't it be easier to change the network (tnsnames, or whatever) to make WebLogic *believe* it connects to ORCL, which is actually translated to O920 (or whatever SID you actually use)

Seems an awful lot easier than what Sybrand writes (which actually changes the SID, but at what downtime).

Just my 2 cents

-- 
Regards,
Frank van Bortel