Re: How to Change Databasename

From: Steve Phelan <stevep_at_toneline.demon.co.uk>
Date: 1997/07/31
Message-ID: <870346836.3064.0.nnrp-8.c2de712e@news.demon.co.uk>#1/1

There are two issues here - the DB_NAME and the database SID. Oracle support have produced a Technical Note that will take you through the process of one, or both. Look on the Oracle Web site or give Oracle Tech Support a call.

Basically, changing the DB_NAME is easy, it just involves editing ini files. Changing the database SID as well involves recreating the database control files.

Steve Phelan.

Erik Oosterling wrote in article <33e03bbd.686041_at_news.xs4all.nl>...

>Hello all,
>
>Is there a way to change the database name used in the INIT.ORA
>
>now it is:
>
>DB_NAME = ORACLE
>
>But i want to use
>
>DB_NAME = TEST or
>DB_NAME = PROD
>
>Okay i know you have to the db a name when you create him but it was
>not job to create them but it is my job to support them.
>
>PLEASE HELP
>
>
>Erik Oosterling
>
>The Netherlands
>
Received on Thu Jul 31 1997 - 00:00:00 CDT