Current Position:Home > Changing GLOBAL_NAME in 11g RAC

Changing GLOBAL_NAME in 11g RAC

Update:10-11Source: network consolidation
Advertisement
Hi, All -
I am running a two node RAC 11g (11.1.0.7) database on RHEL5. I need to change the GLOBAL_NAME.
SQL> select * from global_name;
GLOBAL_NAME
dbname
SQL> ALTER DATABASE RENAME GLOBAL_NAME TO dbname.companyname.com
I just want to confirm that I only have to run this on one node and fix the db links.
Are there any other steps involved since it is a RAC environment?
Thanks in advance!

The Best Answer

Advertisement
check this
http://asanga-pradeep.blogspot.com/2010/08/changing-global-name-and-domain-name-in.html
http://download.oracle.com/docs/cd/B19306_01/server.102/b14228/best_gen.htm#CHDHCGJJ
  • Changing GLOBAL_NAME in 11g RAC Update:10-11

    Hi, All - I am running a two node RAC 11g (11.1.0.7) database on RHEL5. I need to change the GLOBAL_NAME. SQL> select * from global_name; GLOBAL_NAME dbname SQL> ALTER DATABASE RENAME GLOBAL_NAME TO dbname.companyname.com I just want to confirm that

  • Oracle 11g RAC on RHEL 4.0, error on 1 Node while running ./root.sh for CRS Update:10-11

    Hi, I am trying to install Oracle 11g RAC on RHEL 4.0 on Vmware and at the end of CRS installation when installer asks to run the two scripts (orainstRoot.sh and root.sh) on one node (on the node where runInstaller is started) throws following error

  • Anybody using 11g RAC Database with OIM 9.1.0.2? Update:10-11

    Hi, We have poor performance problems with 11g RAC Database with OIM 9.1.0.2. It looks like the issue could be because of RAC Ccluster. Anybody using 11g RAC Database with OIM 9.1.0.2? If so, What is the JDBC Driver r u using? Also what App Server (W

  • How to create listener in 11g RAC on windows 2008 server Update:10-11

    Dear All, i worked on win 2003 and linux 4, 5 too. i have installed oracle RAC on both windows and linux. now i have installed oracle RAC11gR1 on windows 2008 server.than installed oracle software . now i want to create listener from db_home which i

  • Upgrade Oracle 10g RAC - Oracle 11g RAC on Linux Environment Update:11-30

    We are planning to Upgrade our databases to Oracle 10g RAC - Oracle 11g RAC which is Linux Environment. Kindly suggest me the best option for migration. Our production database size is 80GB. - Frest installation of oracle 11g using export/iimport dum

  • Oracle EBusiness DBA and Architect Available - Expert in 10g and 11g RAC Update:11-30

    I have implemented Ebusiness on all OS's - upgraded every OS - mixed environment, Linux migrations - CUrrently just wrapped up an 11.5.10CU2 - 10g - to R12CU4 11g RAC upgrade Call me for help - available - [email protected]Hi, First of all, you bette

  • Upgrade oracle 9i RAC to Oracle 11g RAC Update:11-30

    Hi all, db version:oracle 9.2.0.5 RAC OS:Linux My project team and client is planning to upgrade oracle 9i RAC to Oracle 11g RAC. please suggest any MOS notes any links. thanks, Visu. Edited by: visu996253 on Apr 8, 2013 5:30 AMdb version:oracle 9.2.

  • Oracle 11g RAC installation on windows 2008 64 bit Update:11-30

    Hello Everyone, can i get some details regarding Oracle 11g RAC installation on windows 2008, minimum Hardware Requirement Will windows support ASM Can i get a documentation regarding the RAC installation on windows. we were planning to have 11.5 on

  • Which one is best option RAC 10g or oracle 11g RAC for certifiction point ? Update:11-30

    hi , which one is best option RAC 10g or oracle 11g RAC for certifiction point of view? can any one detail difference between above 2 options? Regards, A.AnwarA. Anwar wrote: hi , which one is best option RAC 10g or oracle 11g RAC for certifiction po

  • ORA-04068 on 11g RAC does not resolve automatically ! Update:11-30

    Did you ever get the combination of these three ORAs? ORA-04068: Existing state of package has been discarded ORA-04065: Not executed, altered or dropped stored procedure <PROCEDURE_NAME> ORA-06508: PL/SQL: Could not find program unit being called: