Re: Global Database name

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Tue, 20 Jul 1999 19:30:52 +0200
Message-ID: <932491831.19986.0.pluto.d4ee154e@news.demon.nl>

Hi Sam,
You don't specify whether you are changing the domain only or changing = both the db_name and the domain
The answer to your question 1 is: yes, you can, and no, it will be = insufficient.
When you change the database name you need to recreate the control file. Issue alter database backup controlfile to trace in svrmgr30, edit the = trace file to change the database name and make it a proper script and = run it.
You also need to change the global database name as that is stored in = the control file also.
Issue an
alter database set global_name = ...
Assuming you don't change the service name (which IMO you should) you = may want to look in listener.ora and tnsnames.ora for any references to = global_dbname =

Hth,

Sybrand Bakker, Oracle DBA

  <sam.petitto_at_netsec.net> wrote in message = news:3794AD78.52209203_at_netsec.net...
  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 = Received on Tue Jul 20 1999 - 12:30:52 CDT