Object ODS.OID_RESPONSE_ARRAY_TYPE does not exist, Grid Control

Object ODS.OID_RESPONSE_ARRAY_TYPE does not exist, Grid Control

After installing Oracle Application Server, with corresponding OID,  Grid Control gave me the obove mentioned error, and the the item OID a ‘metric collection error’.

To fix the metric collection error downloaded and applied Patch 5686191 on top of OID product.This is a sql-script to run against the OID-repository. Unpublished bug according to note 764088.1

Shutdown the DAS:

~/media/5686191> opmnctl stopproc process-type=OC4J_SECURITY

~/media/5686191> /software/oracle/product/10.2/infra/OPatch/opatch apply

Oracle Interim Patch Installer version
Copyright (c) 2005 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com

Oracle Home = /software/oracle/product/10.2/infra
Location of Oracle Universal Installer components = /software/oracle/product/10.2/infra/oui
Location of OraInstaller.jar  = “/software/oracle/product/10.2/infra/oui/jlib”
Oracle Universal Installer shared library = /software/oracle/product/10.2/infra/oui/lib/linux/liboraInstaller.so
Location of Oracle Inventory Pointer = /etc/oraInst.loc
Location of Oracle Inventory = /software/oracle/product/10.2/infra/inventory
Path to Java = /software/oracle/product/10.2/infra/jre/1.4.2/bin/java
Log file = /software/oracle/product/10.2/infra/.patch_storage/<patch ID>/*.log

Backing up comps.xml …

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.