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.
All the sessions are terminated and active transactions are rolled back.
C.
The sessions are not affected and continue to function normally.
D.
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.
The answer would be D
Answer C for me. What will happen with existing connections when the listener stops ? Nothing I hope.
Listener is only used for the creation of the session. Therefore lsnrctl reload does not affect already connected users (as well as a listener restart).
Answer: C