CompTIA DataSys+ (DS0-001)Database DeploymentEasy
A database administrator is installing a new Oracle database server. After the installation, the administrator needs to verify that the Oracle Listener service is running correctly and accepting connections. Which command should the administrator use to check the status of the Listener?
- Alsnrctl status
- Bps -ef | grep ora_pmon
- Csqlplus / as sysdba
- Dsrvctl status database -d ORCL
Show answer & explanationAnswer & explanation
Correct answer: A. lsnrctl status
`lsnrctl status` is the dedicated Oracle utility to check the status of the Listener service, including its running state, configured services, and accepted connections.
Why the other options are wrong
- B. `ps -ef | grep ora_pmon` checks for the PMON background process of an Oracle instance, not the Listener process.
- C. `sqlplus / as sysdba` connects to the database instance, not the Listener service itself.
- D. `srvctl status database` is used in Oracle Real Application Clusters (RAC) environments to check the status of a database, not the Listener.
Oracle Listener
A background process on an Oracle database server that listens for incoming client connection requests and manages traffic to the database instance.
- Uses the `lsnrctl` utility for management.
- Must be running for remote clients to connect.
- Configured via `listener.ora` file.
Memory trick: Listener Control (lsnrctl) lets you hear the database.