In the listener.ora file, we can define the value of GLOBAL_DBNAME in SID_DESC section. for example:
(GLOBAL_DBNAME = orachh)
(ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/db_1)
(SID_NAME = orachh)
The purpose of the “GLOBAL_DBNAME” in the listener.ora file is to make your listener to get register with instance.Am i correct?
Instance (PMON) registers the services with the listener... a listener never registers with the instance... and the global_dbname is the service name... i believe if you have a db_domain init parameter configured then it should be appended to this global_dbname (service_name) as well..
The listener doesn't register with the database. It is the database (PMON) that registers with the listener under Dynamic Registration. The database instance provides it's SERVICE_NAME to the listener.
Your listing is of Static Registration. According to Table 9-1 here : file:///C:/Oracle_11gR2_Documentation/E11882_01/network.112/e10836/listenercfg.htm#g508094
GLOBAL_DBNAME is the Service Name that is mapped if the client does not provide an SID in the connect-string.
Hemant K Chitale