首页 > 系统相关 >Grid/RAC 11.2.0.4 与 Linux 7 的一些兼容性问题

Grid/RAC 11.2.0.4 与 Linux 7 的一些兼容性问题

时间:2023-04-27 14:11:27浏览次数:42  
标签:RAC 11grac1 0.4 11.2 cert 兼容性问题 root ora

1、在LINUX6上安装 11.2.0.4的RAC,基本上不会遇到什么问题,但如果在LINUX7上安装11.2.0.4的RAC,经常性地会遇到问题。 为了很好地解决这个问题,ORACLE官方在MOS上给了一篇文档《Installation walk-through - Oracle Grid/RAC 11.2.0.4 on Oracle Linux 7 (Doc ID 1951613.1)》,这篇文档将LINUX7上安装11.2.0.4RAC可能会遇到的问题,以及对应的解决方案全部罗列了出来。

 

2、对于1951613.1这篇文档而言,最核心的一个补丁是18370031,在安装GI集群时,需要在运行root.sh之前先安装这个补丁,否则root.sh脚本必然会失败。

 

3、今天在测试环境中搭建一套LINUX7上的11.2.0.4RAC, 严格按照1951613.1这篇文档进行实施的,结果在运行root.sh时,仍然遇到故障,故障信息如下:

[root@11grac1 ~]# /u01/app/11.2.0.4/grid/root.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/11.2.0.4/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...


Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/11.2.0.4/grid/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
Installing Trace File Analyzer
OLR initialization - successful
  root wallet
  root wallet cert
  root cert export
  peer wallet
  profile reader wallet
  pa wallet
  peer wallet keys
  pa wallet keys
  peer cert request
  pa cert request
  peer cert
  pa cert
  peer root cert TP
  profile reader root cert TP
  pa root cert TP
  peer pa cert TP
  pa peer cert TP
  profile reader pa cert TP
  profile reader peer cert TP
  peer user cert
  pa user cert
Adding Clusterware entries to oracle-ohasd.service
CRS-2672: Attempting to start 'ora.mdnsd' on '11grac1'
CRS-2676: Start of 'ora.mdnsd' on '11grac1' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on '11grac1'
CRS-2676: Start of 'ora.gpnpd' on '11grac1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on '11grac1'
CRS-2672: Attempting to start 'ora.gipcd' on '11grac1'
CRS-2676: Start of 'ora.cssdmonitor' on '11grac1' succeeded
CRS-2676: Start of 'ora.gipcd' on '11grac1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on '11grac1'
CRS-2672: Attempting to start 'ora.diskmon' on '11grac1'
CRS-2676: Start of 'ora.diskmon' on '11grac1' succeeded
CRS-2674: Start of 'ora.cssd' on '11grac1' failed
CRS-2679: Attempting to clean 'ora.cssd' on '11grac1'
CRS-2681: Clean of 'ora.cssd' on '11grac1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on '11grac1'
CRS-2677: Stop of 'ora.gipcd' on '11grac1' succeeded
CRS-2673: Attempting to stop 'ora.cssdmonitor' on '11grac1'
CRS-2677: Stop of 'ora.cssdmonitor' on '11grac1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on '11grac1'
CRS-2677: Stop of 'ora.gpnpd' on '11grac1' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on '11grac1'
CRS-2677: Stop of 'ora.mdnsd' on '11grac1' succeeded
CRS-5804: Communication error with agent process
CRS-4000: Command Start failed, or completed with errors.
CSS startup failed with return code 1
The exlusive mode cluster start failed, see Grid Infrastructure alert log for more information
Initial cluster configuration failed.  See /u01/app/11.2.0.4/grid/cfgtoollogs/crsconfig/rootcrs_11grac1.log for details
[root@11grac1 ~]# /u01/app/11.2.0.4/grid/perl/bin/perl -I/u01/app/11.2.0.4/grid/perl/lib -I/u01/app/11.2.0.4/grid/crs/install /u01/app/11.2.0.4/grid/crs/install/rootcrs.pl execution failed

[root@11grac1 ~]#

4、MOS中找到文档《GI Intallation On Linux 7 Fails with 'CSS Startup Failed With Return Code 1' And CRS-1656 (Doc ID 2935061.1)》, 这篇文档中的故障现象与当前环境完全一致,最终 的解决方案是:安装补丁31718723 - 11.2.0.4.201020 (Oct 2020) Grid Infrastructure Patch Set Update (GI PSU) 。 之后 ,重新运行root.sh脚本。

 

5、 注意!!! 我在测试环境中安装完补丁,重新运行root.sh,仍然报错,错误的现象与上述现象不同,怀疑是第一次运行root.sh脚本后,一些异常的配置信息影响了第二次root.sh。 最终的解决办法是运行deconfig脚本,将整个集群全部清空,然后运行config.sh脚本重新配置集群,此时运行root.sh脚本成功。

 

标签:RAC,11grac1,0.4,11.2,cert,兼容性问题,root,ora
From: https://www.cnblogs.com/missyou-shiyh/p/17358756.html

相关文章

  • [INS-42017] The Grid home is inconsistent on the following nodes: [11grac2]
    1、一套11.2.0.4RAC的测试环境,集群被捣鼓坏了,打算deconfig后,运行config.sh脚本重新配置集群。2、运行config.sh脚本,在检测环境时,遇到如下故障:[INS-42017]TheGridhomeisinconsistentonthefollowingnodes:[11grac2] 3、搜索MOS,找到文档《config.sh:[INS-32167]The......
  • RAC中多实例开启归档和闪回
    下面是针对其中一个实例的步骤记录注意事项:0、参数修改只在一个节点执行即可,记得sid='*'1、每个实例需切换环境变量2、开归档需先关闭DB再mount来开启3、闪回区开启需先设置大小再设置位置以下操作只在节点1执行1、设置环境变量、关闭DB之前先设置下归档路径[oracle@mydb1~]\$......
  • EBS: APP-PER-50022: ORACLE 人力资源管理系统无法检索用户类型配置文件选项的值
    在PO模块设置的人员,点击“人员”功能菜单时,提示: APP-PER-50022。。。。。的错误。路径:PO》》设置》》人员。APP-PER-50022:ORACLE人力资源管理系统无法检索用户类型配置文件选项的值。请确保为您的责任正确设置此值。尝试解决方式(失败了):  PROFILE |     ......
  • CellOracle | in silico gene perturbation | 新旧世代的交替
     目的:对我们的单细胞多组学数据作此分析,看那个de-diff的TF的敲除能够逆转分化方向。科研永远是追新者的天堂,不解释。 tutorial:Tutorial - ReadtheDocshttps://github.com/morris-lab/CellOracleDissectingcellidentityvianetworkinferenceandinsilicogenepe......
  • Oracle sql injection
    先创建一个普通用户并授权:C:\>sqlplus"/assysdba"SQL*Plus:Release10.2.0.1.0-Productionon星期三7月3121:49:452013Copyright(c)1982,2005,Oracle.Allrightsreserved.连接到:PersonalOracleDatabase10gRelease10.2.0.1.0-ProductionWiththe......
  • maven 增加oracle驱动
    进入ojdbc14.jar所在目录C:\oracle\product\10.2.0\db_1\jdbc\lib执行命令:mvninstall:install-file-DgroupId=com.oracle-DartifactId=ojdbc14-Dversion=10.2.0.1.0-Dpackaging=jar-Dfile=ojdbc14.jar输出:C:\oracle\product\10.2.0\db_1\jdbc\lib>mvninstall:i......
  • ORACLE修改列名与列类型
    --1.修改列名altertable表名renamecolumn旧列名to新列名;--实例altertablexsbrenamecolumnxhto学号;--2.修改列类型altertable表名modify(列名varchar(256));--实例altertablexsbmodify(学号varchar(256));--3.删除表的一列altertable表......
  • oracle plsql 自定义函数
    例如:CREATEORREPLACEFUNCTIONHELLO(strINVARCHAR2)RETURNVARCHAR2ISRETVARCHAR2(20);BEGINRET:='Hello'||str;DBMS_OUTPUT.put_line(RET);RETURNRET;END;执行:SELECTHELLO('yang')FROMDUAL;删除:DROPFUNCTIONHELLO;......
  • oracle pl sql 隐式游标SQL
    EMP表在SCOTT用户下。用SCOTT/TIGER登录。代码:BEGINUPDATEEMPSETENAME='SMITH'WHEREEMPNO=7369;DBMS_OUTPUT.put_line('SQL%ROWCOUNT='||SQL%ROWCOUNT);IFSQL%ISOPENTHENDBMS_OUTPUT.put_line('SQL%ISOPEN');ELSEDBM......
  • oracle exp/imp 导入导出数据
    exphibernate/hibernate@orclfile=c:\emp.dmptables=(hibernate.emp)imphibernate/hibernate@orclfile=c:\emp.dmpimp前,先要删除表,否则导入会失败。语法:EXP有三种主要的方式(完全、用户、表) 完全EXPSYSTEM/MANAGERBUFFER=64000FILE=C:\FULL.DMPFULL=Y 如果要执行完全......