how to alter the value for global_name
784873Jul 27 2010 — edited Jul 27 2010Hi,
I am trying to change the global_name to sid value (i.e. just "test" alone and dont want ".REGRESS.RDBMS.DEV.US.ORACLE.COM") but i cant do it with 'alter database rename global_name'
Can you pls let me know, what steps i am missing here in changing the global_name value from "TEST.REGRESS.RDBMS.DEV.US.ORACLE.COM" to "TEST"?
SQL> select * from global_name;
GLOBAL_NAME
-------------------------------------------------------
TEST.REGRESS.RDBMS.DEV.US.ORACLE.COM
SQL> alter database rename global_name to TEST;
Database altered.
SQL> select * from global_name;
GLOBAL_NAME
-------------------------------------------------------
TEST.REGRESS.RDBMS.DEV.US.ORACLE.COM
SQL> select * from v$instance;
INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION
--------------- ---------------- ---------------------------------------------------------------- -------------
1 test XXXXXXX 10.2.0.1.0
thanks,
DB