Your database is open and the listener LISTNENER is up. You issue the command:
LSNRCTL> RELOAD
What is the effect of reload on sessions that were originally established by listener?
A.
Only sessions based on static listener registrations are disconnected.
B.
Existing connections are not disconnected; however, they cannot perform any operations until
the listener completes the re-registration of the database instance and service handlers.
C.
The sessions are not affected and continue to function normally.
D.
All the sessions are terminated and active transactions are rolled back.
Explanation:
C
C
Once a client is connected to the database (ie the server-side process is forked or is using a shared server process), the listener isn’t required any further. You could even shutdown the listener (preventing new connections) without affecting existing connections.
it should be C
Maybe D
Configuring Dynamic Service Registration
Service registration allows processes, such as an Oracle database, to identify their available services to the listener, which then acts as a port mapper for those services. The listener uses the dynamic service information about the database and instance received through service registration.
Dynamic service registration is configured in the database initialization file. It does not require any configuration in the listener.ora file. However, listener configuration must be set to listen on the ports named in the database initialization file, and must not have parameters set that prevent automatic registration, such as COST parameters.
This section contains the following configuration topics related to service registration:
Why B? I think C is correct
C is correct as RELOAD only read the listner.ora file and won’t affect existing connections
In addition, the database services, instances, service handlers, and listening endpoints that were dynamically registered with the listener will be unregistered and subsequently registered again.
I think B is correct but the Reload not take to much time so look like no affected and continue to function normally
C
C, listener only delivery the session to database after that isn’t listener’s responsability
C
Even STOP would NOT affect any established sessions.