After connecting with GUI 7.6.0 to the database xxx1. Clicking on Script/Job Monitor window display "Quest Server Agent Status: Not Installed"
We have verify that QSA process was started successfully from running ./QSAStart.sh. Also, from the ps -ef | grep -i qsa shows it that QSA process is running.
Also, from query- select * from quest_com_products table. It does shows Product_ID = 61 for QSA and version 7.6.0.
There are two versions of the Space Manager Server side objects in the database. There should only be one Space Manager Server Side objects.
Verify by runing this SQL.:
select owner, object_type from dba_objects where object_name=upper('quest_exec');
You'll see it returns multiple owner for the same package body.
WORKAROUND:
1. Find out the owners that own the Package Body from SQL - select owner, object_type from dba_objects where object_name=upper('quest_exec');
2. Drop one of the owner from step 1 with cascade option
3. Re-connect with Space Manager GUI as the remaining owner.
4. Re-install Space Manager Server Side Objects
5. Re-install QSA manually as the same owner from step 3.
select owner, object_type from dba_objects where object_name=upper('quest_exec');
