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).