When Space Manager objects become invalid or several database errors result when connecting, then an oracle upgrade or cloning the database may have invalidated the Space Manager installation and objects.
The objects are no longer pointing to the current database or file system.
Resolution:
You will need to uninstall the previous Space Manager installation, and reinstall again after the oracle upgrade (File - Admin - Reinstall Server).
Make sure there are no old objects left over from previous installations especially if they were installed by several other users. To verify that run the scripts below to bring out any leftovers, and delete those manually:
SELECT 'DROP '||OBJECT_TYPE||' '||OWNER||'.'||OBJECT_NAME||';' FROM
DBA_OBJECTS WHERE object_name like 'QUEST_SPC%';
SELECT 'DROP '||OBJECT_TYPE||' '||OBJECT_NAME||';' FROM DBA_OBJECTS
WHERE object_name like 'QUEST_SPC%' AND OBJECT_TYPE = 'SYNONYM';
SELECT 'DROP '||OBJECT_TYPE||' '||OWNER||'.'||OBJECT_NAME||';' FROM
DBA_OBJECTS WHERE object_name like 'SPACER%';
SELECT 'DROP '||OBJECT_TYPE||' '||OBJECT_NAME||';' FROM DBA_OBJECTS
WHERE object_name like 'SPACER%' AND OBJECT_TYPE = 'SYNONYM';
To confirm that all objects are gone, run the following queries and they should return no rows:
Select * From dba_objects where object_name like 'QUEST_SPC%';
Select * From dba_objects where object_name like 'SPACER%';
Select * From dba_objects where object_name like 'QUEST_EXEC%';
Then remove all space manager and QSA from the quest product table as well:
delete from quest_com_products where product_id=62; commit;
delete from quest_com_products where product_id=61; commit;
delete from quest_com_products where product_id=35; commit;
NOTE: you will loose all scheduled reorg jobs, analysis jobs, analysis groups, so recreate them after the reinstallation
© ALL RIGHTS RESERVED. 이용 약관 개인정보 보호정책 Cookie Preference Center