OID 11g Fails to Start After Patching / a Patchset -- Oidmon log shows: OIDMON_STOP: WARNING: Connected to incorrect OID base schema version, (version=OID <lower 11g or 10g patchset>). WARNING: OID (version <...>) is now operating in read_only mode (Doc ID 1900337.1)

Last updated on OCTOBER 09, 2024

Applies to:

Symptoms

Oracle Internet Directory (OID) 11g, for example, 11.1.1.6's (not an upgrade from 10g), which had been working fine.

Applied a newer patchset, e.g. 11.1.1.7 or 11.1.1.9.

Afterwards, did not start or test any process or service, nor did any checking after the upgrade; just went on and applied a CPU patch on top.

Ran the PatchSet Assistant (PSA) supplying "sys as sysdba" for connection as instructed.  The PSA .log and .out files returned a successful upgrade and no errors.

Note: The upgrade post-patching did not prompt to run "oidRoot.sh" as noted in the documentation, and it only requested to run "oracleRoot.sh" once.


Now OID will not start.  The oidmon log file shows, for example:

The ODS schema version shows the correct 11.1.1.7 in schema_version_registry, however, the following sql returns an older 11g or 10g version, for example:

But there is no orclcompatibleversion=11.1.1.7 (neither from the sql query nor in the oiddiag report).

The issue is similar to Document 1569628.1, and Document 1545286.1 which is upgrading to 11.1.1.6.  The supported/preferred method to correct upgrade problems is as in Document 1376706.1 (i.e., to re-run all upgrade tasks and ensure there are no failures of any sort in any logs), however this has not worked in this case.


This issue is not be reproducible on a different environment (env).

Changes

Cause

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