青岛网站建设方案策划,登陆Wordpress手机app,手机网站的页面大小,外网域名1. 打patch 用root 打
/u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/app/patch/35319490
2.打patch 之前 所有NODE上OPatch 版本要一样
3. OPatch 目录不要是root权限
4.打一台#xff0c;一台自动重启。 有几个node 在几个node 打。patch 都要传到不同的node上
…
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 [rootrac1 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 Cant 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 [rootrac1 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 Cant 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 [rootrac2 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.
OPatchauto session completed at Tue Sep 26 17:35:53 2023 Time taken to complete the session 1 minute, 7 seconds
Topology creation failed.
CAUSE
Database Vault is enabled.
SOLUTION
The symptoms are documented under Bug 23199899 - ORA-01031: INSUFFICIENT PRIVILEGES WHEN CONVERTING DBV ENABLED NCDB
The workaround is as follows:
1) GRANT DV_PATCH_ADMIN to SYS
2) re-execute datapatch
3) REVOKE DV_PATCH_ADMIN from SYS
