Ao tentar aplicar um patch no Grid Home recebi o erro “Errors occurred while operating oop temp file”:
$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.28
Copyright (c) 2021, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/11.2.0.4/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/11.2.0.4/grid/oraInst.loc
OPatch version : 11.2.0.3.28
OUI version : 11.2.0.4.0
Log file location : /u01/app/11.2.0.4/grid/cfgtoollogs/opatch/opatch2021-02-28_19-16-24PM_1.log
Verifying environment and performing prerequisite checks...
--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...
Errors occurred while operating oop temp file.
OPatch succeeded.
Pesquisando no MOS, achei uma nota 2624030.1 que sugere ser problema de permissão em dos seguintes diretórios:
- $GRID_HOME/oui
- $GRID_HOME/jdk
- $GRID_HOME/OPatch
Neste caso, todos os 3 diretórios estavam com as permissões corretas.
A dica do real problema veio ao tentar visualizar o arquivo de log do OPatch:
$ cat /u01/app/11.2.0.4/grid/cfgtoollogs/opatch/opatch2021-02-28_19-16-24PM_1.log
cat: /u01/app/11.2.0.4/grid/cfgtoollogs/opatch/opatch2021-02-28_19-16-24PM_1.log: No such file or directory
O arquivo não existia (mesmo o opatch informando que havia criado o arquivo), então decidi checar o diretório onde ele deveria criar o arquivo: /u01/app/11.2.0.4/grid/cfgtoollogs/opatch.
O diretório pertencia ao usuário oracle ao invés do usuário grid. Isso pode ter ocorrido após algum ajuste de permissão realizada anteriormente no servidor.
Para corrigir, apenas alterei o owner do diretório (com usuário root):
# chown -R grid.oinstall /u01/app/11.2.0.4/grid/cfgtoollogs/
Voltando ao OPatch com usuário grid, o mesmo passou da fase que gerava o erro:
$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.28
Copyright (c) 2021, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/11.2.0.4/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/11.2.0.4/grid/oraInst.loc
OPatch version : 11.2.0.3.28
OUI version : 11.2.0.4.0
Log file location : /u01/app/11.2.0.4/grid/cfgtoollogs/opatch/opatch2021-02-28_19-18-37PM_1.log
Verifying environment and performing prerequisite checks...
--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...
Oracle Interim Patch Installer version 11.2.0.3.28
Copyright (c) 2021, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/11.2.0.4/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/11.2.0.4/grid/oraInst.loc
OPatch version : 11.2.0.3.28
OUI version : 11.2.0.4.0
Log file location : /u01/app/11.2.0.4/grid/cfgtoollogs/opatch/opatch2021-02-28_19-18-45PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 17452638
Do you want to proceed? [y|n]