changing DB_DOMAIN

Dear Experts,

I created a database by giving some value for DB_DOMAIN.

Now I want to remove the value in the DB_DOMAIN. I updated my init.ora file.  Now, if i make a query from v$parameter, the value for db_domain is null.  

But if i do the query as sys, (select database_name from dual), it displays the database name with the domain name i given previously.  Also whenever i create a database link, the link name automatically suffix the domain name.

How to remove the domain name permanently???

LVL 1
deva_kumarAsked:
Who is Participating?
 
urimConnect With a Mentor Commented:
10x.
0
 
urimCommented:
connect to sys and do the following command:

alter database rename global_name to '<dbname>';

It should remove the domain from your global name
0
 
deva_kumarAuthor Commented:
Hi urim,

It is correct. send that as a answer so that i can give the points to you. (you made it as a comment).

Deva
0
 
deva_kumarAuthor Commented:
THANK U
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.