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 !