Printable View
Hi Guys,
Can you tell me how can I reset the Oracle domain name to .world.
I create a new database in a new server. Somehow the domain attach to service name needs to be .ourcomapnyname.com . When in Database creation domain name attach to database and how can I make it again default as .world.
Thanks
edit SQLNET.ora and add the followin line:
NAMES.DEFAULT_DOMAIN = world
Your question:What do you mean by that? you are contradicting your question.Quote:
Somehow the domain attach to service name needs to be .ourcomapnyname.com . When in Database creation domain name attach to database and how can I make it again default as .world.
Changing domain name involves the following three files:
init.ora : DB_DOMAIN
sqlnet.ora : DEFAULT_DOMAIN
tnsnames.ora : SERVICE_NAME
Ok My question is : I didn't put domain_name = xyz.com in my init.ora but if default_domain_name in sqlnet.ora = .world then if I don't put xyz.com at the end of my service name in tsnname then it can not connect.
Do you think if I put DOMAIN_NAME = WORLD in init.ora then it will be WORLD ???
I know I am a little confuse, but please help.
That is true. Just try it on your database.
Again, the SERVICE_NAME of connect string should be same to SERVICE_NAME parameter of the instance.