Re: Using Global Names

Both the database name and the domain are stored in the control file. You are looking at results from the controlfile. The domain in the controlfile is derived from - db_domain in init.ora
otherwise from
- sqlnet.ora
otherwise it will default to world
You can change the global_name of a database by alter database rename global name to <new name>
To change the database name you need to recreate the controlfile.

Hth,

--
Sybrand Bakker, Oracle DBA
Barry Jones <jonesb_at_logica.com> wrote in message news:01bf5839$37e66750$6346ea9e_at_ukp01758...
> Hi,
>
> I've got two databases eg ex1 and ex2, both with db_name parameter set in
> their corresponding config files.
> db_name = ex1
> However when I query global_name in both, one returns
> ex1.world, the other, test.world
>
> I have tried adding the parameter db_domain to both and after bouncing the
> db, no change is seen in global_name table.
>
> What other parameters affect / control global database naming, or what
> could be preventing ex2 from getting the intended global db name ?
>
> Both the dbs currently have global_names set to false , but switching to
> true still results in ex2 showing as test.world in global_name table
>
> Thanks for any advice
>
> Barry Jones
Received on Thu Jan 06 2000 - 06:07:59 CST