Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Issue with 'datapatch - rollback'

edited Oct 12, 2017 10:35AM in Database Install/Upgrade/Opatch (MOSC) 7 commentsAnswered ✓

Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit

Oracle ASM 12.1.0.2.0, standalone, Oracle Restart, no RAC , no clustering of any kind

Oracle Linux 6

In advance of an upgrade from 11.2.0.4.0 SE-ONE to 12.1.0.2.0 SE-TWO, I am practicing downgrade back to 11.2

Referencing Doc ID 1516622.1, executing 'catdwgrd.sql', returned the following:

The following patches are still installed in the database.Run 'datapatch -rollback all -force' to uninstall them.SQL patch ID/UID 25437695/21057393 (Database PSU 1PSU bundle patch 170418 (DATABASE PATCH SET UPDATEDECLARE*ERROR at line 1:ORA-20000: All SQL patches must be rolled back before downgradeORA-06512: at line 25

So as instructed I follow up with

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