Re: How to rename an oracle instance?

From: Mehul Zaveri <mehulzaveri_at_hotmail.com>
Date: Tue, 9 Nov 1999 17:10:05 +0400
Message-ID: <8096ah$saq5@news.emirates.net.ae>

You want to change ORACLE_SID or you want to change db name? db name can be changed by recreating control file (see create controlfile command)

ORACLE_SID can be just changed by renaming initNEWSID.ora and this file must have correct db_name parameter.
After renaming file, just set ORACLE_SID=NEWSID;export ORACLE_SID; and start db.
(db_name must match, what is in controlfile?) Assuming UNIX (NT may not work same way, or will it?)

Keith Kwiatek <kkwiatek_at_nist.gov> wrote in message news:807fq8$nkc$1_at_news.nist.gov...
> Hello,
>
> I installed oracle, named the instance (testdb), and add some tables/data.
> BUT now I want to rename the instance. Do I just rename the init.ora
> parameter? How do I do it?
>
> Thanks,
>
> Keith
>
>
Received on Tue Nov 09 1999 - 07:10:05 CST