My Oracle Support Banner

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

Last updated on OCTOBER 15, 2020

Applies to:

Enterprise Manager Base Platform - Version 11.1.0.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.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.