topic Re: Oracle database extension for CDB/PDB in Extensions

Oracle database extension for CDB/PDB

suhanbongo — Mon, 30 Sep 2024 15:20:19 GMT

Hi,

The Oracle database extension page is mention "While the extension supports connecting directly to a Pluggable Database (PDB), our recommended approach is to connect your monitoring configuration to the Container Database (CDB) and allow the extension to discover all PDBs automatically."

So, where or how can I enable this automatic discovery? During the endpoint configuration, I did not see any option for this.

An Oracle-level user was created with all permissions granted according to the documentation, and it can connect to the CDB, but the PDBs are never listed unless I manually add them as new endpoints.

Re: Oracle database extension for CDB/PDB

p_devulapalli — Tue, 01 Oct 2024 01:29:48 GMT

Hi @suhanbongo

In the config, can you please check if you have the multitenancy feature set enabled?

https://docs.dynatrace.com/docs/shortlink/oraclesql-monitoring#multitenancy

Re: Oracle database extension for CDB/PDB

suhanbongo — Tue, 01 Oct 2024 06:47:00 GMT

Hi,

Yes, it does. In fact, all of the available features are enabled

Re: Oracle database extension for CDB/PDB

p_devulapalli — Tue, 01 Oct 2024 21:30:53 GMT

In that case I would review the roles granted to the user account used for monitoring and SELECT permissions on views , specifically the below

The monitoring account may need explicit permission over PDBs. For example, you can use this statement: alter user <your_username> set container_data=all for sys.v_$pdbs container = current;

Re: Oracle database extension for CDB/PDB

suhanbongo — Wed, 02 Oct 2024 09:40:36 GMT

This is also configured and confirmed by the Oracle administrators.

Re: Oracle database extension for CDB/PDB

TomásSeroteRoos — Thu, 03 Oct 2024 09:18:10 GMT

Hi @suhanbongo,

We are working on updating the permission documentation as we realize they are not very clear at the moment. As a workaround for now, could you run

alter user <your_username> set container_data=all container = current;

and see if that works? So similar to the command @p_devulapalli provided above, but without the specific view name

After running the alter statement, you can also try running the following query from the CDB when logged in as the monitoring user

SELECT CONT.NAME, CAST(CONT.OPEN_TIME AS DATE) AS OPEN_TIME_CASTED, CONT.OPEN_MODE, CONT.RESTRICTED, INST.INSTANCE_NAME, CDB.CDB_NAME FROM GV$CONTAINERS CONT JOIN GV$INSTANCE INST ON INST.INST_ID = CONT.INST_ID CROSS JOIN (SELECT sys_context('USERENV', 'CDB_NAME') as CDB_NAME FROM DUAL) CDB

This is the query we use to detect PDBs, so if it returns all the PDBs, auto-detection should work.

Re: Oracle database extension for CDB/PDB

suhanbongo — Thu, 03 Oct 2024 13:25:58 GMT

Thank you, that solved the issue

Re: Oracle database extension for CDB/PDB

Peter_Youssef — Sat, 05 Oct 2024 18:24:53 GMT

Hello @suhanbongo

First of all you should share the official Oracle DB Monitoring requirements through extension with Oracle team.
Ensure communication is conducted properly between the AGs and Oracle DBs on Port 1521 or the custom port by the customer.
Ensure the below commands are properly configured on all Oracle instances to fetch PDBs automatically after configuring CDBs

SELECT
                CONT.NAME,
                CAST(CONT.OPEN_TIME AS DATE) AS OPEN_TIME_CASTED,
                CONT.OPEN_MODE,
                CONT.RESTRICTED,
                INST.INSTANCE_NAME,
                CDB.CDB_NAME
            FROM
                GV$CONTAINERS CONT
                JOIN GV$INSTANCE INST ON INST.INST_ID = CONT.INST_ID
                CROSS JOIN (SELECT sys_context('USERENV', 'CDB_NAME') as CDB_NAME FROM DUAL) CDB

alter user <username> set container_data=all for sys.gv_$containers container=current;
alter user <username> set container_data=all container = current;
alter user <your_username> set container_data=all for sys.v_$pdbs container = current;

It's tested way of automatically fetching the PDBs after manual configurations of CDBs.

You can save it for future Oracle DB monitoring cases.

KR,

Peter.

Re: Oracle database extension for CDB/PDB

anne_platts — Thu, 19 Jun 2025 06:33:16 GMT

Hi Peter,

I have checked and rechecked the permissions for the dynatrace DB user account and can connect to the PDB's but getting a WARNING Polling finished with issues for endpoints: DBHOSTNAME:1521/SERVICE. The extension has visibility of the CDB but I can onty see PDB's when I configure each individually

Re: Oracle database extension for CDB/PDB

TomásSeroteRoos — Thu, 19 Jun 2025 07:03:22 GMT

Hi Anne,

If you are sure that you ran

alter user <your_username> set container_data=all container = current;

for the monitoring user you have configured, double check that when you run the query that Peter mentions above you see all the PDBs (you should run it as the user you configured in Dynatrace, using the same connection details as the ones configured in Dynatrace). As mentioned, this is the query the extension runs to discover the PDBs.

If this shows all PDBs but you don't see them in Dynatrace, please open a support ticket and we'll help you out 🙂

Re: Oracle database extension for CDB/PDB

siegi_mueller — Tue, 24 Mar 2026 08:08:37 GMT

Unfortunatly it still did not make it into the documentation...

Re: Oracle database extension for CDB/PDB

TomásSeroteRoos — Tue, 24 Mar 2026 08:16:01 GMT

Hi @siegi_mueller,

Did you have a look at this documentation page? At the end of the requirements section, we explicit the specific permissions that are needed for PDB auto-discovery.

Kind regards,
Tomás