3 Replies Latest reply: Feb 27, 2013 12:35 PM by TSharma-Oracle RSS

    what's the value of GLOBAL_DBNAME in the listener.ora ?

    Lonion
      SQL> select * from v$version;
      
      BANNER
      --------------------------------------------------------------------------------
      Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
      PL/SQL Release 11.2.0.1.0 - Production
      CORE    11.2.0.1.0      Production
      TNS for Linux: Version 11.2.0.1.0 - Production
      NLSRTL Version 11.2.0.1.0 - Production
      
      SQL> 
      SQL> 
      SQL> show parameter db_name
      
      NAME                         TYPE      VALUE
      ------------------------------------ ----------- ------------------------------
      db_name                      string    Oracle11
      SQL> show parameter service_names
      
      NAME                         TYPE      VALUE
      ------------------------------------ ----------- ------------------------------
      service_names                        string      primary
      SQL> 
      SQL> 
      SQL> ho
      [oracle@primary admin]$ 
      [oracle@primary admin]$ cat listener.ora
      # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
      # Generated by Oracle configuration tools.
      
      SID_LIST_LISTENER =
        (SID_LIST =
          (SID_DESC =
            (GLOBAL_DBNAME = primary)                        ================> Note Here , i asked this parameter .
            (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
            (SID_NAME = primary)
          )
        )
      
      LISTENER =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.178)(PORT = 1525))
        )
      
      ADR_BASE_LISTENER = /u01/app/oracle
      
      [oracle@primary admin]$ 
      [oracle@primary admin]$ 
      [oracle@primary admin]$ exit
      exit
      
      SQL> 
      in my option , i think the value of GLOBAL_DBNAME equal to the value of DB_NAME . But it's wrong , the remote client can't connect the database .
      when its value equal to the value of SERVICE_NAMES , the remote client can connect the database .

      what's the value of GLOBAL_DBNAME in the listener.ora ?