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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s