Re: Change SID ?

From: Ron Loxton <rloxton_at_minervatech.com>
Date: Tue, 6 Jul 1999 15:48:09 -0400
Message-ID: <F4155D9F9AA4D111B9990020AFBA52D51878B9@user62.sfi-software.com>

Been a while since I've done this, but here goes:

BACKUP your database. You never know what may happen.

From server manager execute the command:

alter database backup controlfile to trace; This will create a trace file that can be easily modified to run as a SQL script. Edit this file change the SID and save as a SQL scipt. Shutdown the database.
Rename and modify your init<SID>.ora file to reflect the new SID. Rename to control files (just in case you need them back) Startup the database nomount
Run the script and you should be in business. BACKUP your database again.

Vinod <venkatesh.vinod_at_in.bosch.com> wrote in message news:01bec754$586ef6c0$190394ad_at_QCS_02_95W.BSN.BOSCH.INDIA.DE...
> Hello everyone,
>
> I have a database with SID=RB on NT. Is it possible to
> change the SID of the database(which is already present)
> to something else, say BG.
>
> If I have to the same thing above on HP-UNIX 9000, how do I
> do it ?
>
> Any help will be greatly appreciated.
>
> Thanks,
> Vinod.
Received on Tue Jul 06 1999 - 14:48:09 CDT