19.17RU安装问题汇总

问题概述

19.17RU安装问题汇总

一、lib库被其他用户使用

二、CRS-1159: The cluster cannot be set to rolling patch mode

三、 No read or write permission to ORACLE_HOME/.patch_storage

四、Datapatch：couldn't open encmap gbk.enc

五、CRS-6706: Oracle Clusterware Release patch level ('nnn') does not match Software patch level ('mmm') 

问题原因

解决方案

一、.lib库被其他用户使用

在安装DB软件的时候，总是出现lib库被其他用户使用的情况

Following active executables are used by opatch process :

/oracle/app/oracle/product/19.3.0/db_1/lib/libclntsh.so.19.1                                   

 /oracle/app/oracle/product/19.3.0/db_1/lib/libclntsh.so.18.1

处理办法：

1）如果是不指定-oh时，当出现CRS service brought down successfully on home /oracle/app/19.3.0/grid显示的时候

2）如果指定-oh时，当出现Bringing down database service on home /oracle/app/oracle/product/19.3.0/db_1

请用root用户执行

mv /oracle/app/oracle/product/19.3.0/db_1/lib/libclntsh.so.19.1 /oracle/app/oracle/product/19.3.0/db_1/lib/libclntsh.so.19.1_bak

mv /oracle/app/oracle/product/19.3.0/db_1/lib/libclntsh.so.18.1 /oracle/app/oracle/product/19.3.0/db_1/lib/libclntsh.so.18.1_bak

二、.CRS-1159: The cluster cannot be set to rolling patch mode

发现安装测试时，可能会遇到以下错误：
Using configuration parameter file: /oracle/app/19.3.0/grid/opatchautocfg/db/dbtmp/bootstrap_cs-shdb2/patchwork/crs/install/crsconfig_params
The log of current session can be found at:
  /oracle/app/19.3.0/grid/crsdata/cs-shdb2/crsconfig/crs_prepatch_apply_inplace_cs-shdb2_2022-03-29_10-42-24AM.log
Oracle Clusterware active version on the cluster is [19.3.0.0.0]. The cluster upgrade state is [ROLLING PATCH]. The cluster active patch level is [869426834].
CRS-1159: The cluster cannot be set to rolling patch mode because Oracle Clusterware is not active on at least one remote node.
CRS-4000: Command Start failed, or completed with errors.
2022/03/29 10:42:37 CLSRSC-430: Failed to start rolling patch mode

该错误由于19.9安装不规范导致.
用root用户执行
/oracle/app/19.3.0/grid/crs/install/rootcrs.sh -prepatch
/oracle/app/19.3.0/grid/crs/install/rootcrs.sh -postpatch

三、 No read or write permission to ORACLE_HOME/.patch_storage

OraInventory/ContentsXML目录的inventory.xml中ORACLE_HOME信息不对，打补丁时会出现
OPatchSession cannot load inventory for the given Oracle Home /oracle/app/oracle/product/19.3.0/db_1. Possible causes are:
   No read or write permission to ORACLE_HOME/.patch_storage
   Central Inventory is locked by another OUI instance
   No read permission to Central Inventory
   The lock file exists in ORACLE_HOME/.patch_storage
   The Oracle Home does not exist in Central Inventory
将文件中的路径调整为正确的路径

四、Datapatch：couldn't open encmap gbk.enc

在单点登录系统执行datapatch时，遇到以下报错：
patch 30484981:Error reading descriptor from registry :couldn't open encmap gbk.enc

确认为Oracle BUG，需要重建registry$sqlpatch数据字典，步骤如下：
Take the backup of registry$sqlpatch.
SQL>create table registry$sqlpatch_org as select * from registry$sqlpatch ;
drop the table registry$sqlpatch.
 SQL>drop table registry$sqlpatch;
      or
SQL> exec dbms_pdb.exec_as_oracle_script('drop table registry$sqlpatch');
Re-create the table by running the script.
 SQL>@$ORACLE_HOME/rdbms/admin/catsqlreg.sql
 SQL> exit
重建过程中，遇到registry$sqlpatch_ru_info is already used by an existing object
SQL>drop table registry$sqlpatch_ru_info;

需要删除registry$sqlpatch_ru_info对象，再次重建registry$sqlpatch数据字典后，恢复正常。

五、CRS-6706: Oracle Clusterware Release patch level ('nnn') does not match Software patch level ('mmm') 

如果补丁都已经正确应用

#<GRID_HOME>/crs/install:>./rootcrs.sh -unlock

#<GRID_HOME>/bin:>./clscfg -localpatch

#<GRID_HOME>/bin:>./clscfg -patch

#<GRID_HOME>/crs/install:> ./rootcrs.sh -lock