Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Oracle RAC manual rollback patch

2025-04-04 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Stop the CRS managed resources running from DB homes.

If this is a GI Home environment, as the database home owner execute:

$/ bin/srvctl stop home-o-s-n

If this is an Oracle Restart Home environment, as the database home owner execute:

$/ bin/srvctl stop home-o-s

Run the pre root script.

If this is a GI Home, as the root user execute:

/ crs/install/rootcrs.pl-unlock

If this is an Oracle Restart Home, as the root user execute:

/ crs/install/roothas.pl-unlock

Roll back the CRS patch. As the GI home owner execute:

$/ OPatch/opatch rollback-local-id-oh

$/ OPatch/opatch rollback-local-id-oh

$/ OPatch/opatch rollback-local-id-oh

Run the pre script for DB component of the patch. As the database home owner execute:

$/ custom/server//custom/scripts/prepatch.sh-dbhome

Roll back the DB patch from the database home. As the database home owner execute:

$/ OPatch/opatch rollback-local-id-oh

$/ OPatch/opatch rollback-local-id-oh

Run the post script for DB component of the patch. As the database home owner execute:

$/ custom/server//custom/scripts/postpatch.sh-dbhome

Run the post script. As the root user execute:

/ rdbms/install/rootadd_rdbms.sh

If this is a GI Home, as the root user execute:

/ crs/install/rootcrs.pl-patch

If this is an Oracle Restart Home, as the root user execute:

/ crs/install/roothas.pl-patch

If the message, "A system reboot is recommended before using ACFS??? is shown, then a reboot must be issued before continuing. Failure to do so will result in running with an unpatched ACFS\ ADVM\ OKS driver.

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

If this is a GI Home environment, as the database home owner execute:

$/ bin/srvctl start home-o-s-n

If this is an Oracle Restart Home environment, as the database home owner execute:

$/ bin/srvctl start home-o-s

1. Close a node database:

$srvctl stophome-o $ORACLE_HOME-s / tmp/stophome1.log-n rac2

two。 Lock a node GI:

/ u01/app/11.2.0/grid/crs/install/rootcrs.pl-unlock

3. Roll back the patch pack under GI HOME and execute it with the GI user:

$ORACLE_HOME/OPatch/opatch rollback-local-id 27441052-oh $ORACLE_HOME$ $ORACLE_HOME/OPatch/opatch rollback-local-id 22502505-oh $ORACLE_HOME$ $ORACLE_HOME/OPatch/opatch rollback-local-id 27338049-oh $ORACLE_HOME

4. Use oracle users to use scripts to detect:

$/ u01/app/stage/27475913/27441052/custom/server/27441052/custom/scripts/prepatch.sh-dbhome $ORACLE_HOME

5. Roll back the patch pack under database home and execute it with the oracle user:

$ORACLE_HOME/OPatch/opatch rollback-local-id 27441052-oh $ORACLE_HOME $ORACLE_HOME/OPatch/opatch rollback-local-id 27338049-oh $ORACLE_HOME

6. Execute the script using the oracle user:

$/ u01/app/stage/27475913/27441052/custom/server/27441052/custom/scripts/postpatch.sh-dbhome $ORACLE_HOME

7. Execute the script using the root user:

/ u01/app/11.2.0/grid/rdbms/install/rootadd_rdbms.sh / u01/app/11.2.0/grid/crs/install/rootcrs.pl-patch

8. Open the node instance:

$srvctl start home-o $ORACLE_HOME-s / tmp/stophome1.log-n rac2

9. Update data dictionary (run on a single node):

-update the data dictionary SQL > @? / rdbms/admin/catbundle.sql psu apply--- compile the java class SQL > @? / rdbms/admin/utlrp.sql select * from dba_registry_history

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report