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
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)
Quote from: Filipp Sudanov on February 19, 2026, 01:46:57 PMYou 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!