cdh
cd network
cd admin
cat listener.ora
vi listener.ora
LISTENER_1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mmm111.example.com)(PORT = 1621)(QUEUESIZE=256))
)
SID_LIST_LISTENER_1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl.example.com)
(SID_NAME = orcl)
(ORACLE_HOME = /u01/app/oracle/product/19.0.0/dbhome_1)
)
)
lsnrctl start listener_1
lsnrctl status listener_1
sqlplus test/test@mmm111:1621/orcl.example.com