EM 13c: Unable to View Data in Graphs Under Ash Analytics Pages for all Database Instances Under Cluster Databases (Doc ID 2769789.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

• In EM 13C, unable to view data in graphs under Performance hub --> Ash Analytics page for all database instances under Cluster database
• From EM OMS emoms.trc file, observed the below
  2021-01-02 03:57:49,649 [EMUI_03_57_49_/console/database/instance/orarep/ash/viewer/perf/ashdata/realtime] DEBUG db.DBSQLUtil logp.251 - Checking the knob for execution via agent is enabled for target = <DB_Instance_Name>
  2021-01-02 03:57:49,650 [EMUI_03_57_49_/console/database/instance/orarep/ash/viewer/perf/ashdata/realtime] DEBUG db.DBSQLUtil logp.251 - The execution via agent knob is enabled : false
  2021-01-02 03:57:49,675 [EMUI_03_57_49_/console/database/instance/orarep/ash/viewer/perf/ashdata/realtime] DEBUG credstore.EMCredentialUtil getMonitoringCredential.3723 - Entry: targetName:<DB_Instance_Name> targetType:oracle_database setnameDBCredsMonitoring
  2021-01-02 03:57:49,675 [EMUI_03_57_49_/console/database/instance/orarep/ash/viewer/perf/timepicker/realtime] DEBUG reports.CommonXMLReportGenerator logp.251 - DBSNMP.omc_ash_viewer.getVersion was not found on target <DB_Instance_Name> (oracle_database). Error: ORA-00904: "DBSNMP"."OMC_ASH_VIEWER"."GETVERSION": invalid identifier

  2021-01-02 03:57:49,677 [EMUI_03_57_49_/console/database/instance/orarep/ash/viewer/perf/timepicker/realtime] DEBUG reports.CommonXMLReportGenerator logp.251 - createAshMethodSQLQuery :: SELECT sys.dbms_ash.getTimePickerRealTime(time_since_sec=> ?, instance_number=> ?).getClobVal(2,2) AS output FROM dual
  2021-01-02 03:57:49,688 [EMUI_03_57_49_/console/database/instance/orarep/ash/viewer/perf/ashdata/realtime] DEBUG credstore.EMCredTypeMetaData validateParam.267 - Validating Attribute DBPassword
  2021-01-02 03:57:49,689 [EMUI_03_57_49_/console/database/instance/orarep/ash/viewer/perf/ashdata/realtime] DEBUG credstore.EMCredTypeMetaData validateParam.267 - Validating Attribute DBRole
  2021-01-02 03:57:49,689 [EMUI_03_57_49_/console/database/instance/orarep/ash/viewer/perf/ashdata/realtime] DEBUG credstore.EMCredTypeMetaData validateParam.267 - Validating Attribute DBUserName
  2021-01-02 03:57:49,689 [Symptom-Diagnosis:Symptom-Diagnosis Admin] DEBUG workmanager.Work logp.251 - Work:Starting work for BackGround Work Instance :Symptom-Diagnosis Admin
  2021-01-02 03:57:49,690 [EMUI_03_57_49_/console/database/instance/orarep/ash/viewer/perf/ashdata/realtime] DEBUG credstore.EMCredentialUtil getMonitoringCredential.3774 - Exit: return username:sys
  2021-01-02 03:57:49,714 [EMUI_03_57_49_/console/database/instance/orarep/ash/viewer/perf/timepicker/realtime] DEBUG reports.CommonXMLReportGenerator logp.251 - Exception invoking SQL
  java.sql.SQLException: ORA-06553: PLS-306: wrong number or types of arguments in call to 'GETTIMEPICKERREALTIME' ---------->>>

  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495)
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:447)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1055)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:624)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:253)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:613)

  Caused by: Error : 6553, Position : 7, Sql = SELECT sys.dbms_ash.getTimePickerRealTime(time_since_sec=> :1 , instance_number=> :2 ).getClobVal(2,2) AS output FROM dual, OriginalSql = SELECT sys.dbms_ash.getTimePickerRealTime(time_since_sec=> ?, instance_number=> ?).getClobVal(2,2) AS output FROM dual, Error Msg = ORA-06553: PLS-306: wrong number or types of arguments in call to 'GETTIMEPICKERREALTIME' ---------->>>

   

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.