While using the APM for Oracle Database agent, the following error is reported:
[ERROR] [OracleDBAgent] Connection error for host/database: <Database>. Reporting no data values. ORA-06550: line 1, column 7:
PLS-00201: identifier 'POPULATE_TEMP_TABLES' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
This error indicates the connecting database user iscope_orcl or its objects have not been created in the Oracle Database instance. This user is used to establish a connection between the monitored database instance and the Oracle Database Agent.
To correct this error, have a Database Administrator run the <PPPOracleDBHome>/deploy/PPOracleDB_UserPrivileges.sql script. More information on it can be found here:
Once the script has been run, verify that the database user has been created using the following statement:
select object_name from all_objects where owner='ISCOPE_ORCL';
As always, contact CA Support for further questions.