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:
Enterprise Manager for Oracle Database - Version 13.4.0.0.0 to 13.4.0.0.0 [Release 13c]Information in this document applies to any platform.
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 identifier2021-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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |