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

Document ID : KB000008670
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

     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.