==================================【打补丁 RU19.19】

参考readme文件打补丁

 



 

替换opatch


export UNZIPPED_PATCH_LOCATION=/u01/soft/psu/35037840/



% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/psu/35037840/35042068

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/psu/35037840/35050331

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/psu/35037840/

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/psu/35037840/

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/psu/35037840/


================执行报错与解决

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/psu/35037840/35042068


执行报错：


/u01/app/19.0.0.0/grid/OPatch(+ASM1)>./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/psu/35037840/35042068

Oracle Interim Patch Installer version 12.2.0.1.39

Copyright (c) 2023, Oracle Corporation.  All rights reserved.


PREREQ session


Oracle Home       : /u01/app/19.0.0.0/grid

Central Inventory : /u01/app/oraInventory

  from           : /u01/app/19.0.0.0/grid/oraInst.loc

OPatch version    : 12.2.0.1.39

OUI version       : 12.2.0.7.0

Log file location : /u01/app/19.0.0.0/grid/cfgtoollogs/opatch/opatch2023-08-08_13-45-51PM_1.log


Invoking prereq "checkconflictagainstohwithdetail"

List of Homes on this system:


 Home name= OraDB19Home1, Location= "/u01/app/oracle/product/19.0.0.0/dbhome_1"

List of Homes on this system:


 Home name= OraDB19Home1, Location= "/u01/app/oracle/product/19.0.0.0/dbhome_1"

List of Homes on this system:


 Home name= OraDB19Home1, Location= "/u01/app/oracle/product/19.0.0.0/dbhome_1"


Prereq "checkConflictAgainstOHWithDetail" is not executed.

List of Homes on this system:


 Home name= OraDB19Home1, Location= "/u01/app/oracle/product/19.0.0.0/dbhome_1"

PrereqSession failed: RawInventory gets null OracleHomeInfo


OPatch failed with error code 2



解决：


/u01/app/oraInventory/ContentsXML


cat inventory.xml


xml version="1.0" standalone="yes" ?>

<!-- Copyright (c) 1999, 2023, Oracle and/or its affiliates.

All rights reserved. -->

<!-- Do not modify the contents of this file by hand. -->

<INVENTORY>

<VERSION_INFO>

  <SAVED_WITH>12.2.0.7.0</SAVED_WITH>

  <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>

</VERSION_INFO>

<HOME_LIST>

<HOME NAME="OraDB19Home1" LOC="/u01/app/oracle/product/19.0.0.0/dbhome_1" TYPE="O" IDX="1"/>

</HOME_LIST>

<COMPOSITEHOME_LIST>

</COMPOSITEHOME_LIST>

</INVENTORY>


--发现缺少GI信息


添加GI信息命令：

cd GI_HOME/oui/bin

[节点1：] 这里只演示节点1

./runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME="/u01/app/19.0.0.0/grid" ORACLE_HOME_NAME="OraGI19Home1" CLUSTER_NODES=rbet19cr1,rbet19cr2 CRS=true INVENTORY_LOCATION="/u01/app/oraInventory" LOCAL_NODE=rbet19cr1


[节点2：]

./runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME="/u01/app/19.0.0.0/grid" ORACLE_HOME_NAME="OraGI19Home1" CLUSTER_NODES=rbet19cr1,rbet19cr2 CRS=true INVENTORY_LOCATION="/u01/app/oraInventory" LOCAL_NODE=rbet19cr2




实操：

/u01/app/19.0.0.0/grid/oui/bin(+ASM1)>./runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME="/u01/app/19.0.0.0/grid" ORACLE_HOME_NAME="OraGI19Home1" CLUSTER_NODES=rbet19cr1,rbet19cr2 CRS=true INVENTORY_LOCATION="/u01/app/oraInventory" LOCAL_NODE=rbet19cr1


输出信息：

Starting Oracle Universal Installer...


Checking swap space: must be greater than 500 MB.   Actual 32756 MB    Passed


The inventory pointer is located at /var/opt/oracle/oraInst.loc

You can find the log of this install session at:

/u01/app/oraInventory/logs/AttachHome2023-08-08_02-42-28PM.log

Please execute the '/u01/app/oraInventory/orainstRoot.sh' script at the end of the session.

'AttachHome' was successful.


执行脚本：

/u01/app/19.0.0.0/grid/oui/bin # /u01/app/oraInventory/orainstRoot.sh


Changing permissions of /u01/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.


Changing groupname of /u01/app/oraInventory to oinstall.

The execution of the script is complete.


再查看：

/u01/app/oraInventory(+ASM1)>cd ContentsXML/

/u01/app/oraInventory/ContentsXML(+ASM1)>cat inventory.xml


<?xml version="1.0" standalone="yes" ?>

<!-- Copyright (c) 1999, 2023, Oracle and/or its affiliates.

All rights reserved. -->

<!-- Do not modify the contents of this file by hand. -->

<INVENTORY>

<VERSION_INFO>

  <SAVED_WITH>12.2.0.7.0</SAVED_WITH>

  <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>

</VERSION_INFO>

<HOME_LIST>

<HOME NAME="OraDB19Home1" LOC="/u01/app/oracle/product/19.0.0.0/dbhome_1" TYPE="O" IDX="1"/>

<HOME NAME="OraGI19Home1" LOC="/u01/app/19.0.0.0/grid" TYPE="O" IDX="2" CRS="true">

  <NODE_LIST>

     <NODE NAME="rbet19cr1"/>

     <NODE NAME="rbet19cr2"/>

  </NODE_LIST>

</HOME>

</HOME_LIST>

<COMPOSITEHOME_LIST>

</COMPOSITEHOME_LIST>

</INVENTORY>


===============================继续下一步


For Oracle home, as home user:

export UNZIPPED_PATCH_LOCATION=/u01/soft/psu/35037840/


% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/psu/35037840/35042068

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/psu/35037840/35050331




For Grid Infrastructure home, as home user:

Create file /tmp/patch_list_gihome.txt with the following content:

% cat /tmp/patch_list_gihome.txt

/u01/soft/psu/35037840/35042068

/u01/soft/psu/35037840/35050331

/u01/soft/psu/35037840/

/u01/soft/psu/35037840/

/u01/soft/psu/35037840/


Grid home:

% $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt




For Oracle home, as home user:

Create file /tmp/patch_list_dbhome.txt with the following content:

% cat /tmp/patch_list_dbhome.txt

/u01/soft/psu/35037840/35042068

/u01/soft/psu/35037840/35050331


Oracle home:

% $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt



----readme文档打补丁命令参考：

in both the 19c Grid home and the 19c DB homes:

#GRID_HOME/OPatch/opatchauto apply /u01/soft/psu/35037840 -analyze


# export PATH=$PATH:<oracle_home_path>/OPatch

To patch the Grid home and all Oracle RAC database homes of the same version:


# opatchauto apply /u01/soft/psu/35037840

To patch only the Grid home:


# opatchauto apply <UNZIPPED_PATCH_LOCATION>/35037840 -oh <GI_HOME>


=================


开始打补丁实操：


root用户下执行:


cd /u01/soft/psu/


/u01/app/19.0.0.0/grid/OPatch/opatchauto apply /u01/soft/psu/35037840 -oh /u01/app/19.0.0.0/grid

/u01/app/oracle/product/19.0.0.0/dbhome_1/OPatch/opatchauto apply /u01/soft/psu/35037840 -oh /u01/app/oracle/product/19.0.0.0/dbhome_1



验证:

opatch lspatches

opatch lsinventory



=================

无asm本地架构只需打35037840


lsof|grep $ORACLE_HOME