-
Title
GUI shows"Quest Server Agent Staus: Not Installed" after running ./QSAStart.sh -
Description
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.
-
Cause
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.
-
Resolution
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');