You executed the following command in the lsnrctl utility to stop the listener: lsnrctl> STOP L1 What is the effect of this command if L1 is the only listener configured for your database?

Stopping the listener has no effect on existing user sessions; it only affects the ability to create new connections.

The Oracle listener acts as the network gateway that accepts and hands off new remote connection requests to the database server process. Once the listener is stopped, no new remote connections can be established because there is no process listening on the designated port. However, existing sessions were already handed off by the listener and maintain their own direct connection to the server process, so they continue working normally.

The listener does not control server-side transaction processing; stopping it does not halt the server or wait for transactions to complete.

The database server itself does not hang when the listener is stopped; currently connected users experience no interruption and no error.

The 'End of communication channel' error applies to existing connections that are abruptly dropped, not to sessions that remain intact after the listener is stopped.