Checking the Oracle network listener

It can be checked whether the Oracle Network Listener is running for the database instance by using the following command:

LSNRCTL status

The output should be something like this:

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production

Start Date 17-JUN-2020 07:33:22

Uptime 0 days 2 hr. 7 min. 29 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/oracle/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=somehost)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=oracle)(PORT=5500))

(Security=(my_wallet_directory=/u01/app/oracle/admin/imacdb/xdb_wallet))

(Presentation=HTTP)

(Session=RAW))

Services Summary...

Service "IMACDBXDB" has 1 instance(s).

Instance "IMACDB", status READY, has 1 handler(s) for this service...

Service "a843adb67ab12804e053020011ace2a0" has 1 instance(s).

Instance "IMACDB", status READY, has 1 handler(s) for this service...

Service "a844218814da358be053020011acb162" has 1 instance(s).

Instance "IMACDB", status READY, has 1 handler(s) for this service...

Service "ima9" has 1 instance(s).

Instance "IMACDB", status READY, has 1 handler(s) for this service...

Service "imacdb" has 1 instance(s).

Instance "IMACDB", status READY, has 1 handler(s) for this service...

The command completed successfully

At least one service handler must be presented here for the relevant database instance (“ima9” in the example above).