EM 13c: Opening Incident in Enterprise Manager 13c Cloud Control Incident Manager Results in PLS-00302, ORA-06550, and oracle.jdbc.driver Errors
(Doc ID 2792473.1)
Last updated on AUGUST 17, 2021
Applies to:
Enterprise Manager Base Platform - Version 13.4.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Opening any incident under the Enterprise Manager (EM) 13.4 Cloud Control Incident Manager results in error: An internal error has occurred. Check the log file for details
From <EM_INSTANCE_BASE>/gc_inst/em/EMGC_OMS1/sysman/log/emoms_pbs.trc:
2021-06-23 06:28:35,585 [Job Step -2 Job Internal Pool:JobWorker] WARN jobs.JobConnectionServiceStats logp.251 - Unable to insert connection pool stats: JobWorkerPool
java.sql.SQLException: ORA-06550: line 1, column 21:
PLS-00302: component 'ADD_CONNECTION_SERVICE_STATS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
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 : 6550, Position : 20, Sql = BEGIN EM_JOB_METRIC.add_connection_service_stats(:1 ,:2 ,:3 ,:4 ,:5 ,:6 ); END;, OriginalSql = BEGIN EM_JOB_METRIC.add_connection_service_stats(?,?,?,?,?,?); END;, Error Msg = ORA-06550: line 1, column 21:
PLS-00302: component 'ADD_CONNECTION_SERVICE_STATS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:499)
java.sql.SQLException: ORA-06550: line 1, column 21:
PLS-00302: component 'ADD_CONNECTION_SERVICE_STATS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
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 : 6550, Position : 20, Sql = BEGIN EM_JOB_METRIC.add_connection_service_stats(:1 ,:2 ,:3 ,:4 ,:5 ,:6 ); END;, OriginalSql = BEGIN EM_JOB_METRIC.add_connection_service_stats(?,?,?,?,?,?); END;, Error Msg = ORA-06550: line 1, column 21:
PLS-00302: component 'ADD_CONNECTION_SERVICE_STATS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:499)
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 |