[tjay83]

Despite the value of the db_domain is null.I still cannot change global_name.
What should I do?

SQL> SELECT * FROM GLOBAL_NAME;

GLOBAL_NAME
--------------------------------------------------------------------------------
ORATEMP.REGRESS.RDBMS.DEV.US.ORACLE.COM

SQL> ALTER DATABASE RENAME GLOBAL_NAME TO oratemp ;

SQL> SELECT * FROM GLOBAL_NAME;

GLOBAL_NAME
--------------------------------------------------------------------------------
ORATEMP.REGRESS.RDBMS.DEV.US.ORACLE.COM

[anacedent]

GLOBAL_NAME is a "table".
The proper way to change data in a table is via UPDATE

Be warned that changing GLOBAL_NAME will break any previously created DATABASE LINKS.

[LKBrwn_DBA]

Try:

ALTER DATABASE RENAME 
         GLOBAL_NAME TO NEW.GLOBAL.NAME;

[tjay83]

so in my example how can I change global name to
instance name which is oratemp?

[anacedent]

14:09:55 SQL> create table id10t (global_name varchar2(96));

Table created.

14:10:09 SQL>  insert into id10t values('ORATEMP.REGRESS.RDBMS.DEV.US.ORACLE.COM');

1 row created.

14:10:17 SQL> commit;

Commit complete.

14:10:21 SQL> select * from id10t;

GLOBAL_NAME
--------------------------------------------------------------------------------
ORATEMP.REGRESS.RDBMS.DEV.US.ORACLE.COM

14:10:29 SQL> update id10t set global_name = 'oratemp';

1 row updated.

14:11:10 SQL> commit;

Commit complete.

14:11:13 SQL>  select * from id10t;

GLOBAL_NAME
--------------------------------------------------------------------------------
oratemp

[outrider]

Look at
http://download.oracle.com/docs/cd/B...htm#sthref3663

[tjay83]

Originally Posted by anacedent

GLOBAL_NAME is a "table".
The proper way to change data in a table is via UPDATE

Be warned that changing GLOBAL_NAME will break any previously created DATABASE LINKS.

thanks a lot this worked for me:
update global_name set global_name='ORATEMP';

[tjay83]

Originally Posted by anacedent

GLOBAL_NAME is a "table".
The proper way to change data in a table is via UPDATE

Be warned that changing GLOBAL_NAME will break any previously created DATABASE LINKS.

I have one last question.
During the installation of a database, what things should I consider, inorder not to see global_name like below.


SQL> select * from global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------
ATM.REGRESS.RDBMS.DEV.US.ORACLE.COM

[anacedent]

I am not aware of anything which controls GLOBAL_NAME during installation.
You can always issue the UPDATE as first step after OUI completes.