среда, 27 марта 2013 г.

Rollback PSU 11.2.0.3.5

Patch  14727347 - 11.2.0.3.5 GI Patch Set Update (Includes Database PSU 11.2.0.3.5)


1. Stop the CRS managed resources running from DB homes.

# su - oraagent

$ emctl stop agent

# su - oradb

$ /u01/app/oradb/product/11.2.0.3/dbhome_1/bin/srvctl stop home -o /u01/app/oradb/product/11.2.0.3/dbhome_1 -s /export/home/oradb/state_file.oradb



2. Run the pre root script.

$su -

# /u01/app/11.2.0.3/grid/crs/install/roothas.pl -unlock



3. Unzipping

# su - oragrid

$cd /tmp

$unzip  p14727347_112030_SOLARIS64.zip

$ls -l
total 552336
drwxrwxr-x 4 oragrid oinstall 307 Jul 18 09:21 15876003
drwxr-xr-x 5 oragrid oinstall 302 Jul 18 09:21 14727310



4. Rollback the CRS patch using.


    $ /u01/app/11.2.0.3/grid/OPatch/opatch rollback -local -id 15876003 -oh /u01/app/11.2.0.3/grid
    $ /u01/app/11.2.0.3/grid/OPatch/opatch rollback -local -id 14727310 -oh /u01/app/11.2.0.3/grid




5. Run the pre script for DB component of the patch.

# su - oradb

    $ /tmp/15876003/custom/server/15876003/custom/scripts/prepatch.sh -dbhome /u01/app/oradb/product/11.2.0.3/dbhome_1



6. Rollback the DB patch.


    $ /u01/app/oradb/product/11.2.0.3/dbhome_1/OPatch/opatch rollback -local -id 15876003 -oh /u01/app/oradb/product/11.2.0.3/dbhome_1
    $ /u01/app/oradb/product/11.2.0.3/dbhome_1/OPatch/opatch rollback -local -id 14727310 -oh /u01/app/oradb/product/11.2.0.3/dbhome_1



7. Run the post script for DB component of the patch.

    $ /tmp/15876003/custom/server/15876003/custom/scripts/postpatch.sh -dbhome /u01/app/oradb/product/11.2.0.3/dbhome_1


8. Run the post script.

$su -

Run the post script.

# /u01/app/11.2.0.3/grid/rdbms/install/rootadd_rdbms.sh
# /u01/app/11.2.0.3/grid/crs/install/roothas.pl -patch


9. Start the CRS managed resources that were earlier running from DB homes.

# su - oradb

$ /u01/app/oradb/product/11.2.0.3/dbhome_1/bin/srvctl start home -o /u01/app/oradb/product/11.2.0.3/dbhome_1 -s /export/home/oradb/state_file.oradb


Проверяем:

$/u01/app/oradb/product/11.2.0.3/dbhome_1/OPatch/opatch lsinventory

$su - oragrid

$/u01/app/11.2.0.3/grid/OPatch/opatch lsinventory