Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Changing dbname of startup database

Re: Changing dbname of startup database

From: David Gustafson <davidgustafson_at_ibm.net>
Date: Sat, 27 Mar 1999 16:23:56 -0700
Message-ID: <36FD688C.5A3DCFC1@ibm.net>


You have two options.

1.) If the "oracle" database is distinct on the server simply change the alias name in tnsnames.ora. By default the alias name is the same as the DB name. 2.) After DB creation clone the database to a new DB name.

Dave...

Peter Gill wrote:

> I want to use the startup database that the Oracle Installation program
> creates, but I need to give it a different name (dbname) (otherwise I get
> problems when I try to create database links to other databases on the
> network which also have the default dbname of 'oracle').
>
> Does anyone know how I can change the dbname either before I install Oracle
> or afterwards? Or is there another way round this problem?
>
> Thanks.
Received on Sat Mar 27 1999 - 17:23:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US