Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • proc.sql Oracle
  • checking connectivity between two servers Linux/Unix
  • v$event_name Oracle
  • pvm_pre_change.sql Oracle
  • Rman Notes -1 Oracle
  • True Session Wait Activity in Oracle 10g Verygood Oracle
  • to see when crontab is changed. Linux/Unix
  • DBMS_UTILITY PACKAGE Oracle
  • secure crt settings Linux/Unix
  • RAC with RHEL4 and 11g Oracle
  • proper cpu stats Linux/Unix
  • SQL Tracker by SID sqltrackerbysid.sql Oracle
  • Finding last recovered file on DR and remove all chanracters before any “/” Linux/Unix
  • ORA-8031 issue and solution if it is occuring due to truncate. Oracle
  • CPU speed on Linux Linux/Unix

Renaming Global Name GLOBAL_NAME

Posted on 06-Sep-2006 By Admin No Comments on Renaming Global Name GLOBAL_NAME

Problem:

——–

I cannot create a db_link on my database that does not have the fuly qualified domain.name.

eg. if I create a db_link called fred as follows:

create database link fred connect to ITU604SP4B identified by using ‘sup9206_hippo’

a link called fred.intec.co.za is created, I just want fred.

I have set global_names= FALSE

db_domain=””

select * from global_name returns hippo.intec.co.za

btw this used to work fine when global name was just hippo.

I was experimenting and changed this to hippo.intec.co.za using alter database rename global_name to hippo.intec.co.za

I have tried changing back using

alter database rename global_name to “hippo” but the global name will not change back to just hippo.

This should not make a difference if global_names is set to false according to everything I have read.

Where does the domain name get stored – remeber I have set db_domain=””

Solution:

———

update global_name set global_name = ‘SUP9206’;

restart db and voila, everything working.

Oracle, SQL scripts

Post navigation

Previous Post: Kernel Parameter setting explaination for Processes Parameter
Next Post: ipcs -l

Related Posts

  • Library cahe Latches and internal explaination Oracle
  • Identical Dblink Issue… Oracle
  • Restoring a user’s original password 1051962.101 Oracle
  • compile_inv.sql Oracle
  • Good links for x$ tables in oracle. Oracle
  • Oracle Data Direct to TAPE Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • The most important Tuning Notes Oracle
  • crtgr.sql /* For creating trigger from data dictionary */ Oracle
  • Oracle Material from OTN Oracle
  • get_ratio.sql get the ratio of users from v$session and this uses CASE-WHEN-THEN clause Oracle
  • Find long Running Transaction Linux/Unix
  • purge_trc.sh Linux/Unix
  • CPU speed on solaris Linux/Unix
  • Virtual Indexes in Oracle Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme