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
Hi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)