From: David Novice <dnovice@cisco.com>
Subject: Re: Renaming a Database
Date: 1997/10/10
Message-ID: <343E8B9E.331D@cisco.com>#1/1
References: <34331621.C992BD90@bway.net> <34399325.ABA6D0D6@bway.net>
Organization: Cisco Systems, Inc.
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server



You can do a
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
then find the trace file in the bdump directory, edit it, so that
the CREATE CONTROLFILE statement looks something like
 
CREATE CONTROLFILE REUSE SET DATABASE "NEWNAME" RESETLOGS NOARCHIVELOG
...
 
Shut the database down normal, back it up.
Modify the init.ora db_name=newname
Run the create controlfile script from the bdump directory
Then, 
ALTER DATABASE RENAME GLOBAL_NAME TO nename.domain;