altering DB Domain
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: altering DB Domain

  1. #1
    Join Date
    May 2002
    Posts
    11
    Hello,

    im trying to alter the db domain of my database. Oracle automatically set it to us.oracle.com, so that my database is called dwora.us.oracle.com!
    I now want that is ony is dwora!
    How can i manage this problem? Do i have to change any parameters? I cant find any settings where us.oracle.com is listed!

    Thanks

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    The values you will need to change are:

    SERVICE_NAME and DB_DOMAIN and can be changed in the init.ora.

    You may also need to modify your listener and tnsnames setup.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    May 2002
    Posts
    11

    the problem i have with the domain of my databaseis as followed:
    My database is called dwora2 and i want to connect to another database called dwora. after i created a database link (create database link dwora connect to...) oracle says the link is called dwora.us.oracle.com
    The same thing happens when i look at the global name of dwora2 (it is then dwora2.us.oracle.com)
    as you may see my problem is that oracle adds the "us.oracle.com"?
    When i look at the init.ora my domain parameter is db_domain = ""
    In the sqlnet.ora there are no such parameters?

    Does anyone know how to change this behavior?

    Thanks

    [Edited by Daflow on 06-10-2002 at 11:45 AM]

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