oracle 19c打补丁,Oracle 19c RAC打补丁过程避坑指南

#db回退/u01/app/ oracle/product/ 19.3.0/db_1/OPatch/opatchauto rollback/tmp/grid_path/ 30116789-oh /u01/app/ oracle/product/ 19.3.0/db_1

9. 小结

先打节点1，或2都行，没有强制要求先打节点1，习惯而已。补丁安装过程中可能会遇到各种权限问题及其它问题，后面针对遇到的问题都做了下记录，让后面的人少踩坑。

二、遇到的一些错误

错误No.1

Patch: /tmp/grid_path/30116789/30122149Log: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-09_17-44-51PM_1.logReason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: ApplySession failed in system modification phase... 'ApplySession::apply failed: java.io.IOException: oracle.sysman.oui.patch.PatchException: java.io.FileNotFoundException: /u01/app/oraInventory/ContentsXML/oui-patch.xml (Permission denied)'After fixing the cause of failure Run opatchauto resume

]OPATCHAUTO-68061: The orchestration engine failed.OPATCHAUTO-68061: The orchestration engine failed withreturncode 1OPATCHAUTO -68061: Checkthe logformore details.OPatchAuto failed.

OPatchauto sessioncompleted atMon Mar 917: 45: 312020Timetaken tocompletethe session1minute, 16seconds

opatchauto failedwitherrorcode 42

问题描述:

DB补丁安装过程中报出的权限不足，具体原因不明，没有深入去分析,19c打补丁过程中会遇到各种权限问题。

解决办法:

[ root@xydb8node1 ~] # chmod 777 /u01/app/oraInventory/ContentsXML/oui-patch.xml#resume是接着上次失败的地方继续安装的意思。[ root@xydb8node1 ~] # /u01/app/oracle/product/19.3.0/db_1/OPatch/opatchauto resume

错误No.2

2020-03-10 11:18:18.961 [CSSDMONITOR(150856)]CRS-8500: Oracle Clusterware CSSDMONITOR process is starting withoperating systemprocess ID1508562020-03-10T11: 18: 19.092125+ 08: 00Errorsinfile/u01/app/grid/diag/crs/xydb8node2/crs/ trace/ohasd.trc (incident= 41):CRS -6015[] [] [] [] [] [] [] [] [] [] [] []Incident details in: /u01/app/grid/diag/crs/xydb8node2/crs/incident/incdir_41/ohasd_i41.trc2020-03-1011: 18: 19.081[OHASD( 147218)]CRS -6015: OracleClusterware has experienced an internal error. Details at(:CLSGEN00100:) { 0: 0: 2} in/u01/app/grid/diag/crs/xydb8node2/crs/ trace/ohasd.trc.2020-03-1011: 18: 19.106[OHASD( 147218)]CRS -8505: OracleClusterware OHASD process withoperating systemprocess ID147218encountered internal errorCRS -06015

trace日志：/u01/app/grid/diag/crs/xydb8node2/crs/ trace/ohasd.trc截取部份错误日志，如下：

2020-03-1011: 18: 19.057:CRSSHARED: 4034262784: [ INFO] [F-ALGO]{ 0: 0: 2} getIpcPath returning(ADDRESS=(PROTOCOL=IPC)( KEY=OHASD_UI_SOCKET))2020-03-1011: 18: 19.058:GIPCXCPT: 4038465280: gipcInternalConnectSync: failedsyncrequest, addr 0x7f9c9405c720[ 000000000000b814] { gipcAddress : name'clsc://(ADDRESS=(PROTOCOL=ipc)(KEY=SYSTEM.evm.acceptor.auth)(GIPCID=00000000-00000000-0))', objFlags 0x0, addrFlags 0x4}, ret gipcretConnectionRefused ( 29)2020-03-1011: 18: 19.058:GIPCXCPT: 4038465280: gipcConnectSyncF [EvmConConnect : evmgipcio.c : 235]: EXCEPTION[ ret gipcretConnectionRefused ( 29) ] failedsyncconnectendp 0x7f9c9405b2a0[ 000000000000b80d] { gipcEndpoint : localAddr 'clsc://(ADDRESS=(PROTOCOL=ipc)(KEY=)(GIPCID=00000000-00000000-0))', remoteAddr 'clsc://(ADDRESS=(PROTOCOL=ipc)(KEY=SYSTEM.evm.acceptor.auth)(GIPCID=00000000-00000000-0))', numPend 0, numReady 0, numDone 0, numDead 1, numTransfer 0, objFlags 0x0, pidPeer 0, readyRef (nil), ready 1, wobj 0x7f9c9405e350, sendp 0x7f9c9405e100status13flags 0xa108871a, flags -20x0, usrFlags 0x30020}, addr 0x7f9c9405c720[ 000000000000b814] { gipcAddress : name'clsc://(ADDRESS=(PROTOCOL=ipc)(KEY=SYSTEM.evm.acceptor.auth)(GIPCID=00000000-00000000-0))', objFlags 0x0, addrFlags 0x4}, flags 0x80000002020-03-1011: 18: 19.058:UiServer: 4034262784: [ INFO] { 0: 0: 2} GIPC address: clsc://(ADDRESS=(PROTOCOL=IPC)( KEY=OHASD_UI_SOCKET))2020-03-1011: 18: 19.058: GIPC: 4034262784: sgipcnDSBindHelper: file/ var/tmp/.oracle/sOHASD_UI_SOCKET_lock islockedbyPID 1471622020-03-1011: 18: 19.058:GIPCXCPT: 4034262784: gipcmodNetworkProcessBind: failedtobind endp 0x7f9c8c000950[ 000000000000b819] { gipcEndpoint : localAddr