Your database is open and the listener LISTNENER is up. You issue the command:
What is the effect of reload on sessions that were originally established by listener?
Only sessions based on static listener registrations are disconnected.
Existing connections are not disconnected; however, they cannot perform any operations until the listenercompletes the re-registration of the database instance and service handlers.
The sessions are not affected and continue to function normally.
All the sessions are terminated and active transactions are rolled back.