Oracle Database 12c: Installation and Administration — Question 193

Your database is open and the listener LISTENER is up. You issue the command:

LSNRCTL> RELOAD -
What is the effect of reload on sessions that were originally established by listener?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C because the RELOAD command does not disrupt existing sessions; they continue functioning normally even while the listener updates its configurations. Options A, B, and D suggest disconnection or disruption of sessions, which is not the case with the RELOAD command.