Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

opatch rollback

Permutationally_challengedJan 10 2017 — edited Jan 11 2017

Oracle 12c

I'm applying a patch (24315824).  I ran the prereq checks Literally just about every option, and it passed.  I ran the apply, and it was successful.

But now as part of my required testing, I have to back out the patch and revert the binaries back to pre-patch.  But this is failing.

I have tried many methods of backing it out.  Each failing.

opatch rollback -id 20676812 -oh

opatch rollback -id 20676812 -ph /oracle/12cpsu/oct2016psu/24315824/

opatch rollback -id 20676812 -oh /oracle/12cpsu/oct2016psu -invPtrLoc /oracle/12cpsu/oct2016psu/oraInst.loc

The error is as follows:

Oracle Interim Patch Installer version 12.1.0.1.10

Copyright (c) 2017, Oracle Corporation.  All rights reserved.

Argument(s) Error... Patch not present in the Oracle Home, Rollback cannot proceed

If the patch was applied using -no_inventory option, use -ph option

to specify the patch shiphome location. Use 'opatch rollback -help'

to get more information.

Please check the arguments and try again.

OPatch failed with error code 135

But the patch IS in the Oracle home.

here is the output from a listing of the oracle home directory, as well as an alias that shows all the oracle environment.  I bolded the patch directory.

{tcpi:}/oracle/12cpsu/oct2016psu> ls

19033356/                        cv/                              lib/                             p20404176_121020_SOLARIS64.zip   sqldeveloper/

20404176/                        db_patch/                        log/                             p24315824_121020_SOLARIS64.zip   sqlj/

24315824/                        dbs/                             md/                              p6880880/                        sqlpatch/

addnode/                         dc_ocm/                          mgw/                             patch_logs/                      sqlplus/

admin/                           deinstall/                       network/                         PatchSearch.xml                  srvm/

apex/                            demo/                            nls/                             perl/                            startup.log

apr2016psu/                      diagnostics/                     oc4j/                            plsql/                           suptools/

assistants/                      dmu/                             odbc/                            precomp/                         sysman/

bin/                             dv/                              olap/                            QOpatch/                         tcpi_invalids_patched.lst

ccr/                             forms_patch/                     OPatch/                          R/                               tcpipatch_rollback.willysh*

cdata/                           has/                             OPatch_b4update/                 racg/                            tcpi_patch.shwilly

cfgtoollogs/                     hs/                              OPatch_backup/                   rda/                             ucp/

check_patch2.sh*                 install/                         opmn/                            rdbms/                           usm/

check_patch3.sh*                 instantclient/                   oracore/                         relnotes/                        utl/

check_patch.sh*                  inventory/                       oraInst.loc                      rest/                            wwg/

clone/                           javavm/                          ord/                             rollback_24315824.sh*            xdk/

conversion_tcpi/                 jdbc/                            oserror/                         root.sh*

crs/                             jdk/                             oui/                             runpatch_24315824.sh*

css/                             jlib/                            owm/                             scheduler/

ctx/                             ldap/                            p19033356_121020_SOLARIS64.zip   slax/

{solftden01:tcpi:}/oracle/12cpsu/oct2016psu> envora

ORACLE_BASE=/oracle/12cbase

ORACLE_SID=tcpi

PS1={$ORACLE_SID:}$PWD>

ORACLE_OWNER=oracle

ORACLE_HOME=/oracle/12cpsu/oct2016psu

ORAENV_ASK=NO

{tcpi:}/oracle/12cpsu/oct2016psu>

I don't understand why the same settings that apply the patch, won't allow it to roll back.  Is there something else I'm not doing, or doing incorrectly?

This post has been answered by AJ on Jan 11 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 8 2017
Added on Jan 10 2017
7 comments
2,999 views