OPatch command

[檢查 OPatch 版本的指令]
#   $ORACLE_HOME/OPatch/opatch lsinventory -all  -invPtrLoc `find $ORACLE_HOME -name "*.loc"`
# version
# $ORACLE_HOME/OPatch/opatch version


# 命令列出已安装的CPU/PSU  有找有修正的bug
[ORACLLE]$  $ORACLE_HOME/OPatch/opatch lsinventory  -bugs_fixed -invPtrLoc `find $ORACLE_HOME -name "*.loc"`



# 上patch前檢查
[ORACLE]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ -invPtrLoc `find $ORACLE_HOME -name "*.loc"`
[ORACLE]$
# 上patch
[ORACLE]$  $ORACLE_HOME/OPatch/opatch apply -invPtrLoc `find $ORACLE_HOME -name "*.loc"`
[ORACLE]$
# 上patch 後檢查
[ORACLE]$   $ORACLE_HOME/OPatch/opatch lsinventory -invPtrLoc `find $ORACLE_HOME -name "*.loc"`
[ORACLE]$
# Rollback  斜體請自行調整
[ORACLE]$
[ORACLE]$ $ORACLE_HOME/OPatch/opatch rollback -id 12880299

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

#上傳 p12880299_112020_Linux-x86-64 至 /tmp/ora

[ORACLLE]$  unzip p12880299_112020_Linux-x86-64.zip

[ORACLLE]$  cd 12880299

# 

[ORACLLE]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

...

OPatch cannot find a valid oraInst.loc file to locate Central Inventory.

OPatch failed with error code 104

此動作若失敗的話改使用下一個動作

[ORACLLE]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ -invPtrLoc `find $ORACLE_HOME -name "*.loc"` 

# 上patch  apply

[ORACLLE]$  $ORACLE_HOME/OPatch/opatch apply -invPtrLoc `find $ORACLE_HOME -name "*.loc"` 

# 確認

[ORACLLE]$  $ORACLE_HOME/OPatch/opatch lsinventory -invPtrLoc `find $ORACLE_HOME -name "*.loc"`

11.2.0.1  BUG to  11.2.0.1.6

ORACLE
SQL > shutdown immediate ;

LSNRCTL
$>    lsnrctl sop

[ORACLE]$   unzip p12419378_11201_<platform>.zip
[ORACLE]$   $ORACLE_HOME/OPatch/opatch prereq prereq CheckConflictAgainstOHWithDetail -phBaseDir ./12419378

[ORACLE]$  cd 12419378
[ORACLE]$  $ORACLE_HOME/OPatch/opatch apply -invPtrLoc `find $ORACLE_HOME -name "*.loc"`

Download 19.3.2.0 ...

https://support.oracle.com/epmos/faces/PatchDetail?patchId=30087906&_adf.ctrl-state=g7e6t8pcu_4&_afrLoop=65846030867633