-
Title
How to manually grant privileges during agent installation? -
Description
How to manually grant privileges during agent installation?
-
Cause
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.
-
Resolution
To perform the manual granting sequence (do not exit the installation wizard):
On the monitored instance:
1. Navigate to the following directory
-Windows: %TEMP%\pa_mon_sqls_<##>
-UNIX: /tmp/pa_mon_sqls_<##>
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.