URGENT - not .world domain name

[farrokhp]

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

[jlakhani]

edit SQLNET.ora and add the followin line:
NAMES.DEFAULT_DOMAIN = world

Your question:

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.

What do you mean by that? you are contradicting your question.

[Calvin_Qiu]

Changing domain name involves the following three files:

init.ora : DB_DOMAIN

sqlnet.ora : DEFAULT_DOMAIN

tnsnames.ora : SERVICE_NAME

[farrokhp]

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.

[Calvin_Qiu]

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.