f Oracle RAC 12.2 on Linux 2020 第一季的Patch ~ 迪貝之家

Oracle RAC 12.2 on Linux 2020 第一季的Patch

才剛打上
12.1請參考 (文档 ID 1591616.1)
12.2請參考 (文档 ID 2246888.1)
For Grid Infrastructure Home, as home user:
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/30501932/30593149
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/30501932/30585969
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/30501932/30586063
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/30501932/26839277
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/30501932/30591794
For Database home, as home user:
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/30501932/30593149
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/grid/30501932/30585969
Execute the following on each node of the cluster in non-shared CRS and DB home environment to apply the patch.
1. Stop the CRS managed resources running from DB homes.
If this is a GI Home environment, as the database home owner execute:
$ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> -n <node name>
srvctl stop home -o $ORACLE_HOME -s /home/oracle/patch.txt -n gidha1
srvctl stop home -o $ORACLE_HOME -s /home/oracle/patch.txt -n gidha2
Note:
You need to make sure that the Oracle ACFS file systems are unmounted (see Section 2.8) and all other Oracle processes are shutdown before you proceed.
2. Run the pre root script.
this is a GI Home, as the root user execute:
# <GI_HOME>/crs/install/rootcrs.sh -prepatch
$ORACLE_HOME/crs/install/rootcrs.sh -prepatch
3. Patch GI home.
As the GI home owner execute:
$ <GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%OCW TRACKING BUG%
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /home/grid/30501932/30593149
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /home/grid/30501932/30585969
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /home/grid/30501932/30586063
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /home/grid/30501932/26839277
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /home/grid/30501932/30591794
4. Patch DB home.
注意事項
因oracle的Inventory與grid的Inventory住在一起,所以下面路徑檔案在打第四步Patch DB home的時候記得要先改為oracle:oinstall
打完DB的之後記得要改回來grid:oinstall,改完後才能在繼續往下
/u01/app/oraInventory/ContentsXML]$ ll
total 6
-rw-rw---- 1 grid oinstall 329 Jun 15 13:41 comps.xml
-rw-rw---- 1 grid oinstall 670 Jan 15 10:55 inventory.xml
-rw-rw---- 1 grid oinstall 292 Jun 15 13:41 libs.xml
As the database home owner execute:
$ <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%OCW TRACKING BUG%/custom/scripts/prepatch.sh -dbhome <ORACLE_HOME>
/home/grid/30501932/30585969/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
$ <ORACLE_HOME>/OPatch/opatch apply -oh <ORACLE_HOME> -local <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%OCW TRACKING BUG%
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /home/grid/30501932/30593149
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /home/grid/30501932/30585969
$ <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%OCW TRACKING BUG%/custom/scripts/postpatch.sh -dbhome <ORACLE_HOME>
/home/grid/30501932/30585969/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
5. Run the post script.
As the root user execute:
# <GI_HOME>/rdbms/install/rootadd_rdbms.sh
$ORACLE_HOME/rdbms/install/rootadd_rdbms.sh
If this is a GI Home, as the root user execute:
# <GI_HOME>/crs/install/rootcrs.pl -postpatch
$ORACLE_HOME/crs/install/rootcrs.sh -postpatch
If this is an Oracle Restart Home, as the root user execute:
6. If the message, "A system reboot is recommended before using ACFS is shown, then a reboot must be issued before continuing. Failure to do so will result in running with an unpatched ACFS\ADVM\OKS driver.
7. Start the CRS managed resources that were earlier running from DB homes.
If this is a GI Home environment, as the database home owner execute:
$ <ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location> -n <node name>
srvctl start home -o $ORACLE_HOME -s /home/oracle/patch.txt -n gidha1
srvctl start home -o $ORACLE_HOME -s /home/oracle/patch.txt -n gidha2
8. For each database instance running on the Oracle home being patched, run the datapatch utility as described in next table.
sqlplus / as sysdba
startup
quit
cd $ORACLE_HOME/OPatch
./datapatch -verbose
如果datapatch是空的,not apply
則需要手動處理 (請參考DOC 1955058.1)

會造成困擾的應該是底下這三個畫面
可以忽略
30501932

30501932
30501932

以後找RU 透過這份文件 2118136.2
Metalink 網站”Patch & Updates” 頁籤等同沒用