Help - Search - Members - Calendar
Full Version: changing global_name
Oracle DBA Forums > Oracle > Oracle Forum
crazyblood
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
You just renamed it to what was already being used.
http://download.oracle.com/docs/cd/B19306_...in.htm#i1007592
crazyblood
QUOTE (SteveC @ Jul 3 2008, 08:39 PM) *
You just renamed it to what was already being used.
http://download.oracle.com/docs/cd/B19306_...in.htm#i1007592



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
This clown is a forum spammer:

http://www.dbforums.com/showthread.php?p=6347537
crazyblood
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
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.