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?
A. START
B. RELOAD
C. RESTART
D. REFRESH
E. START L1
F. RELOAD L1
G. RESTART L1
H. REFRESH L1
Answer: F
Purpose
To reread the listener.ora
file. This command enables you to add or change statically configured services without actually stopping the listener.
In addition, the database services, instances, service handlers, and listening endpoints that were dynamically registered with the listener are unregistered and subsequently registered again.
Syntax
From the operating system:
lsnrctl RELOAD listener_name
From the Listener Control utility:
LSNRCTL> RELOAD listener_name
listener_name: The listener name, if the default name of LISTENER
is not used.