crazyblood
Jul 3 2008, 12:57 PM
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
SteveC
Jul 3 2008, 03:38 PM
crazyblood
Jul 3 2008, 03:58 PM
QUOTE (SteveC @ Jul 3 2008, 08:39 PM)

so what should I do to change the global_name to instance name.
Because of this long global name link name appears like:
CREATE PUBLIC DATABASE LINK ASNET
CONNECT TO ASNET
IDENTIFIED BY <pwd>
USING 'RAC1';
ASNET.REGRESS.RDBMS.DEV.US.ORACLE.COM
HAL9000
Jul 3 2008, 04:44 PM
crazyblood
Jul 4 2008, 09:13 AM
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