Re: SID change on oracle 8

In article <7kq3rd$meq$1_at_nslave1.tin.it>,   "Claudio Lombardo" <clombardo_at_bsc.it> wrote:
>
> Hi everybody.
> I NEED to change an oracle istance name from D01 to ASS.
> How can I do it?
> Now, all the oracle processes refers to D01 (e.g. oracleD01,
ora_dbw0_D01,
> ora_arch_D01...).
> There is some way to change it?
>
> Please, help me!!!
>
> TY
>
> Claudio
>
> --
> ____________________________________
>
> Claudio Lombardo
> Tel. +39 348 2303092 (RAM 3015)
> mailto:CLombardo_at_bsc.it
>
> ___ ___ ___ BSC GROUP
> | _ ) __|/ __|
> | _ \__ \ (__ Tel. +39 10 545.16.86
> |___/___/\___| Fax. +39 10 541.441
> mailto:bsc_at_BSC.it
>
>

copy init<oldsid>.ora to init<newsid>.ora, and make changes accordingly if you didn't use the @ as sid abbreviation. This also applies to your config<sid>.ora if you have them
issue an alter database backup controlfile to trace in the old database shut the old database.
Make a cold offline backup (in case something goes wrong !) edit the tracefile into a create controlfile statement. Now for Unix
change /etc/oratab or /var/opt/oracle/oratab (solaris) run .oraenv with the new sid
go into svrmgrl and issue connect internal and startup nomount run your create controlfile statement
for NT
run ORADIM<xx> in a DOS box! (Very important, do NOT use the GUI version as that will delete your database) issue ORADIM<xx> -DELETE -SID etc
create a new sid with the same command
start the services, do NOT start the database, with the oradim<xx> command
go into svrmgr<xx> and run connect internal startup nomount and create controlfile in the same way as above for Unix. Good Luck!

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 23 1999 - 07:46:51 CDT