阿里云服务器搭建网站,适合学生做的网站,网站设计与实现毕业设计,免费网站建设方案前言: 本文主要介绍Oracle19c补丁升级遇到的问题#xff0c;涉及安装补丁prepatch步骤#xff0c;apply应用报错以及datapatch -verbose数据字典更新报错
问题一: 在执行补丁rootcrs.sh -prepatch操作时#xff0c;发生执行检查命令cluutil -chkshare报错
CLSRSC-180: An …前言: 本文主要介绍Oracle19c补丁升级遇到的问题涉及安装补丁prepatch步骤apply应用报错以及datapatch -verbose数据字典更新报错
问题一: 在执行补丁rootcrs.sh -prepatch操作时发生执行检查命令cluutil -chkshare报错
CLSRSC-180: An error occurred while executing the command cluutil -chkshare -oh /u01/app/grid -localnode prd-node3 -nodelist prd-node1,prd-node2,prd-node3,prd-node4
Died at /u01/app/19.0.0.0/grid/crs/install/crsutils.pm line 13132.
The command /u01/app/19.0.0.0/grid/perl/bin/perl -I/u01/app/19.0.0.0/grid/perl/lib -I/u01/app/19.0.0.0/grid/crs/install -I/u01/app/19.0.0.0/grid/xag /u01/app/19.0.0.0/grid/crs/install/rootcrs.pl -prepatch execution failed 对于这个报错要检查cluutil工具的运行日志$GRID_BASE/crsdata/$HOSTNAME/
crsconfig/cluutil.log确定具体的报错原因 当前案例遇到的是由于集群之间的ssh 22端口被禁用导致远程连接主机失败报错后面重新开放22端口解决 问题二: 在执行补丁rootcrs.sh -prepatch操作时,出现检查节点失败PRKC-1191 : Remote command execution setup check for node xxx2 using shell /usr/bin/ssh failed.
Using configuration parameter file: /u01/app/19.0.0/grid/crs/install/crsconfig_params
The log of current session can be found at:/u01/app/grid/crsdata/xxx1/crsconfig/crs_prepatch_xxx1_2022-12-27_07-47-28PM.log
xxx2 : PRKC-1191 : Remote command execution setup check for node xxx2 using shell /usr/bin/ssh failed.
File /usr/bin/ssh does not exist on node xxx2
2022/12/27 19:49:36 CLSRSC-180: An error occurred while executing the command /u01/app/19.0.0/grid/bin/cluutil -ckpt -global -oraclebase /u01/app/grid -writeckpt -name ROOTCRS_PATCHINFO -state SUCCESS -nodelist xxx1,xxx2 -transferfile
2022/12/27 19:49:36 CLSRSC-175: Failed to write the checkpoint ROOTCRS_PATCHINFO with status SUCCESS (error code 0)
2022/12/27 19:49:36 CLSRSC-175: Failed to write the checkpoint ROOTCRS_PATCHINFO with status SUCCESS (error code 0)
Died at /u01/app/19.0.0/grid/crs/install/crsutils.pm line 13985.
The command /u01/app/19.0.0/grid/perl/bin/perl -I/u01/app/19.0.0/grid/perl/lib -I/u01/app/19.0.0/grid/crs/install -I/u01/app/19.0.0/grid/xag /u01/app/19.0.0/grid/crs/install/rootcrs.pl -prepatch -nonrolling execution failed 报错的原因是由于操作系统/usr/bin下的执行程序没有ssh。默认路径下有ssh可能由于ssh升级或者安全整改导致/usr/bin下缺少了ssh最后重新将ssh软连接到/usr/bin修复问题
问题三: 在应用OJVM补丁的时候出现报错make: execvp: perl: Permission denied [javavm_refresh] Error 127
[Aug 1, 2023 6:06:13 PM] [INFO] Stack Description: java.lang.RuntimeException: make: execvp: perl: Permission deniedmake: *** [javavm_refresh] Error 127
at oracle.opatch.MakeAction.apply(MakeAction.java:538)
at oracle.opatch.OPatchSession.runMake(OPatchSession.java:757)
at oracle.opatch.OPatchSession.runMake(OPatchSession.java:699)
at oracle.opatch.MergedPatchObject.invokeConsolidatedMake(MergedPatchObject.java:1903)
at oracle.opatch.opatchutil.NApply.legacy_process(NApply.java:1550)
at oracle.opatch.opatchutil.NApply.legacy_process(NApply.java:373)
at oracle.opatch.opatchutil.NApply.process(NApply.java:353)
at oracle.opatch.opatchutil.OUSession.napply(OUSession.java:1139)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at oracle.opatch.UtilSession.process(UtilSession.java:355)
at oracle.opatch.OPatchSession.process(OPatchSession.java:2643)
at oracle.opatch.OPatch.process(OPatch.java:873)
at oracle.opatch.OPatch.main(OPatch.java:930) 对于这个报错主要检查执行用户的环境变量PATH,PERL5LIB是否设置正确如果配置错误会导致perllib的调用异常 设置正确的PATH,PERL5LIB环境变量解决
export PATH$ORACLE_HOME/perl/bin:$PATH
export PERL5LIB$ORACLE_HOME/perl/lib 此外在安装OJVM补丁还有检查用户的LANG环境变量是否设置正确特别是输出的变量格式是否正确之前遇到过en_US.UTF-8格式写错的导致安装OJVM补丁时出现LANGen_US相关的编译错误
问题四: 执行datapatch -verbose时出现报错 Error at line 19439: script rdbms/admin/cataudit.sql
- Error at line 19439: script rdbms/admin/cataudit.sql- ORA-04063: view SYS.DBA_AUDIT_TRAIL has errors- Error at line 19447: script rdbms/admin/cataudit.sql- ORA-04063: view SYS.DBA_AUDIT_TRAIL has errors- Error at line 19455: script rdbms/admin/cataudit.sql- ORA-04063: view SYS.DBA_AUDIT_TRAIL has errors- Error at line 19554: script rdbms/admin/cataudit.sql- ORA-04063: view SYS.DBA_AUDIT_TRAIL has errors- ORA-06512: at SYS.CDBVIEW_INTERNAL, line 93- ORA-06512: at SYS.CDBVIEW, line 6- ORA-06512: at line 1- Error at line 19565: script rdbms/admin/cataudit.sql- ORA-04045: errors during recompilation/revalidation of SYS.CDB_AUDIT_TRAIL- ORA-04063: view SYS.DBA_AUDIT_TRAIL has errors- Error at line 19574: script rdbms/admin/cataudit.sql- ORA-04045: errors during recompilation/revalidation of SYS.CDB_AUDIT_TRAIL- ORA-04063: view SYS.DBA_AUDIT_TRAIL has errors- Error at line 19583: script rdbms/admin/cataudit.sql- ORA-04045: errors during recompilation/revalidation of SYS.CDB_AUDIT_TRAIL- ORA-04063: view SYS.DBA_AUDIT_TRAIL has errors 报错是在执行数据字典编译调用审计数据字典脚本cataudit时出现通过数据库的DBA_ERRORS查看发现主要是审计表视图SYS.DBA_AUDIT_TRAIL出现编译错误而编译错误的原因是ORA-00942表或视图不存在 进一步检查发现视图SYS.DBA_AUDIT_TRAIL的基表AUD$被误删除了 最终从其他环境的19c数据库获取了AUD$的元数据重建表修复该问题