6 Replies Latest reply: Jan 10, 2013 9:11 PM by Hemant K Chitale RSS

    host column in the dba_db_links changing once application connects

    user12194321
      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
          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
            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
            • 4. Re: host column in the dba_db_links changing once application connects
              user12194321
              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
                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
                  hmm.. That's curious. I wouldn't expect Oracle to dynamically update the data dictionary like that.


                  Hemant K Chitale