Configure Oracle Database Static Listener

Follow below steps to configure static Oracle Database listener.

Currently, I do not have any listener configured on my setup and “lsnrctl status” is not showing any result.

[grid@ib-auto-sco-asm154 ~]$ lsnrctl status

LSNRCTL for Linux: Version 12.2.0.1.0 – Production on 29-AUG-2018 20:03:33

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ib-auto-sco-asm154)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 – Production
Start Date 29-AUG-2018 20:03:24
Uptime 0 days 0 hr. 0 min. 8 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /ora01/app/12.2.0.1/grid/network/admin/listener.ora
Listener Log File /ora01/app/grid/diag/tnslsnr/ib-auto-sco-asm154/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ib-auto-sco-asm154)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary…
The listener supports no services
The command completed successfully

  • Listener.ora file output

[grid@ib-auto-sco-asm154 ~]$ cat /ora01/app/12.2.0.1/grid/network/admin/listener.ora
#Backup file is /ora01/app/12.2.0.1/grid/srvm/admin/listener.ora.bak.ib-auto-sco-asm154 line added by Agent
# listener.ora Network Configuration File: /ora01/app/12.2.0.1/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ib-auto-sco-asm154)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER=SUBNET # line added by Agent

  • Add below entries in listner.ora file.

SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=asm154)                                                         # asm154 is database name
(SID_NAME=asm154)                                                                       # asm154 is database SID
(ORACLE_HOME=/ora01/app/oracle/product/12.1.0/db_1)        #ORACLE_HOME path
)
)

SECURE_REGISTER_LISTENER = (IPC)

  • Listener.ora file output after adding entries

[grid@ib-auto-sco-asm154 ~]$ cat /ora01/app/12.2.0.1/grid/network/admin/listener.ora
#Backup file is /ora01/app/12.2.0.1/grid/srvm/admin/listener.ora.bak.ib-auto-sco-asm154 line added by Agent
# listener.ora Network Configuration File: /ora01/app/12.2.0.1/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ib-auto-sco-asm154)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER=SUBNET # line added by Agent
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=asm154)
(SID_NAME=asm154)
(ORACLE_HOME=/ora01/app/oracle/product/12.1.0/db_1)
)
)

SECURE_REGISTER_LISTENER = (IPC)

  • Now, reload the listener. You can also run “lsnrctl reload”

[grid@ib-auto-sco-asm154 ~]$ lsnrctl stop

LSNRCTL for Linux: Version 12.2.0.1.0 – Production on 29-AUG-2018 20:04:10

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ib-auto-sco-asm154.gdl.englab.netapp.com)(PORT=1521)))
The command completed successfully
[grid@ib-auto-sco-asm154 ~]$ lsnrctl start

LSNRCTL for Linux: Version 12.2.0.1.0 – Production on 29-AUG-2018 20:04:13

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

Starting /ora01/app/12.2.0.1/grid/bin/tnslsnr: please wait…

TNSLSNR for Linux: Version 12.2.0.1.0 – Production
System parameter file is /ora01/app/12.2.0.1/grid/network/admin/listener.ora
Log messages written to /ora01/app/grid/diag/tnslsnr/ib-auto-sco-asm154/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ib-auto-sco-asm154)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ib-auto-sco-asm154)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 – Production
Start Date 29-AUG-2018 20:04:13
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /ora01/app/12.2.0.1/grid/network/admin/listener.ora
Listener Log File /ora01/app/grid/diag/tnslsnr/ib-auto-sco-asm154/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ib-auto-sco-asm154)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary…
Service “asm154” has 1 instance(s).
Instance “asm154”, status UNKNOWN, has 1 handler(s) for this service…
The command completed successfully

You should see listener entries with UNKNOWN status. In case, you do not see UNKNOWN status then please verify listener.ora entries.

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