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.
Definitely not C!
In Oracle 12c, the LREG (Listener REGistration) process will register services with the listener.
So, which is the correct answer??
As far as I’m concerned, all the answers are wrong for Oracle 12c!
A is wrong because you can make local connections without going through a listener.
B is wrong because many databases can register with a listener.
C would be right for versions prior to 12c. But for 12c, it’s wrong!
D is wrong because you don’t have to configure a listening protocol address(es) in listener.ora. If not specified, it will simply default to TCP port 1521.
E is wrong because Oracle will also look in $TNS_ADMIN directory or /etc.
Shawn,
I agree with you all of the are wrong.
I go with C presuming its a question from Key DBA Skills section.
In exam it shows LREG instead of PMON, so answer is C
yes, exam shows LREG, so it’s C
will go with C
C
Answer is C.
But option C is a little bit different:
C. Service registration with the listener is performed by the listener registration process monitor (LREG) process of each database instance.
Reference:
http://docs.oracle.com/database/121/NETAG/listenercfg.htm
Hi all,
anyone would have the “dump” of this test and could give me a link on how to use it ? I must go on it in 2 days and I discovered only yesterday evening this site…
C
C
I think Correct answer is D.
If the SECURE_REGISTER_listener_name parameter is configured with the list of transport names, only the connections arriving on the specified transports will be able to register the service with the listener. The connections arriving by other transport protocols are refused. For example:
SECURE_REGISTER_listener1 = (TCPS, IPC)
In the preceding example, registration requests are accepted only on TCPS and IPC transports.
If no values are entered for this parameter, the listener accepts registration requests from any transport.
Refer to below regd D: Dynamic service registration does not require any manual configuration in the listener.ora file.
http://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292
The answer is C: The exam answer have changed from PMON to LREG
E
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
The word MUST is the only problem with the E answer
xander said the exam answer have changed which means C is the correct answer
always a big fan of linking to bloggers that I enjoy but dont get a great deal of link appreciate from
that would be the end of this report. Here youll locate some web-sites that we think youll appreciate, just click the links over
Here is a good Weblog You may Find Fascinating that we Encourage You
we came across a cool web-site which you could take pleasure in. Take a appear when you want
Every when inside a while we decide on blogs that we read. Listed below would be the newest web-sites that we choose