what happens if the listener currently running for prod database is terminated due to some reason?
The currently connected users will be disconnected.
There will be no effect on users.
remote users will not be allowed to spawn sessions.
None of the above