URGENT - not .world domain name
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: URGENT - not .world domain name

  1. #1
    Join Date
    Nov 2000
    Posts
    416

    URGENT - not .world domain name

    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
    An ounce of prevention is worth a pound of cure

  2. #2
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    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.
    "High Salaries = Happiness = Project Success."

  3. #3
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    Changing domain name involves the following three files:

    init.ora : DB_DOMAIN

    sqlnet.ora : DEFAULT_DOMAIN

    tnsnames.ora : SERVICE_NAME
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  4. #4
    Join Date
    Nov 2000
    Posts
    416
    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.
    An ounce of prevention is worth a pound of cure

  5. #5
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    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.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width