Add a DIAGNOSTIC user to Enterprise Manager for performance insights and query tuning only

When you want a user, probably a developer, to have access via Enterprise Manager to show query performance, but *ONLY* to specific databases and it’s performance stats, you need a ‘restricted’ EM and database user to do this. Next is tested on EM 13.3 and an 18c container database.

Short list of things that need to be done:

  1. Create a new Enterprise Manager Role with performance monitor privileges for specific targets
  2. Create new Enterprise Manager Administrators and add them to the previously create role
  3. Create a new common user in the target databases for monitoring within the target databases
  4. Create a new Enterprise Manager Named Credential for these targets

So that’s a short list, now the (written) instructions per step: Continue reading

Agent Configuration Assistant does not add targets

Today the Agent Configuration Assistant (Agent on 64bit Windows Server 2003, Grid Control on 32bit Windows XP) failed in running the last optional step. It hang for a long time, too long (a hour or so). After canceling this last step, checking the [configToolFailedCommands] showed the [oracle.sysman.emcp.agent.AgentPlugIn] was messing up the set-up.

Continue reading