Monthly Archives: October 2014

EM12C – Metrics, history and graphics of SQL Server Instance

I recently came across the following problem, the metrics were not saving history and graphs of instances of SQL Server were not being populated.

After opening an SR in ORACLE there could figure out the problem and the same was at OMS repository.

Steps performed:

  1. Connect as SYSDBA to the repository and check the parameter value job_queue_processes.
  2. If the value is 0 we have to change for 1000.
  3. Stop cloud control (OMS) with the command emctl stop oms.
  4. Change the parameter in the database – alter system set job_queue_processes = 1000 scope = both;
  5. Restart data base and start OMS

Done it a few minutes past the metrics are already saving historic and graphics of SQL instances are populated.

It was also resolved the pending status of several data bases.

Em12C_SQL

 

I hope it was useful!!!
Cheers

Optimization WordPress Plugins & Solutions by W3 EDGE