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

Thread: DBLINK name

  1. 10-17-2005, 10:30 AM #1
    KenEwald's Avatar
    KenEwald
    KenEwald is offline Senior Advisor
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204

    DBLINK name

    When I create a database link, it adds ".REGRESS.RDBMS.DEV.US.ORACLE.COM" to the name.

    How can I correct this?

    I'm thinking it's a globalization init.ora parameter, maybe?

    10.2.0.1
    SuSE 8
    Reply With Quote Reply With Quote
  2. 10-17-2005, 05:59 PM #2
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    db_domain?
    Reply With Quote Reply With Quote
  3. 10-17-2005, 06:23 PM #3
    KenEwald's Avatar
    KenEwald
    KenEwald is offline Senior Advisor
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    I think we've got it sorta figured out.

    .REGRESS.RDBMS.DEV.US.ORACLE.COM is the default global_name property of a new 10.2 database. Not to be confused with the global_names database parameter. I believe these two are used together to enforce unique database names across your domain.

    In prior versions the default was "US.ORACLE.COM". Database links work with or without it set.

    queried:
    select * from global_name

    changed:
    alter database rename global_name to ..
    ex. MYDB.GALLUP.COM
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width