Register Database services in Listener (Oracle 19c)

This tutorial explains the steps to register a static database services within the listener for many purpose, like the need to start Oracle database remotely with the user SYS, and also for Oracle Data Guard DGMGRL purpose also.

  • Step 1: run the tool netmgr
  • Step 2: Create two database services with two methods
  • Step 3: Check the Listener status

Step 1: run the tool netmgr

NETMGR: Network Manager tool, to manage the listener process

$ netmgr

Step 2: (Mothed N°1) We are going to create a database service name within the Listener:

Add Database service for Broker configuration:

Step 2: (Mothed N°2) We are going to create a database service name within the Lsitener:

Using the configuration File, add database service creation manually.

$ vi/u01/app/oracle/product/19c/dbhome_1/network/admin/listener.ora
listener.ora Network Configuration File: /u01/app/oracle/product/19c/dbhome_1/network/admin/listener.ora
Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = XXXdb)
(ORACLE_HOME = /u01/app/oracle/product/19c/dbhome_1)
(SID_NAME = XXXdb)
)
(SID_DESC =
(GLOBAL_DBNAME = XXXdb_DGMGRL)
(ORACLE_HOME = /u01/app/oracle/product/19c/dbhome_1)
(SID_NAME = XXXdb)
)
)

Note: Reload the listener service

$ lsnrctl reload

Step 3: Check the status of the Listener

$ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 14-JULY-2022 13:13:41
Copyright (c) 1991, 2022, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=obrdb1)(PORT=1521)))
STATUS of the LISTENER
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 14-JULY-2022 13:09:25
Uptime 0 days 0 hr. 4 min. 15 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/19c/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/obrdb1/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XXXdb1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary…
Service "XXXdb" has 1 instance(s).
Instance "XXXdb", status UNKNOWN, has 1 handler(s) for this service…
Service "XXXdb_DGMGRL" has 1 instance(s).
Instance "XXXdb", status UNKNOWN, has 1 handler(s) for this service…
The command completed successfully

Enjoy !

Bookmark the permalink.
Loading Facebook Comments ...

Leave a Reply