Grid Control 11g Java Diagnostics (JVMD) Access Is Failing With ORA-904 Error
Last updated on MARCH 08, 2017
Applies to:Enterprise Manager Base Platform - Version: 18.104.22.168
Information in this document applies to any platform.
After installing an MLR patchset for the Grid Control OMS installation the Java Diagnostics (JVMD) pages fail with SQL errors. The errors will be similar to this one,
DB Access Layer SQL Exception:
update jam_managers set listen_port_enabled = ?, ssl_enabled = ?, manager_status = ?, build_version = ?, monitoring_status ='off' where manager_id = ?
ORA-00904: "MONITORING_STATUS": invalid identifier
java.sql.SQLSyntaxErrorException: ORA-00904: "MONITORING_STATUS": invalid identifier
There may be several errors or different errors depending on the version of the MLR patch that is being installed.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms