Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Wrong value entry was inserted into dba_registry_history after applying Combo PSU 12.1.0.2.161018

edited Jan 10, 2017 9:05AM in Database Install/Upgrade/Opatch (MOSC) 2 commentsAnswered

After applying the PSU patch for Oct 2016 to our Oracle 12c database, we found one entry with wrong value in "version" field has been inserted into dba_registry_history.

SQL> select action_time,action,version,comments from dba_registry_history where action_time>to_date('20161025','yyyymmdd');

ACTION_TIME                    ACTION     VERSION                        COMMENTS

------------------------------ ---------- ------------------------------ --------------------------------------------------------------------------------

25-OCT-16 12.52.43.221732 PM   jvmpsu.sql 12.1.0.2.160719OJVMPSU         RAN jvmpsu.sql

In dba_registry_sqlpatch, we got correct values.

SQL> select patch_id,version,action,status,action_time,description from dba_registry_sqlpatch where action_time>to_date('20161025','yyyymmdd');

  PATCH_ID VERSION    ACTION     STATUS          ACTION_TIME                    DESCRIPTION

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center