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 (LREG) 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:
C, but is should be “Listener Registration process” instead of “Process Monitor”
The registration is performed by the Listener Registration (LREG) process.
Dynamic service registration does not require any manual configuration in the listener.ora file.
Awsome info and straight to the point. I don’t know if this is really the best place to ask but do you people have any thoughts on where to hire some professional writers? Thanks in advance 🙂
http://www.bastcilkdoptb.com/
These services are dynamically registered with the listener. This dynamic registration feature is called service registration. The registration is performed by the Listener Registration (LREG) process. Dynamic service registration does not require any manual configuration in the listener.ora file.
In 12c and higher, there is a new background process called ora_lreg_sid-name
In previous releases, PMON always handled instance registration logic. In 12c, LREG (Listener REGistration) now takes over with the instance registration logic.
LREG:
registers instance information with the listener.
is a critical background process for each database instance (if it is killed, Oracle goes down).
does everything PMON used to do and report: service_update, service_register, service_died in the listener.log.
LREG can be traced using the same methods as one would trace PMON:
Enabling an Oracle Net server side sqlnet tracing will invoke a trace for LREG on instance startup.
The old PMON trace command now traces LREG: alter system set events = ‘10257 trace name context forever, level 5’;
Listener registration information can also be dumped into the ora_lreg trace file: alter system set events = ‘immediate trace name listener_registration level 3’;
Answer: D
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myserver.example.com)(PORT = 1521))
)
)
)
Even if you don’t have listener.ora, you will still be able to start listener.So for that matter, there are no mandatory listener.ora parameters.