2025. 11. 12. 10:12 오라클
No read or write permission to ORACLE_HOME/.patch_storage
작업 환경은 19c singleASM 사용
19.3 -> 19.29 로 Opatch 패치작업중 아래와 같은 에러 발생
-> GI_HOME 쪽은 에러없이 잘 진행됨, $ORACLE_HOME 진행시 Error
OPatchSession cannot load inventory for the given Oracle Home /u01/app/oracle/product/19.0.0.0/dbhome_1. Possible causes are:
No read or write permission to ORACLE_HOME/.patch_storage
Central Inventory is locked by another OUI instance
No read permission to Central Inventory
The lock file exists in ORACLE_HOME/.patch_storage
The Oracle Home does not exist in Central Inventory
검색해보면 아래와 같은 문제 등이 제시되는데
1.ORACLE_HOME/.patch_storage 디렉토리가 없거나
2. . patch_storage 밑에 patch_locked 화일이 있으면 lck 화일 지우기
3. Clone 작업했으면 백업받고 다시 깔아라..
전부 해당되지 않았다.
내 경우에는 황당하게도 Inventory 내에 ORACLE_HOME 이 등록되어 있지 않았다. (이유는 모름??)
-> 없어서 추가 시켜줌
-> 패치하려고 했는데 Invenrory 내에 $ORACLE_HOME 정보가 없어서 그냥 안됐던 것.
vi /u01/app/oraInventory/ContentsXML/inventory.xml
<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 1999, 2025, 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="OraGI19Home1" LOC="/u01/app/19.0.0.0/grid" TYPE="O" IDX="1"/>
<HOME NAME="OraDB19Home1" LOC="/u01/app/oracle/product/19.0.0.0/dbhome_1" TYPE="O" IDX="2"/>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>
추가 후 재진행..정상적으로 완료됨
./38298204/38322923/custom/scripts/prepatch.sh completed successfully.
Oracle Interim Patch Installer version 12.2.0.1.47
Copyright (c) 2025, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/19.0.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.0.0.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.47
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0.0/dbhome_1/cfgtoollogs/opatch/opatch2025-11-12_09-53-46AM_1.log
Verifying environment and performing prerequisite checks...
--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...
Oracle Interim Patch Installer version 12.2.0.1.47
Copyright (c) 2025, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/19.0.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.0.0.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.47
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0.0/dbhome_1/cfgtoollogs/opatch/opatch2025-11-12_09-53-55AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 38322923
Do you want to proceed? [y|n]
