Listeners
Each database server on the network must contain a listener.ora file. The listener.ora file lists the
names and addresses of all the listener processes on the machine and the instances they support.
Listener processes receive connections from Oracle Net clients.
A listener.ora file has four parts:
Header section
Protocol address list
Instance definitions
Operational parameters
The listener.ora file is automatically generated by the Oracle Net Configuration Assistant tool
(netca on Linux). You can edit the resultant file as long as you follow its syntax rules. The following
listing shows sample sections of a listener.ora file??”an address definition and an instance definition:
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL=IPC)
(KEY= loc.world)
)
(ADDRESS=
?–
?–
?–
?–
518 Oracle Database 11g DBA Handbook
(PROTOCOL=TCP)
(HOST= HR)
(PORT=1521)
)
)
SID_LIST_LISTENER =
(SID_DESC =
(GLOBAL_DBNAME = loc.world)
(ORACLE_HOME = D:\oracle\ora11)
(SID_NAME = loc)
)
)
The first portion of this listing contains the protocol address list??”one entry per instance. The
protocol address list defines the protocol addresses on which a listener is accepting connections,
including an interprocess calls (IPC) address-definition section. In this case, the listener is listening
for connections to the service identified as loc.world as well as any requests coming from the HR
machine on PORT 1521 using the TCP/IP protocol.
Pages:
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778