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:
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
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:
Code Select
*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