Services Summary…Service “86b637b62fdf7a65e053f706e80a27ca” has 1 instance(s). Don’t freak out!

Those who install and create a database running in the Oracle release 12.2.0.3 launched by Oracle Corporation in February 2019 might get surprised about the unknown hash services shown in the listener due to the PDB databases. I must say that my first thought was, “What?????”. Write in the comments how was yours. My first information is: don’t freak out! This service was introduced by the Oracle Database release 12cR2 due to the possibility of creating a PDB as a Proxy PDB. Thus, what you can see of new in the listener of your database from the 12.2.0.1.0 release is shown as below:

Current Listener is LISTENER_TECH
LSNRCTL>status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tech-data-db.localdomain)(PORT=1527)))
>STATUS of the LISTENER
Alias                     LISTENER_TECH
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                13-APR-2021 10:48:14
Uptime                    0 days 0 hr. 3 min. 31 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/tech-data-db/listener_oem/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tech-data-db.localdomain)(PORT=1538)))
Services Summary…
Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).
Instance "techcdbdb", status READY, has 1 handler(s) for this service…
Service "bfc5748905fde7dfe0535a71430a60df" has 1 instance(s).
Instance "techcdbdb", status READY, has 1 handler(s) for this service…
Service "techcdbdb" has 1 instance(s).
Instance "techcdbdb", status READY, has 1 handler(s) for this service…
Service "techcdbdbXDB" has 1 instance(s).
Instance "techcdbdb", status READY, has 1 handler(s) for this service…
Service "emrep" has 1 instance(s).
Instance "techcdbdb", status READY, has 1 handler(s) for this service…
The command completed successfully
LSNRCTL> exit

To get to know more about the process of creating a PDB as a Proxy PDB I would suggest you either read the chapter “10 Creating a PDB as a Proxy PDB” of the Administrator’s Guide release 18 or see the post about this topic written by ACED Frank Pachot .

References:

Service “696c6f76656d756c746974656e616e74” has 1 instance(s).

Release 18 -> Administrator’s Guide -> 10 Creating a PDB as a Proxy PDB

Related posts

Leave a Comment