2024. 11. 4. 13:51 오라클
23ai RU 10월패치 23.6.0.24.10(37037086) 적용 테스트
23ai RU 10월패치 23.6.0.24.10(37037086) 적용 테스트
- OPatch Version 은 가장 최신인 12.2.0.1.44 필요
- 중간에 로그를 살펴보면 여유공간으로 /u01 엔진영역에 12G 정도가 더 필요하다.
- 소요시간은 5분 25초 소요
[Nov 4, 2024 1:17:16 PM] [INFO] Heap in use : 6 MB
Total memory: 184 MB
Free memory : 177 MB
Max memory : 3072 MB
[Nov 4, 2024 1:17:16 PM] [INFO] Oracle Home : /u01/app/oracle/product/23.0.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/23.0.0.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.44
OUI version : 12.2.0.9.0
OUI location : /u01/app/oracle/product/23.0.0.0/dbhome_1/oui
Log file location : /u01/app/oracle/product/23.0.0.0/dbhome_1/cfgtoollogs/opatch/opatch2024-11-04_13-17-15PM_1.log
[Nov 4, 2024 1:17:16 PM] [INFO] Patch history file: /u01/app/oracle/product/23.0.0.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
[Nov 4, 2024 1:17:18 PM] [INFO] [OPSR-TIME] Loading raw inventory
[Nov 4, 2024 1:17:18 PM] [INFO] [OPSR-MEMORY] Loaded all components from inventory. Heap memory in use: 16 (MB)
[Nov 4, 2024 1:17:18 PM] [INFO] [OPSR-MEMORY] Loaded all one offs from inventory. Heap memory in use: 16 (MB)
[Nov 4, 2024 1:17:18 PM] [INFO] [OPSR-TIME] Raw inventory loaded successfully
[Nov 4, 2024 1:17:18 PM] [INFO] NApply::no CAS enabled, OPatch runs with legacy process.
[Nov 4, 2024 1:17:18 PM] [INFO] Verifying environment and performing prerequisite checks...
[Nov 4, 2024 1:17:18 PM] [INFO] [OPSR-TIME] Running prerequisite checks
[Nov 4, 2024 1:17:18 PM] [INFO] opatch-external.jar is in /u01/app/oracle/product/23.0.0.0/dbhome_1/OPatch/jlib/opatch-external.jar
[Nov 4, 2024 1:17:21 PM] [INFO] OPatch invoked in CLI. Run Init Prereqs
[Nov 4, 2024 1:17:22 PM] [INFO] Running Initial prerequisite checks...
[Nov 4, 2024 1:17:24 PM] [INFO] Checking if Oracle Home has components required by patches...
[Nov 4, 2024 1:17:25 PM] [INFO] CheckMissingComps: Cached file does not exist or is invalid, re-build prereq result.
[Nov 4, 2024 1:17:25 PM] [INFO] [OPSR-TIME] Loading cooked inventory
[Nov 4, 2024 1:17:25 PM] [INFO] [OPSR-MEMORY] : Loading cooked one offs. Heap memory used 221 (MB)
[Nov 4, 2024 1:17:25 PM] [INFO] [OPSR-MEMORY] : Loaded cooked oneoffs. Heap memory used : 221 (MB)
[Nov 4, 2024 1:17:25 PM] [INFO] [OPSR-TIME] Cooked inventory loaded successfully
[Nov 4, 2024 1:17:25 PM] [INFO] Checking conflict among patches...
[Nov 4, 2024 1:17:25 PM] [INFO] Running prereq checkConflictAmongPatchesWithDetail
[Nov 4, 2024 1:17:25 PM] [INFO] Following patches can be applied: 37037086
[Nov 4, 2024 1:17:25 PM] [INFO] Following patches are not required:
[Nov 4, 2024 1:17:25 PM] [INFO] Following patches are auto rollbackable:
[Nov 4, 2024 1:17:25 PM] [INFO] Finished checking prereq checkConflictAmongPatchesWithDetail
[Nov 4, 2024 1:17:25 PM] [INFO] Conflict checking amongst patches PASSED
[Nov 4, 2024 1:17:25 PM] [INFO] Checking conflicts against Oracle Home...
[Nov 4, 2024 1:17:25 PM] [INFO] Running prereq checkConflictAgainstOHWithDetail
[Nov 4, 2024 1:17:26 PM] [INFO] Following patches can be applied: 37037086
[Nov 4, 2024 1:17:26 PM] [INFO] Following patches are not required:
[Nov 4, 2024 1:17:26 PM] [INFO] Following patches are auto rollbackable:
[Nov 4, 2024 1:17:26 PM] [INFO] Finished checking prereq checkConflictAgainstOHWithDetail
[Nov 4, 2024 1:17:28 PM] [INFO] Running prerequisite checks...
[Nov 4, 2024 1:17:28 PM] [INFO] Space Needed : 11630.222MB
[Nov 4, 2024 1:17:28 PM] [INFO] Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 37037086
[Nov 4, 2024 1:17:28 PM] [INFO] OPatch/jre does not exist. Adding /u01/app/oracle/product/23.0.0.0/dbhome_1/jdk/bin/java to oop dependency list
- 패치 적용
[CDB1]oracle@23ai:/oradata/install# opatch apply ./37037086/
Oracle Interim Patch Installer version 12.2.0.1.44
Copyright (c) 2024, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/23.0.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/23.0.0.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.44
OUI version : 12.2.0.9.0
Log file location : /u01/app/oracle/product/23.0.0.0/dbhome_1/cfgtoollogs/opatch/opatch2024-11-04_13-17-15PM_1.log
Verifying environment and performing prerequisite checks...
--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...
Oracle Interim Patch Installer version 12.2.0.1.44
Copyright (c) 2024, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/23.0.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/23.0.0.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.44
OUI version : 12.2.0.9.0
Log file location : /u01/app/oracle/product/23.0.0.0/dbhome_1/cfgtoollogs/opatch/opatch2024-11-04_13-17-31PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 37037086
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/23.0.0.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '37037086' to OH '/u01/app/oracle/product/23.0.0.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.client, 23.0.0.0.0 ] , [ oracle.companionCD.db, 23.0.0.0.0 ] , [ oracle.dbjava.dev, 23.0.0.0.0 ] , [ oracle.dslm, 23.0.0.0.0 ] , [ oracle.has.client.cvu, 23.0.0.0.0 ] , [ oracle.ldap.companion, 23.0.0.0.0 ] , [ oracle.mgw.common.companion, 23.0.0.0.0 ] , [ oracle.network.cman, 23.0.0.0.0 ] , [ oracle.network.gsm, 23.0.0.0.0 ] , [ oracle.nlsrtl.companion, 23.0.0.0.0 ] , [ oracle.odbc.companion, 23.0.0.0.0 ] , [ oracle.oraolap.mgmt, 23.0.0.0.0 ] , [ oracle.pg4appc, 23.0.0.0.0 ] , [ oracle.pg4mq, 23.0.0.0.0 ] , [ oracle.precomp.companion, 23.0.0.0.0 ] , [ oracle.rdbms.companion, 23.0.0.0.0 ] , [ oracle.rdbms.ic, 23.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 23.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 23.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 23.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 23.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 23.0.0.0.0 ] , [ oracle.sdo.companion, 23.0.0.0.0 ] , [ oracle.sqlj, 23.0.0.0.0 ] , [ oracle.sqlj.companion, 23.0.0.0.0 ] , [ oracle.sqlplus.companion, 23.0.0.0.0 ] , [ oracle.tg, 23.0.0.0.0 ] , [ oracle.xdk.companion, 23.0.0.0.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.assistants.acf, 23.0.0.0.0...
Patching component oracle.assistants.deconfig, 23.0.0.0.0...
Patching component oracle.assistants.netca.client, 23.0.0.0.0...
Patching component oracle.assistants.server, 23.0.0.0.0...
Patching component oracle.bali.ewt, 12.2.1.0.0...
Patching component oracle.bali.ice, 6.1.3.2.0...
Patching component oracle.bali.jewt, 11.1.1.1.0...
Patching component oracle.bali.share, 12.2.1.0.0...
Patching component oracle.blaslapack, 23.0.0.0.0...
Patching component oracle.buildtools.common, 23.0.0.0.0...
Patching component oracle.buildtools.rsf, 23.0.0.0.0...
Patching component oracle.crypto.fips, 23.0.0.0.0...
Patching component oracle.crypto.ojmisc, 23.0.0.0.0...
Patching component oracle.crypto.pki, 23.0.0.0.0...
Patching component oracle.crypto.rsa, 23.0.0.0.0...
Patching component oracle.crypto.rsf, 23.0.0.0.0...
Patching component oracle.ctx, 23.0.0.0.0...
Patching component oracle.ctx.atg, 23.0.0.0.0...
Patching component oracle.ctx.companion, 23.0.0.0.0...
Patching component oracle.ctx.rsf, 23.0.0.0.0...
Patching component oracle.dbdev, 23.0.0.0.0...
Patching component oracle.dbjava.ic, 23.0.0.0.0...
Patching component oracle.dbjava.jdbc, 23.0.0.0.0...
Patching component oracle.dbjava.server, 23.0.0.0.0...
Patching component oracle.dbjava.ucp, 23.0.0.0.0...
Patching component oracle.dbtoolslistener, 23.0.0.0.0...
Patching component oracle.hadoopcore, 23.0.0.0.0...
Patching component oracle.has.common, 23.0.0.0.0...
Patching component oracle.has.common.cvu, 23.0.0.0.0...
Patching component oracle.has.db, 23.0.0.0.0...
Patching component oracle.has.db.cvu, 23.0.0.0.0...
Patching component oracle.has.rsf, 23.0.0.0.0...
Patching component oracle.help.ohj, 11.1.2.0.0...
Patching component oracle.help.share, 11.1.2.0.0...
Patching component oracle.install.deinstalltool, 23.0.0.0.0...
Patching component oracle.javavm.client, 23.0.0.0.0...
Patching component oracle.javavm.companion, 23.0.0.0.0...
Patching component oracle.javavm.server, 23.0.0.0.0...
Patching component oracle.javavhttp://m.server.core, 23.0.0.0.0...
Patching component oracle.jdk, 11.0.24.7.0...
Patching component oracle.ldap.admin, 23.0.0.0.0...
Patching component oracle.ldap.client, 23.0.0.0.0...
Patching component oracle.ldap.rsf, 23.0.0.0.0...
Patching component oracle.mgw.common, 23.0.0.0.0...
Patching component oracle.network, 23.0.0.0.0...
Patching component oracle.network.aso, 23.0.0.0.0...
Patching component oracle.network.client, 23.0.0.0.0...
Patching component oracle.network.listener, 23.0.0.0.0...
Patching component oracle.network.netmgr, 23.0.0.0.0...
Patching component oracle.network.rsf, 23.0.0.0.0...
Patching component oracle.nlsrtl.rsf, 23.0.0.0.0...
Patching component oracle.nlsrtl.rsf.core, 23.0.0.0.0...
Patching component oracle.nlsrtl.rsf.ic, 23.0.0.0.0...
Patching component oracle.nlsrtl.rsf.lbuilder, 23.0.0.0.0...
Patching component oracle.odbc, 23.0.0.0.0...
Patching component oracle.odbc.ic, 23.0.0.0.0...
Patching component oracle.onnx, 23.0.0.0.0...
Patching component oracle.ons, 23.0.0.0.0...
Patching component oracle.ons.core, 23.0.0.0.0...
Patching component oracle.ons.ic, 23.0.0.0.0...
Patching component oracle.options, 23.0.0.0.0...
Patching component oracle.oracler.server, 23.0.0.0.0...
Patching component oracle.oracore.rsf, 23.0.0.0.0...
Patching component oracle.oracore.rsf.core, 23.0.0.0.0...
Patching component oracle.oraml.server, 23.0.0.0.0...
Patching component oracle.oraolap, 23.0.0.0.0...
Patching component oracle.oraolap.api, 23.0.0.0.0...
Patching component oracle.oraolap.dbscripts, 23.0.0.0.0...
Patching component oracle.ordim.client, 23.0.0.0.0...
Patching component oracle.ordim.server, 23.0.0.0.0...
Patching component oracle.ovm, 23.0.0.0.0...
Patching component oracle.perlint, 5.38.2.0.0...
Patching component oracle.precomp.common, 23.0.0.0.0...
Patching component oracle.precomp.common.core, 23.0.0.0.0...
Patching component oracle.precomp.lang, 23.0.0.0.0...
Patching component oracle.precomp.rsf, 23.0.0.0.0...
Patching component oracle.python, 3.12.3.0.0...
Patching component oracle.rdbms, 23.0.0.0.0...
Patching component oracle.rdbms.crs, 23.0.0.0.0...
Patching component oracle.rdbms.db, 23.0.0.0.0...
Patching component oracle.rdbms.dbcur, 23.0.0.0.0...
Patching component oracle.rdbms.dbscripts, 23.0.0.0.0...
Patching component oracle.rdbms.deconfig, 23.0.0.0.0...
Patching component oracle.rdbms.dm, 23.0.0.0.0...
Patching component oracle.rdbms.dv, 23.0.0.0.0...
Patching component oracle.rdbms.hs_common, 23.0.0.0.0...
Patching component oracle.rdbms.hsodbc, 23.0.0.0.0...
Patching component oracle.rdbms.install.common, 23.0.0.0.0...
Patching component oracle.rdbms.install.plugins, 23.0.0.0.0...
Patching component oracle.rdbms.install.seeddb, 23.0.0.0.0...
Patching component oracle.rdbms.lbac, 23.0.0.0.0...
Patching component oracle.rdbms.locator, 23.0.0.0.0...
Patching component oracle.rdbms.oci, 23.0.0.0.0...
Patching component oracle.rdbms.olap, 23.0.0.0.0...
Patching component oracle.rdbms.plsql, 23.0.0.0.0...
Patching component oracle.rdbms.rat, 23.0.0.0.0...
Patching component oracle.rdbms.rman, 23.0.0.0.0...
Patching component oracle.rdbms.rsf, 23.0.0.0.0...
Patching component oracle.rdbms.rsf.ic, 23.0.0.0.0...
Patching component oracle.rdbms.scheduler, 23.0.0.0.0...
Patching component oracle.rdbms.util, 23.0.0.0.0...
Patching component oracle.rhp.common, 23.0.0.0.0...
Patching component oracle.rhp.db, 23.0.0.0.0...
Patching component oracle.rsf, 23.0.0.0.0...
Patching component oracle.sdo, 23.0.0.0.0...
Patching component oracle.sdo.locator, 23.0.0.0.0...
Patching component oracle.sdo.locator.jrf, 23.0.0.0.0...
Patching component oracle.server, 23.0.0.0.0...
Patching component oracle.slax.rsf, 23.0.0.0.0...
Patching component oracle.sqlj.sqljruntime, 23.0.0.0.0...
Patching component oracle.sqlplus, 23.0.0.0.0...
Patching component oracle.sqlplus.ic, 23.0.0.0.0...
Patching component oracle.sqlplus.rsf, 23.0.0.0.0...
Patching component oracle.tfa.db, 23.0.0.0.0...
Patching component oracle.usm.deconfig, 23.0.0.0.0...
Patching component oracle.wwg.plsql, 23.0.0.0.0...
Patching component oracle.xdk, 23.0.0.0.0...
Patching component oracle.xdk.parser.java, 23.0.0.0.0...
Patching component oracle.xdk.rsf, 23.0.0.0.0...
Patching component oracle.xdk.server, 23.0.0.0.0...
Patching component oracle.xdk.xquery, 23.0.0.0.0...
Patch 37037086 successfully applied.
Log file location: /u01/app/oracle/product/23.0.0.0/dbhome_1/cfgtoollogs/opatch/opatch2024-11-04_13-17-31PM_1.log
OPatch succeeded.
[CDB1]oracle@23ai:/home/oracle# opatch lspatches
37037086;Database Release Update : 23.6.0.24.10 (37037086)
OPatch succeeded.
- datapatch 적용
[CDB1]oracle@23ai:/u01/app/oracle/product/23.0.0.0/dbhome_1/OPatch# ./datapatch -verbose
SQL Patching tool version 23.6.0.24.10 Lim on Mon Nov 4 13:36:47 2024
Copyright (c) 2012, 2024, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/product/23.0.0.0/dbhome_1/cfgtoollogs/sqlpatch/sqlpatch_sid_CDB1_ts_2024_11_04_13_36_47_pid_10845/sqlpatch_invocation.log
Connecting to database...OK
Gathering database info...done
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of interim SQL patches:
No interim patches found
Current state of release update SQL patches:
Binary registry:
23.6.0.24.10 Release_Update 241010183751: Installed
PDB CDB$ROOT:
Applied 23.5.0.24.07 Release_Update 241010183751 successfully on
PDB PDB$SEED:
Applied 23.5.0.24.07 Release_Update 241010183751 successfully on
PDB PDB1:
Applied 23.5.0.24.07 Release_Update 241010183751 successfully on
Adding patches to installation queue and performing prereq checks...done
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED PDB1
No interim patches need to be rolled back
Patch 37037086 (Database Release Update : 23.6.0.24.10 (37037086)):
Apply from 23.5.0.24.07 Release_Update 241010183751 to 23.6.0.24.10 Release_Update 241010183751
No interim patches need to be applied
Installing patches...
Patch installation complete. Total patches installed: 3
Validating logfiles...done
Patch 37037086 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/product/23.0.0.0/dbhome_1/cfgtoollogs/sqlpatch/sqlpatch_sid_CDB1_ts_2024_11_04_13_36_47_pid_10845/37037086_apply_CDB1_CDBROOT_2024Nov04_13_37_02.log (no errors)
Patch 37037086 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/product/23.0.0.0/dbhome_1/cfgtoollogs/sqlpatch/sqlpatch_sid_CDB1_ts_2024_11_04_13_36_47_pid_10845/37037086_apply_CDB1_PDBSEED_2024Nov04_13_39_36.log (no errors)
Patch 37037086 apply (pdb PDB1): SUCCESS
logfile: /u01/app/oracle/product/23.0.0.0/dbhome_1/cfgtoollogs/sqlpatch/sqlpatch_sid_CDB1_ts_2024_11_04_13_36_47_pid_10845/37037086_apply_CDB1_PDB1_2024Nov04_13_39_36.log (no errors)
SQL Patching tool complete on Mon Nov 4 13:42:36 2024
- DBA_REGISTRY_SQLPATCH 적용 확인
SQL>
SET LINESIZE 400
COLUMN ACTION_TIME FORMAT A20
COLUMN ACTION FORMAT A10
COLUMN STATUS FORMAT A10
COLUMN DESCRIPTION FORMAT A40
COLUMN VERSION FORMAT A10
COLUMN BUNDLE_SERIES FORMAT A10
SELECT TO_CHAR(ACTION_TIME, 'YYYYMMDD HH24:MI:SS') AS ACTION_TIME
,ACTION
,STATUS
,DESCRIPTION
,PATCH_ID
FROM DBA_REGISTRY_SQLPATCH
ORDER BY ACTION_TIME;
ACTION_TIME ACTION STATUS DESCRIPTION PATCH_ID
-------------------- ---------- ---------- ---------------------------------------- ----------
20241104 13:38:42 APPLY END Database Release Update : 23.6.0.24.10 ( 37037086
37037086)
