Oracle 10g Listener Configuration File details

To enable external processes to access the Oracle database, you must configure the Oracle network server environment.
Listener. ora/sqlnet. ora and tnsnames. ora are all three files.
Tnsnames. ora: defines one or more network services. net service cams instances.
The address item contains three sub-parameters:
Protocol: default protocol TCP
HOST: IP Address
Port: port. The default value is 1521.
Xe is the database name
Xe =
(Description =
(Address = (Protocol = TCP) (host = localhost) (Port = 1521 ))
(CONNECT_DATA =
(Server = dedicated)
(SERVICE_NAME = Xe) // Database Name
)
)
Listener. ora
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = plsextproc)
(ORACLE_HOME = D:/Oracle/APP/Oracle/product/10.2.0/Server)
(Program = EXTPROC)
)
)
Listener =
(Description_list =
(Description =
(Address = (Protocol = TCP) (host = localhost) (Port = 1521 ))
)
)
Listener: Specifies the starting point of a listener definition. It is actually the name of the current listener being defined. The default name is listener.
Description: describes the location of each listener.
Address_list: contains the address information related to the location where the listener is listening.
Protocol: Specifies the protocol used for the location of the listener.
HOST: name of the computer on which the listener is located
Port: contains the address where the listener is listening.
Sid_list_listener: defines the list of Oracle services for which the listener is configured
Sid_desc: describes each shard El Sid.
Global_dbname: Global Database Name. This item should be consistent with the service_names item in the init. ora file of the current Oracle service.
ORACLE_HOME: Location of the oracle executable program on the server
Sid_name: name of the Oracle SID used for this oracle instance
Sqlnet. ora
Sqlnet. authentication_services = (none)