dB link appending
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: dB link appending

  1. #1
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    (Oracle 9i, Solaris)

    When I run: CREATE PUBLIC DATABASE LINK "testdb" using 'testdb';

    And then run select * from dba_db_links

    OWNER Link_name
    PUBLIC TESTDB.COM

    Why does it put the .com on the end??

    GLOBAL_NAMES=FALSE
    DB_DOMAIN=WORLD
    The link works!
    I had to put TESTDB.COM in my server TNS!

    What else could cause this?
    Don't blame me, I'm from Red Sox Nation.

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Could you post your sqlnet.ora file?

    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    I don't have a
    /oracle/product/9.0.1/network/admin/sqlnet.ora file
    or a sqlnet.ora on my client.

    I turned global_names = true and explicitely created the links with

    CREATE PUBLIC DATABASE LINK "testdb.world" using 'testdb';

    when I run select * from v$database@testdb.world and I get:

    ORA-02085 database link TESTDB.COM connect to TESTDB.COM



  4. #4
    Join Date
    Nov 2001
    Posts
    335

    Check your global name by running :
    SELECT * FROM GLOBAL_NAME;
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  5. #5
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    SQL> SELECT * FROM GLOBAL_NAME;

    TESTDB.COM

    SQL> alter database rename global_name to TESTDB.WORLD;

    SQL> SELECT * FROM GLOBAL_NAME;

    TESTDB.WORLD


    The lesson here is that changing the supposedly DYNAMIC GLOBAL_NAME is bull. You must issue the "alter database" command.


    Thanks people!

    Don't blame me, I'm from Red Sox Nation.

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