OEM 13c: 'SQL Monitor - Last Hour' Section Not Showing Any SQL Information in DB Target Home Page.
(Doc ID 2900156.1)
Last updated on MARCH 11, 2023
Applies to:
Enterprise Manager for Oracle Database - Version 13.4.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
On : 13.4.0.0.0 version, RDBMS
Os: Oracle Linux 7
'SQL Monitor - Last Hour' Section not showing any SQL information in DB Target Home Page
emoms.trc shows the below errors.
2022-09-02 09:59:17,474 [MetricCollector:RACHOMETAB_THREAD550:55] WARN db.home logp.251 - DBNAME::rac_database::SQL_MONITOR: ORA-64451: Conversion of special character to escaped character failed.
ORA-06512: at "SYS.DBMS_SQLTUNE", line 21172
ORA-06512: at "SYS.DBMS_SQLTUNE", line 21011
ORA-06512: at "SYS.DBMS_SQLTUNE", line 21298
ORA-06512: at line 1
java.sql.SQLException: ORA-64451: Conversion of special character to escaped character failed.
ORA-06512: at "SYS.DBMS_SQLTUNE", line 21172
ORA-06512: at "SYS.DBMS_SQLTUNE", line 21011
ORA-06512: at "SYS.DBMS_SQLTUNE", line 21298
ORA-06512: at line 1
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)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:227)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:60)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:911)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:994)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1157)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3833)
at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1344)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3875)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1166)
at oracle.sysman.emSDK.core.util.jdbc.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:408)
at oracle.sysman.emo.perf.bean.sqlmonitor.SqlMonitorList.getMonitorList112AndUp(SqlMonitorList.java:352)
at oracle.sysman.emo.perf.bean.sqlmonitor.SqlMonitorList._getSQLMonitorData(SqlMonitorList.java:185)
at oracle.sysman.emo.perf.bean.sqlmonitor.SqlMonitorList.prePopulate(SqlMonitorList.java:137)
at oracle.sysman.emo.perf.metric.eng.MetricCached.prePopulateOnce(MetricCached.java:242)
at oracle.sysman.emo.perf.metric.eng.MetricCollectorThread._collectCachedData(MetricCollectorThread.java:616)
at oracle.sysman.emo.perf.metric.eng.MetricCollectorThread.run(MetricCollectorThread.java:342)
at oracle.sysman.emo.perf.metric.rt.DbMetricCollectorThread.run(DbMetricCollectorThread.java:100)
at java.lang.Thread.run(Thread.java:748)
Caused by: Error : 64451, Position : 7, Sql = select dbms_sqltune.report_sql_monitor_list(sql_id=>:1 , session_id=>:2 ,session_serial=>:3 , active_since_sec=>:4 , inst_id=>:5 , last_refresh_time=>to_date(:6 , 'MM/DD/YYYY hh24.mi.ss'), top_n_count=> 100,max_sqltext_length=> 200, report_level=>'basic', type=>'XML') from dual, OriginalSql = select dbms_sqltune.report_sql_monitor_list(sql_id=>?, session_id=>?,session_serial=>?, active_since_sec=>?, inst_id=>?, last_refresh_time=>to_date(?, 'MM/DD/YYYY hh24.mi.ss'), top_n_count=> 100,max_sqltext_length=> 200, report_level=>'basic', type=>'XML') from dual, Error Msg = ORA-64451: Conversion of special character to escaped character failed.
ORA-06512: at "SYS.DBMS_SQLTUNE", line 21172
ORA-06512: at "SYS.DBMS_SQLTUNE", line 21011
ORA-06512: at "SYS.DBMS_SQLTUNE", line 21298
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:499)
... 23 more
2022-09-02 09:59:17,724 [MetricCollector:RACHOMETAB_THREAD550:55] WARN dbhome.metric logp.251 - DBNAME::rac_database::HOME_PERFREGION_METRIC: null
java.util.NoSuchElementException
ORA-06512: at "SYS.DBMS_SQLTUNE", line 21172
ORA-06512: at "SYS.DBMS_SQLTUNE", line 21011
ORA-06512: at "SYS.DBMS_SQLTUNE", line 21298
ORA-06512: at line 1
java.sql.SQLException: ORA-64451: Conversion of special character to escaped character failed.
ORA-06512: at "SYS.DBMS_SQLTUNE", line 21172
ORA-06512: at "SYS.DBMS_SQLTUNE", line 21011
ORA-06512: at "SYS.DBMS_SQLTUNE", line 21298
ORA-06512: at line 1
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)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:227)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:60)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:911)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:994)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1157)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3833)
at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1344)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3875)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1166)
at oracle.sysman.emSDK.core.util.jdbc.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:408)
at oracle.sysman.emo.perf.bean.sqlmonitor.SqlMonitorList.getMonitorList112AndUp(SqlMonitorList.java:352)
at oracle.sysman.emo.perf.bean.sqlmonitor.SqlMonitorList._getSQLMonitorData(SqlMonitorList.java:185)
at oracle.sysman.emo.perf.bean.sqlmonitor.SqlMonitorList.prePopulate(SqlMonitorList.java:137)
at oracle.sysman.emo.perf.metric.eng.MetricCached.prePopulateOnce(MetricCached.java:242)
at oracle.sysman.emo.perf.metric.eng.MetricCollectorThread._collectCachedData(MetricCollectorThread.java:616)
at oracle.sysman.emo.perf.metric.eng.MetricCollectorThread.run(MetricCollectorThread.java:342)
at oracle.sysman.emo.perf.metric.rt.DbMetricCollectorThread.run(DbMetricCollectorThread.java:100)
at java.lang.Thread.run(Thread.java:748)
Caused by: Error : 64451, Position : 7, Sql = select dbms_sqltune.report_sql_monitor_list(sql_id=>:1 , session_id=>:2 ,session_serial=>:3 , active_since_sec=>:4 , inst_id=>:5 , last_refresh_time=>to_date(:6 , 'MM/DD/YYYY hh24.mi.ss'), top_n_count=> 100,max_sqltext_length=> 200, report_level=>'basic', type=>'XML') from dual, OriginalSql = select dbms_sqltune.report_sql_monitor_list(sql_id=>?, session_id=>?,session_serial=>?, active_since_sec=>?, inst_id=>?, last_refresh_time=>to_date(?, 'MM/DD/YYYY hh24.mi.ss'), top_n_count=> 100,max_sqltext_length=> 200, report_level=>'basic', type=>'XML') from dual, Error Msg = ORA-64451: Conversion of special character to escaped character failed.
ORA-06512: at "SYS.DBMS_SQLTUNE", line 21172
ORA-06512: at "SYS.DBMS_SQLTUNE", line 21011
ORA-06512: at "SYS.DBMS_SQLTUNE", line 21298
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:499)
... 23 more
2022-09-02 09:59:17,724 [MetricCollector:RACHOMETAB_THREAD550:55] WARN dbhome.metric logp.251 - DBNAME::rac_database::HOME_PERFREGION_METRIC: null
java.util.NoSuchElementException
Changes
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 |
Changes |
Cause |
Solution |
References |