Re: Global Database name

sam.petitto_at_netsec.net wrote:
>
> During install of 8i on NT I have to specify the Global database name
> as "name.domain". I have to load the box in a lab with a totally
> different domain name than the customer will have on the site where
> the box is being deployed. Can I change the name of the Global
> database name once it is set by modifying the init.ora file ? If so,
> would it need to be changed anywhere else when deploying ? I couldn't
> find a straight yes or no in the documentation
>
> TIA
>
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> Sam Petitto
> Database Engineer
> Network Security Technologies Inc.
> (877)799.9380 Toll Free
> (703)561.0420 Local
> (703)561.0426 Fax
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> This electronic message contains information from Network Security
> Technologies, Inc or its affiliates, which may be confidential,
> proprietary or otherwise protected from disclosure. The information
> is
> intended to be used solely by the recipient(s) named above for the
> purposes intended by the originator. If you are not an intended
> recipient, be aware that any review, disclosure, copying, distribution
>
> or use of this transmission or its contents is prohibited. If you
> have
> received this transmission in error, please notify us immediately by
> telephone at (703) 561-0420, or by electronic mail at sales_at_netsec.net
>
>

To get the global name of the database : SELECT * FROM global_name;
To change the global name of the DB :
ALTER DATABASE RENAME GLOBAL_NAME TO 'new_dbname.new_dbdomain';

The db_domain parameter in the init.ora doesn't matter.

Change also tnsnames.ora and listener.ora Received on Tue Jul 20 1999 - 12:36:23 CDT