If the Listener is shutdown while the database is still running, what is the state of existing connection
-
The Connections also get closed along with listener.
-
The Connections close as and when the open transaction completes
-
The Existing connections are left untouched as the listener only initiates the connections
-
None of the Above
When the Oracle listener is shut down, existing database connections remain unaffected because the listener's role is ONLY to initiate new connections - it doesn't maintain or manage existing connections. Once a connection is established, communication occurs directly between the client and the database instance. The connections won't close immediately, won't close when transactions complete, and will continue operating normally. Only new connection attempts will fail until the listener is restarted.
To answer this question, we need to understand the relationship between the Listener and the database connections.
The Listener is responsible for accepting incoming client connections and establishing a connection between the client and the database server. Once the connection is established, the Listener's role is complete, and it does not actively manage or control the existing connections.
Given the scenario where the Listener is shut down while the database is still running, the existing connections will be left untouched. This means that the connections between the client and the database server will remain open and active, even though the Listener is no longer available.
Therefore, the correct answer is:
C. The existing connections are left untouched as the Listener only initiates the connections.