How to manually grant privileges during agent installation?
During Performance Analysis agent installation, if the <quest user> lacks the required privileges to perform grants and if O7_DICTIONARY_ACCESSIBILITY set to False and REMOTE_LOGIN_PASSWORDFILE set to NONE, the privileges will have to be granted manually.
To perform the manual granting sequence (do not exit the installation wizard):
On the monitored instance:
1. Navigate to the following directory
2. Verify that the ORACLE SID variable is correctly set to the monitored instance.
3. Log on to the monitored Oracle instance as a SYSDBA account, by running:
sqlplus "sys/<PASSWD> as sysdba"
4. Run the quest_pa60_grant_mon_user.sql script available in the above directory as a SYSDBA user and provide the <quest user> when prompted.
On the installation wizard, click Next to continue.