在版本操作系统安装12.2遇到很多bug ,建议在RedHat Linux7.7以上还是用19C吧，不过安装处理过程还是可以学习到很多东西，下面记录了遇到的bug或者遇到的问题，希望对大家学习有用。
1 安装报错
PRVG-0802 : Storage type for path "/dev/dm-7" could not be determined on node "w-pc-x3650m5-239". PRVG-0801 : invalid internal command tags - Cause: An error occurred while attempting to determine the storage type of the indicated path. Accompanying messages provide further details. - Action: Resolve the issues described in any accompanying messages and retry.
-
PRVG-0802 : Storage type for path "/dev/dm-16" could not be determined on node "w-pc-x3650m5-239". PRVG-0801 : invalid internal command tags - Cause: An error occurred while attempting to determine the storage type of the indicated path. Accompanying messages provide further details. - Action: Resolve the issues described in any accompanying messages and retry.
这个问题开始以为是bug导致，但是打补丁后依然报错，排除这个问题，后续忽略错误直接跑，后在1节点执行root.sh脚本报错如下
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
2022/01/14 10:28:47 CLSRSC-400: A system reboot is required to continue installing.
The command '/grid/12.2/perl/bin/perl -I/grid/12.2/perl/lib -I/grid/12.2/crs/install /grid/12.2/crs/install/rootcrs.pl ' execution failed
这个是bug25078431导致
./gridSetup.sh -applyOneOffs /u01/patch/25078431/25078431
后续我们提前打了新的RU
[grid@m5-168 /grid/12.2]$./gridSetup.sh -applyPSU /tmp/33290750
Preparing the home to patch...
Applying the patch /tmp/33290750...
Successfully applied the patch.
The log can be found at: /tmp/GridSetupActions2022-01-14_09-01-27AM/installerPatchActions_2022-01-14_09-01-27AM.log
Launching Oracle Grid Infrastructure Setup Wizard...
此安装过程报错又有如下报错
[INS-42505] The installer has detected that the Oracle Grid Infrastructure home software at ($GRID_HOME) is not complete.
ause - Following files are missing: [/grid/12.2/jdk/.manifest,
/grid/12.2/jdk/lib/missioncontrol, /grid/12.2/jdk/lib/missioncontrol/artifacts.xml,
/grid/12.2/jdk/lib/missioncontrol/.eclipseproduct, /grid/12.2/jdk/lib/missioncontrol/mc.jar,
....
/grid/12.2/jdk/lib/missioncontrol/plugins/org.eclipse.core.resources_3.9.1.v20140825-1431.jar, ...]
Action - Ensure that the Oracle Grid Infrastructure home at (/grid/12.2) includes the files listed above.
原因
GRIDSETUP.SH -APPLYPSU
This issue has been reported to the following internal bug which has fixed 18.3
BUG 31579347 - AIX:JDK FILES GOT REMOVED AFTER GRIDSETUP.SH -APPLYPSU APR2020 GI (30920127 ) RESULTED INS-32829
这也是bug,解决方式如下
Workaround :
1. Either (a) proceed with the installation by clicking "Yes" or (b) click "No,
2. Then immediately rename <OH>/install/files.lst to<OH>/install/files.lst.bak and click "Next" again.
后续执行执行脚本有19步骤有报错如下
问题
2022/01/14 11:24:37 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.
2022/01/14 11:30:11 CLSRSC-614: failed to get the list of configured diskgroups
Died at /grid/12.2/crs/install/oraasm.pm line 2069.
The command '/grid/12.2/perl/bin/perl -I/grid/12.2/perl/lib -I/grid/12.2/crs/install /grid/12.2/crs/install/rootcrs.pl ' execution failed
解决方法
[root@m5-108 ~]#export ORACLE_HOME=/grid/12.2
[root@m5-108 ~]#cd /grid/12.2/rdbms/lib
[root@m5-108 /grid/12.2/rdbms/lib]#
/usr/bin/make -f ins_rdbms.mk client_sharedlib libasmclntsh12.ohso libasmperl12.ohso ORACLE_HOME=$ORACLE_HOME
还要注意安装数据库时，找集群节点有如下报错
echo $HOME failed on 'Oracle Clusterware infrastructure warning in OLSNODES (OS PID 47810): Non-fatal error (22) during NLS data loading initialization'
原因是oracle用户的.bash_profile中变量ORA_NLS10=$ORACLE_HOME/nls/data配置不对，这里需要设置grid_home目录，需要修改如下
修改如下 ORA_NLS10到grid家目录
export ORA_NLS10=$ORACLE_HOME/nls/data===> export ORA_NLS10=/grid/12.2/nls/data
由于19步骤报错，只在个节点执行make操作，导致第二，三个 redo 无法创建，报错为CRS-5017 CRS-01618 redo thread 3 is not enabled -cann't mount
手工执行make后，手工添加日志组，注意后 enable thread .否则依然报错
alter database add logfile
thread 2 group 5
('+DATA1/wfz1/redo021.log') size 1G;
alter database add logfile
thread 2 group 6
('+DATA1/wfz1/redo022.log') size 1G;
alter database add logfile
thread 2 group 7
('+DATA1/wfz1/redo023.log') size 1G;
alter database add logfile
thread 2 group 8
('+DATA1/wfz1/redo024.log') size 1G;
****************
alter database add logfile
thread 3 group 9
('+DATA1/wfz1/redo031.log') size 1G;
alter database add logfile
thread 3 group 10
('+DATA1/wfz1/redo032.log') size 1G;
alter database add logfile
thread 3 group 11
('+DATA1/wfz1/redo033.log') size 1G;
alter database add logfile
thread 3 group 12
('+DATA1/wfz1/redo034.log') size 1G;
enable thread 操作
alter database enable public thread 2;
alter database enable public thread 3;
启动数据库正常
