February, 2014
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 […]