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.
Since the version of database is not mentioned, we can only consider option C as it's correct for versions before 12c. Rest all options are incorrect. "In releases before Oracle Database 12c, PMON performed the listener registration."
The listener forwards client requests to supported services. 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.
Agree with Havok:
Listener Registration Process (LREG)
The listener registration process (LREG) registers information about the database instance and dispatcher processes with the Oracle Net Listener.
When an instance starts, LREG polls the listener to determine whether it is running. If the listener is running, then LREG passes it relevant parameters. If it is not running, then LREG periodically attempts to contact it.
Note:
In releases before Oracle Database 12c, PMON performed the listener registration.
The Answer is 100% D guys...
Havok is correct on why C is WRONG.
Reference below will confirm LREG handles that proces.
It also confirms why D is correct.
https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292
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.
Not D.
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
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.
D is wrong because you don’t have to configure a listening protocol address(es) in istener.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.
upvoted 3 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Havok
Highly Voted 4 years, 10 months agosherifelia
Highly Voted 5 years agoluizyto
Most Recent 1 year, 11 months agoRay520
2 years, 7 months agoRay520
2 years, 7 months agofridaytar
3 years, 10 months agoTuxBingo
4 years, 4 months agojoe_doe
4 years, 5 months agoWinterschill
4 years, 6 months agohggz
4 years, 8 months agokhan
5 years, 8 months agohggz
4 years, 8 months ago