Re: How to set a global database name?

There is nothing wrong, I came across this situation sometimes ago with Oracle 7.3.2.3.2 on OpenVMS 7.1, I think the initial global_name was set to the value of db_name.db_domain when the database was created ie. values of db_name and db_domain in init.ora file. Subsequent change of db_domain within init.ora would not be reflected in global_name. The command 'Alter database set global_name = ...' would modify value of global_name, please check syntax of command.

In article <01bd5c94$10001d00$1ec7608c_at_hilbert.mirl.itri.org.tw>, "Hilbert" <850593_at_mirl.itri.org.tw> says:
>
>
>
>According to Oracle's documentation, a database's global database name is
>comprised of two parts:
>a name component (DB_NAME) and a network domain component (DB_DOMAIN).
>
>For example, if DB_NAME = sales and DB_DOMAIN = mirl.com.tw,
>the global database name is sales.mirl.com.tw.
>
>I have set the DB_NAME and DB_DOMAIN to the above values in parameter file.
>But the results retrieved by "select * from global_name;" is sales.world.
>(world is the default value of DB_DOMAIN)
>
>Is there any thing wrong? How to change the DB_DOMAIN of a database?
>(I am running Oracle 7.3.3 on NT.)
>
>Thanks !
>
>
>
>
>
>
>
>
>
>
Received on Tue Mar 31 1998 - 00:00:00 CST