The .world suffix is the default domain name
for Oracle Net connections. As of Net8, the default domain name was changed to be a NULL string.
NOTE
Using SID_LIST_LISTENER is not required in Oracle Database 10g
and 11g; it is required in previous versions of Oracle Net only if you
monitor and manage the instance with Oracle Enterprise Manager.
The second portion of the listing, beginning with the SID_LIST_LISTENER clause, identifies the
global database name as defined in the init.ora file for that database, the Oracle software home
directory for each instance the listener is servicing, and the instance name or SID. The GLOBAL_
DBNAME comprises the database name and database domain. The SID_LIST descriptor is retained
for static database registration, for backward compatibility with earlier versions, and for use by
the Oracle Enterprise Manager. Databases dynamically register with the listener on database
startup; a default installation of Oracle Database 11g (and Oracle Database 10g) on Linux only
includes a listener.ora file with the LISTENER parameter, as in this sample listener.ora file from the
DW database used in examples throughout this book:
# listener.ora Network Configuration File:
/u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dw)(PORT = 1521))
)
)
For the listener on the server dw (for the database instance DW), this listener.
Pages:
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779