CONFIGURE LISTENER FOR ORACLE DATABASE USING NETMGR
Locate to oracle home into network/admin directory
[oracle@orcldg bin]$ pwd
/oracle/base/product/12.1.0/dbhome_1/bin
[oracle@orcldg bin]$ ./netmgr
Open netmgr
Choose listener and click plus symbol at top left
Specify listener name
Choose listener locations and specify host and port
Choose database services from drop down on top center and specify the details of database
Global database name should be the database name
Oracle home directory should be current database home
SID should be oracle sid of current database for which the listener is configured
Click close button on top right corner and click on save
If the listener is not started on the database, then start the listener!
[oracle@orcldg bin]$ lsnrctl start listener1
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 19-JUN-2021 00:05:23
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Starting /oracle/base/product/12.1.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 12.1.0.2.0 - Production
System parameter file is /oracle/base/product/12.1.0/dbhome_1/network/admin/listener.ora
Log messages written to /oracle/base/diag/tnslsnr/orcldg/listener1/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.212)(PORT=1526)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.212)(PORT=1526)))
STATUS of the LISTENER
------------------------
Alias listener1
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 19-JUN-2021 00:05:23
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/base/product/12.1.0/dbhome_1/network/admin/listener.ora
Listener Log File /oracle/base/diag/tnslsnr/orcldg/listener1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.212)(PORT=1526)))
Services Summary...
Service "orcldgp" has 1 instance(s).
Instance "orcldgp", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully