Oracle Listener Problem : The listener supports no services - lsnrctl status

Question

Hi,



I have installed the Oracle Database 12.1.0 on one my linux box.



When I do a lsnrctl status, I get the following output:



LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 19-MAR-2019 09:42:20





Copyright (c) 1991, 2016, Oracle.  All rights reserved.





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

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production

Start Date                19-MAR-2019 08:02:58

Uptime                    0 days 1 hr. 39 min. 21 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /home/oracle/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora

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

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=X.X.X.X)(PORT=1521)))

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

The listener supports no services

The command completed successfully



When I try to connect to this database, I get error saying 'The Network Adapter Could Not establish the connection'

Answer

set local_listener parameter

$ su - oracle 
SQL> show parameter local_listener
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      

SQL> alter system set local_listener='(ADDRESS =(PROTOCOL=TCP)(HOST=devbase.lambda.asia)(PORT=1539))' scope=both;
SQL> --change the value in red
SQL> -- your problem will be solved