Oracle 26ai monitoring CDB and PDB´s with common user

[Eisbaeeer]

Hi
My enviroment:

Database: Oracle 26ai with CDB and PDB´s.
NetXMS: Version 6.0
Subagent: Oracle.nsm
Subagent: dbquery.nsm

Im using common user with prefix c## to monitor the CDB via Oracle.nsm subagent. The prefix working well for CDB.
Now I tried to get data from PDB´s with this subagent. As example open_mode, etc.

• Is it possible to monitoring the PDB´s, too with the Oracle.nsm?

I tried as second solution via dbquery.nsm (I use it for special select statements in oracle and this works with traditional Oracle DB´s (Instance based). Now i tried to get data like open_mode from PDB´s with dbquery.nsm. It seems that the agent does not support the "c##" user prefix. If I use it, the agent service will not start. If I try it on SQLDevelopment Studio it works. Is there a solution to use common accounts to monitor PDB´s?

This is how I tried the connection:

*DBQUERY
Database = id=CDB0;driver=oracle.ddr;server=//hostABC:1521/CDB0;login=c##netxms_agent;Password=mypassword
Query = Open_Mode_PDB1:CDB0:15:select open_mode from v$pdbs where NAME = 'PDB1'

--> This query works on Oracle SQL Develper.

How do you monitor your PDB´s without creating collection data for every PDB?
We using dataguard-manager with switchover and failover capability.

Thank you for any hint´s or suggestions.
Sincerly Lars

[Filipp Sudanov]

Not sure how your config looks for oracle.nsm part, but the dbquery example issue is due to # char - it's treated as comment when configuration file is parsed.

You can enquote the whole value:
Database = "id=CDB0;driver=oracle.ddr;server=//hostABC:1521/CDB0;login=c##netxms_agent;Password=mypassword"

Or it's better to use new configuration format that goes in a section, just make sure login is in quotes:

[DBQUERY/Databases/db1]
driver=pgsql
server=10.0.0.4
login="netxms"
password=netxms1
name=test_db

(https://netxms.org/documentation/adminguide/application-monitoring.html#configuration-example)

[Eisbaeeer]

@filipp-sudanov said in Oracle 26ai monitoring CDB and PDB´s with common user:

You can enquote the whole value:
Database = "id=CDB0;driver=oracle.ddr;server=//hostABC:1521/CDB0;login=c##netxms_agent;Password=mypassword"

Thank you Filipp. This was the missing hint. I tried to enqoute only username. Now it works like a charme. Thank you verry much!