Oracle 19.20 patch 注意事项

news/2024/6/18 4:30:29 标签: oracle, 数据库

1. 打patch 用root 打

/u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/app/patch/35319490

2.打patch 之前所有NODE上OPatch 版本要一样

3. OPatch 目录不要是root权限

4.打一台，一台自动重启。有几个node 在几个node 打。patch 都要传到不同的node上

5.Patch包给777 权限最好

6.文档说2 3 node可以并行打，可能不行！

CAUSE

OPatch is extracted as root user

SOLUTION

- Change the ownership of $ORACLE_HOME/OPatch directory to the home owner, say grid

# chown -R grid: $ORACLE_HOME/OPatch

- Resume/retry patching operation

# opatchauto apply <PATCH_LOCATION>

[root@rac1 patch]# /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/app/patch/35319490

OPatchauto session is initiated at Tue Sep 26 15:05:47 2023

System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2023-09-26_03-05-53PM.log.

Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2023-09-26_03-06-36PM.log
The id for this session is R4NA
Remote command execution failed due to Can't open perl script "/u01/app/19.0.0/grid/OPatch/auto/database/bin/RemoteHostExecutor.pl": (null)
Command output:
oracle.dbsysmodel.driver.sdk.productdriver.ProductDriverException: Execution failed for host rac3 due to : java.lang.Exception: Remote comman
Command output:
OPatchAuto failed.

OPatchauto session completed at Tue Sep 26 15:06:56 2023
Time taken to complete the session 1 minute, 4 seconds

opatchauto failed with error code 42
[root@rac1 patch]# /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/app/patch/35319490

OPatchauto session is initiated at Tue Sep 26 15:07:46 2023

System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2023-09-26_03-07-50PM.log.

Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2023-09-26_03-08-09PM.log
The id for this session is HKAL
Remote command execution failed due to Can't open perl script "/u01/app/19.0.0/grid/OPatch/auto/database/bin/RemoteHostExecutor.pl": (null)
Command output:
oracle.dbsysmodel.driver.sdk.productdriver.ProductDriverException: Execution failed for host rac3 due to : java.lang.Exception: Remote comman
Command output:
OPatchAuto failed.

OPatchauto session completed at Tue Sep 26 15:08:23 2023
Time taken to complete the session 0 minute, 33 seconds

opatchauto failed with error code 42

### node2 打完再打node3

[root@rac2 patch]# /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/app/patch/35319490

OPatchauto session is initiated at Tue Sep 26 17:34:34 2023

System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2023-09-26_05-34-47PM.log.

Remote command execution failed due to Exception in thread "main" oracle.dbsysmodel.driver.sdk.productdriver.ProductDriverException: failed to detect Grid Infrastructure setup due to null
   at oracle.dbsysmodel.driver.sdk.productdriver.ClusterInformationLoader.detectCrsHome(ClusterInformationLoader.java:328)
   at oracle.dbsysmodel.driver.sdk.productdriver.ClusterInformationLoader.loadInventory(ClusterInformationLoader.java:81)
   at oracle.dbsysmodel.driver.sdk.productdriver.ClusterInformationLoader.getInstance(ClusterInformationLoader.java:70)
   at oracle.dbsysmodel.driver.sdk.productdriver.remote.HomeListCollector.executeAction(HomeListCollector.java:31)
   at oracle.dbsysmodel.driver.sdk.productdriver.remote.RemoteOperationHelper.main(RemoteOperationHelper.java:26)
Command output:
OPATCHAUTO-72050: System instance creation failed.
OPATCHAUTO-72050: Failed while retrieving system information.
OPATCHAUTO-72050: Please check log file for more details.