This discussion is archived
3 Replies Latest reply: Feb 27, 2013 10:35 AM by TSharma-Oracle RSS

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

Lonion Newbie
Currently Being Moderated
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 ?

Legend

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