主机准备

OEL 9.2 要选RHCK的内核

[grid@cluster04-db01 ~]$ uname -sr
Linux 5.14.0-284.11.1.el9_2.x86_64

一般RAC实施的准备工作（磁盘组、关闭防火墙等等）

GI 19.23.0.0.240416 (36233263)

遇到问题问题

一、需要手动安装一些包比如

 wget https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm
dnf install compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm 
dnf install gcc-c++
dnf install elfutils-libelf-devel
dnf install libaio-devel

二、一些动态库要手动修一下

• 1、 libclntshcore.so

 Failed to link libclntshcore.so.12.1

参考 https://gitee.com/src-openeuler/glibc/issues/I5F6U6 给文件做个link

libpthread_nonshared.a这个文件是个空文件，临时的规避方案选择如下之一处理：

    glibc-devel包中有libpthread.a，可以建个软连接过去。ln -s libpthread.a libpthread_nonshared.a
    ar cr /usr/lib64/libpthread_nonshared.a生成一个空的静态文件。

• 2、ins_precomp

APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.
SYMPTOMS
While installing 11.2.0.4 binary on RHEL8.6, relink issues are seen as below :

make[1]: Entering directory '<ORACLE_HOME>/product/precomp/lib' Linking <ORACLE_HOME>/precomp/lib/proc //usr/lib64/libaio.so.1: undefined reference to `__stack_chk_fail@GLIBC_2.4' collect2: error: ld returned 1 exit status /bin/chmod: cannot access '<ORACLE_HOME>/precomp/lib/proc': No such file or directory make[1]: *** [<ORACLE_HOME>/precomp/lib/ins_precomp.mk:118: <ORACLE_HOME>/precomp/lib/proc] Error 1 make[1]: Leaving directory '/ORACLE/11.2.0.4/product/precomp/lib' make: *** [/ORACLE/11.2.0.4/product/precomp/lib/ins_precomp.mk:28: proc] Error 2 Error in invoking target 'links proc gen_pcscfg' of makefile '<ORACLE_HOME>/precomp/lib/ins_precomp.mk'. See '<ORACLE_HOME>/install/relinkActions2023-02-16_03-01-23-PM.log' for details.

参考 http://www.hcdba.cc/?p=664

• 3.invoking target ‘agent nmhs’ of makefile ins_emagent.mk

参考 http://www.hcdba.cc/?p=664

• 4.PRVF-4037 : CRS is not installed on any of the nodes

参考 RAC RDBMS Installation fails with Error:”PRVF-4037 : CRS is not installed on any of the nodes” (文档 ID 2315020.1)

./runInstaller  -updateNodeList ORACLE_HOME="/u01/app/19.3.0/grid/" "CLUSTER_NODES={cluster04-db01,cluster04-db02}" CRS=true

三、一些未知问题

1. scp在代码中失效，导致等效校验无法通过

比如在配置两节点等效后，下一步提示远程校验失败，debug看是无法scp复制文件到远端节点，即使手动scp过去，重试的过程中会删除远端的目录

[Worker 1] [ 2024-05-01 18:03:08.306 CST ] [RuntimeExec.runCommand:75]  Calling Runtime.exec() with the command 
[Worker 1] [ 2024-05-01 18:03:08.306 CST ] [RuntimeExec.runCommand:77]  /usr/bin/scp 
[Worker 1] [ 2024-05-01 18:03:08.306 CST ] [RuntimeExec.runCommand:77]  -p 
[Worker 1] [ 2024-05-01 18:03:08.306 CST ] [RuntimeExec.runCommand:77]  /opt/media/database/install/../stage/cvu//cv/remenv/runfixup.sh 
[Worker 1] [ 2024-05-01 18:03:08.307 CST ] [RuntimeExec.runCommand:77]  cluster04-db02:'/tmp//CVU_11.2.0.4.0_oracle/runfixup.sh' 
[Thread-1468] [ 2024-05-01 18:03:08.316 CST ] [StreamReader.run:61]  In StreamReader.run 
[Worker 1] [ 2024-05-01 18:03:08.321 CST ] [RuntimeExec.runCommand:142]  runCommand: Waiting for the process
[Thread-1467] [ 2024-05-01 18:03:08.321 CST ] [StreamReader.run:61]  In StreamReader.run 
[Thread-1468] [ 2024-05-01 18:03:08.696 CST ] [StreamReader.run:65]  ERROR>dest open("'/tmp//CVU_11.2.0.4.0_oracle/runfixup.sh'"): No such file or directory
[Thread-1468] [ 2024-05-01 18:03:08.697 CST ] [StreamReader.run:65]  ERROR>failed to upload file /opt/media/database/install/../stage/cvu//cv/remenv/runfixup.sh to '/tmp//CVU_11.2.0.4.0_oracle/runfixup.sh'

解决方法是用for循环来自动复制文件到远程

for((i=1;i<=10000;i++)); do  scp -pr  /tmp/CVU_11.2.0.4.0_oracle/* cluster04-db02:/tmp/CVU_11.2.0.4.0_oracle/ ;  done

• 2. scp在代码中失效，导致oraclehome没有复制到远端

ui页面上提示需要执行 runInstaller -attachHome ，实际上远端节点都没有获取到文件，手动scp home 到远端节点后，执行脚本就可以了

 /u01/app/oracle/product/11.2.0.4/db_1/oui/bin/runInstaller -attachHome -noClusterEnabled ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db_1 ORACLE_HOME_NAME=OraDb11g_home1 CLUSTER_NODES=cluster04-db01,cluster04-db02 "INVENTORY_LOCATION=/u01/app/oraInventory" LOCAL_NODE="cluster04-db02"
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 8187 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'AttachHome' was successful.