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.