Grid Control 11g Java Diagnostics (JVMD) Access Is Failing With ORA-904 Error (Doc ID 1385555.1)

Last updated on MARCH 08, 2017

Applies to:

Enterprise Manager Base Platform - Version: 11.1.0.1 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms


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 = ?
904
42000
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.

Cause

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