Correcting the error [ERROR] [OracleDBAgent] Connection error for host/database: <Database>. Reporting no data values. ORA-06550.

Products

• CA Application Performance Management Agent (APM / Wily / Introscope)
• INTROSCOPE

Issue/Introduction

     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

Environment

This error can occur in all APM 10.x versions.

Cause

     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.

 

Resolution

     To correct this error, have a Database Administrator run the <PPPOracleDBHome>/deploy/PPOracleDB_UserPrivileges.sql script. More information on it can be found here:
https://docops.ca.com/ca-apm/10-5/en/extending/oracle-database-monitoring/install-and-configure-apm-for-oracle-databases/#InstallandConfigureAPMforOracleDatabases-ConfigureOracleUseronMonitoredDatabase

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';

Additional Information

     As always, contact CA Support for further questions.