Which statement is true about Oracle Net Listener?
A.
It acts as the listening endpoint for the Oracle database instance for all local and non-local user
connections.
B.
A single listener can service only one database instance and multiple remote client
connections.
C.
Service registration with the listener is performed by the process monitor (PMON) process of
each database instance.
D.
The listener.ora configuration file must be configured with one or more listening protocol
addresses to allow remote users to connect to a database instance.
E.
The listener.ora configuration file must be located in the ORACLE_HOME/network/admin
directly.
Explanation:
Supported services, that is, the services to which the listener forwards client
requests, can be configured in the listener.ora file or this information can be dynamically registered
with the listener. This dynamic registration feature is called service registration. The registration is
performed by the PMON process—an instance background process—of each database instance
that has the necessary configuration in the database initialization parameter file. Dynamic service
registration does not require any configuration in the listener.ora file.
Incorrect:
Not B: Service registration reduces the need for the SID_LIST_listener_name parameter setting,
which specifies information about the databases served by the listener, in the listener.ora file.
Note:
* Oracle Net Listener is a separate process that runs on the database server computer. It receives
incoming client connection requests and manages the traffic of these requests to the database
server.
* A remote listener is a listener residing on one computer that redirects connections to a database
instance on another computer. Remote listeners are typically used in an Oracle Real Application
Clusters (Oracle RAC) environment. You can configure registration to remote listeners, such as in
the case of Oracle RAC, for dedicated server or shared server environments.
Its no longer PMON for 12c. Refer for: http://docs.oracle.com/database/121/ADMQS/network.htm#ADMQS0411
Dynamic registration of services and databases with the listener is called service registration.
Service registration is performed by the listener registration (LREG) process—an instance background process—of each database instance.
in Exam: (LREG). Correct C
Villian is right. I would say D
Its not PMON in 12c anymore, all answers are wrong
because it seems that this issue is a copy of 11g I would say that the correct answer (in relation to 11g) is the “C”. This is the best choice, but the true is that all answers are wrong in relation to 12c.
E.
http://orabase.org/index.php/1z0-058/1z0-060-prepare/1z0-060-q4/
Overview of Oracle Net Listener Configuration File
* By default, the listener.ora file is located in the ORACLE_HOME/network/admin directory.
See : https://docs.oracle.com/database/121/NETRF/listener.htm#NETRF292
My Answer is E.
@UP
but remember that you can change the default location of listener.ora file using TNS_ADMIN variable.
It could be C if it was LREG.
In new version it’s option C with correction in Qs as LREG instead of PMON.
C
Listener configure file can be in any directory and TNS_ADMIN can be used to specify the directory. And it’s ok to start listner without configuration file because pmon will automatically register service to listener.
C with LREG