OEM Reports are showing old data for tablespaces
After dropping tablespaces in RAC, the tablespace reports still showed that these tablespaces existed.
So the steps I ran were:
1. Run in the OEM repository as sysman the following (to get the host, target name and type):
select * from mgmt$db_tablespaces where tablespace_name like ‘%tablespace_I_deleted%’;
2. What came back was the database instance that showed this tablespaces (devracdw2) which listed ’02’ as the agent owner, and the cluster database (devracdw) which listed ’03’ as the agent owner.
3. Logged into the agent home on 02 and ran:
emctl control agent runCollection devracdw.cssd.pitt.edu_devracdw2:oracle_database oracle_dbconfig
4. Logged into the agent home on 03 and ran:
emctl control agent runCollection devracdw.cssd.pitt.edu:rac_database oracle_racconfig
NOTE: Because I wasn’t sure which collection I wanted to execute, this command shows all of the jobs that this agent runs collection on:
emctl status agent scheduler
Comments are currently closed.