This discussion is archived
6 Replies Latest reply: Jan 10, 2013 7:11 PM by Hemant K Chitale RSS

host column in the dba_db_links changing once application connects

user12194321 Newbie
Currently Being Moderated
Hi,

The host(net service name used to connect to the remote database) in the dba_db_links is changing to pindb.corp.youtele.com

after database link creatoin the host is -> pindb

once application connects is it changing to -> pindb.corp.youtele.com

please can anybody shed some light on this
  • 1. Re: host column in the dba_db_links changing once application connects
    sb92075 Guru
    Currently Being Moderated
    user12194321 wrote:
    Hi,

    The host(net service name used to connect to the remote database) in the dba_db_links is changing to pindb.corp.youtele.com

    after database link creatoin the host is -> pindb

    once application connects is it changing to -> pindb.corp.youtele.com

    please can anybody shed some light on this
    The batteries in my flash light are dead.

    I do not understand the problem.

    How do I ask a question on the forums?
    SQL and PL/SQL FAQ
  • 2. Re: host column in the dba_db_links changing once application connects
    user12194321 Newbie
    Currently Being Moderated
    HI,
    we created the private db link as below
    
    CREATE DATABASE LINK "PINDB_LINK" CONNECT TO PIN IDENTIFIED by PIN USING 'PINDB';
    
    select db_link,host, created from dba_db_links;
    
    DB_LINK                                         HOST                                               CREATED
    ---------------------------------------- -------------------------------------------------- ---------
    PINDB_LINK                                     PINDB                                             11-JAN-13
    
    but once the application connects the database the host column is changing in dba_db_links
    
    select db_link,host, created from dba_db_links;
    
    DB_LINK                                         HOST                                               CREATED
    ---------------------------------------- -------------------------------------------------- ---------
    PINDB_LINK                                     pindb.corp.youtele.com                             11-JAN-13
    
    as host is changing users are facing the issue 
    
    in sqlnet.ora file we have commneted 
    
    #NAMES.DEFAULT_DOMAIN = corp.youtele.com and show parameter db_domain shows 
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    db_domain                            string
    
    please can you help on this why it is changing and how we can troubleshoot
  • 3. Re: host column in the dba_db_links changing once application connects
    sb92075 Guru
    Currently Being Moderated
    SELECT * FROM V$VERSION;
  • 4. Re: host column in the dba_db_links changing once application connects
    user12194321 Newbie
    Currently Being Moderated
    HI,

    BANNER
    --------------------------------------------------------------------------------
    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    PL/SQL Release 11.2.0.3.0 - Production
    CORE 11.2.0.3.0 Production
    TNS for Linux: Version 11.2.0.3.0 - Production
    NLSRTL Version 11.2.0.3.0 - Production


    Thanks
  • 5. Re: host column in the dba_db_links changing once application connects
    sb92075 Guru
    Currently Being Moderated
    Thanks for all the feedback.

    It appears to me that Oracle places into the HOST column the name of the DB_LINK when the link is created.
    After first use of the DB_LINK it then has learned the actual hostname where the remote DB resides & populates the column with the new data
  • 6. Re: host column in the dba_db_links changing once application connects
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    hmm.. That's curious. I wouldn't expect Oracle to dynamically update the data dictionary like that.


    Hemant K Chitale

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points