1Z0-052 · Question #229
You have a listener process, L1, currently listening for the connections to the PROD and ADMIN databases. You create a new database, PAY, using CREATE DATABASE .. command. You have not enabled…
The correct answer is F. RELOAD L1. LSNRCTL RELOAD L1 re-reads the listener.ora configuration file and applies the new static entry for PAY to the named listener process without stopping it, preserving active connections.
Question
You have a listener process, L1, currently listening for the connections to the PROD and ADMIN databases. You create a new database, PAY, using CREATE DATABASE .. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process. Which command of Listener control utility (LSNRCTL) would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications?
Options
- ASTART
- BRELOAD
- CRESTART
- DREFRESH
- ESTART L1
- FRELOAD L1
- GRESTART L1
- HREFRESH L1
How the community answered
(26 responses)- A4% (1)
- C12% (3)
- F81% (21)
- G4% (1)
Why each option
LSNRCTL RELOAD L1 re-reads the listener.ora configuration file and applies the new static entry for PAY to the named listener process without stopping it, preserving active connections.
START is used to launch a listener that is currently not running, not to apply configuration file changes to an already running listener process.
RELOAD without a listener name targets the default listener named LISTENER, not the named L1 process, so the PAY entry would not be loaded for L1.
RESTART stops the listener and then starts it again, which would temporarily drop all existing connections to the PROD and ADMIN databases.
REFRESH is not a valid LSNRCTL command for re-reading and applying changes from listener.ora.
START L1 would only start the L1 listener if it were stopped; it cannot reload a new configuration into an already running process.
The RELOAD command instructs the listener control utility to re-read listener.ora and incorporate any newly added static service entries without stopping the listener process. Specifying L1 targets the named listener rather than the default listener, ensuring the PAY database entry is loaded into the correct process. Because the listener is never stopped, all existing connections to PROD and ADMIN remain completely unaffected.
RESTART L1 stops and restarts the L1 listener, which breaks all active connections to PROD and ADMIN during the restart cycle.
REFRESH L1 is not a recognized LSNRCTL sub-command for applying listener.ora changes to a running listener.
Concept tested: LSNRCTL RELOAD command for named listener reconfiguration
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/netag/enabling-oracle-net-services.html
Topics
Community Discussion
No community discussion yet for this question.