1 19c补丁 36233263 / 36240578 之前的记录
2 [oracle@rhel799:/home/oracle]$ cd /soft/36233263/
3 --应用patch
4 [oracle@rhel799:/soft/36233263]$ opatch apply
5 Oracle Interim Patch Installer version 12.2.0.1.32
6 Copyright (c) 2025, Oracle Corporation. All rights reserved.
7 Oracle Home : /u01/app/oracle/product/19.3.0/db
8 Central Inventory : /u01/app/oraInventory
9 from : /u01/app/oracle/product/19.3.0/db/oraInst.loc
10 --当前OPatch版本号32
11 OPatch version : 12.2.0.1.32
12 OUI version : 12.2.0.7.0
13 Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2025-12-30_22-40-06PM_1.log
14 Verifying environment and performing prerequisite checks...
15 Prerequisite check "CheckMinimumOPatchVersion" failed.
16 The details are:
17 The OPatch being used is version 12.2.0.1.32 while the following patch(es) require higher versions:
18 --此补丁需要至少41版本的OPatch工具
19 Patch 36233263 requires OPatch version 12.2.0.1.41 or later.
20 Please download the latest OPatch from My Oracle Support.
21 UtilSession failed: Prerequisite check "CheckMinimumOPatchVersion" failed.
22 Log file location: /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2025-12-30_22-40-06PM_1.log
23 OPatch failed with error code 73
24 [oracle@rhel799:/soft/36233263]$
25
26 --删除原来的OPatch重新上传高版本的OPatch工具
27 [oracle@rhel799:/soft/36233263]$ opatch apply
28 Oracle Interim Patch Installer version 12.2.0.1.46
29 Copyright (c) 2025, Oracle Corporation. All rights reserved.
30 Oracle Home : /u01/app/oracle/product/19.3.0/db
31 Central Inventory : /u01/app/oraInventory
32 from : /u01/app/oracle/product/19.3.0/db/oraInst.loc
33 OPatch version : 12.2.0.1.46
34 OUI version : 12.2.0.7.0
35 Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2025-12-31_00-41-21AM_1.log
36 Verifying environment and performing prerequisite checks...
37 OPatch continues with these patches: 36233263
38 --选择输入Y
39 Do you want to proceed? [y|n]
40 y
41 User Responded with: Y
42 All checks passed.
43
44 Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
45 (Oracle Home = '/u01/app/oracle/product/19.3.0/db')
46 --选择输入Y，等待应用
47 Is the local system ready for patching? [y|n]
48 y
49 User Responded with: Y
50 Backing up files...
51 Applying interim patch '36233263' to OH '/u01/app/oracle/product/19.3.0/db'
52 ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.crypto.rsf, 19.0.0.0.0 ] , [ oracle.pg4mq, 19.0.0.0.0 ] , [ oracle.precomp.companion, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ] not present in the Oracle Home or a higher version is found.
53 Patching component oracle.rdbms.rsf, 19.0.0.0.0...
54 Patching component oracle.rdbms.util, 19.0.0.0.0...
55 Patching component oracle.rdbms, 19.0.0.0.0...
56 Patching component oracle.assistants.acf, 19.0.0.0.0...
57 Patching component oracle.assistants.deconfig, 19.0.0.0.0...
58 Patching component oracle.assistants.server, 19.0.0.0.0...
59 Patching component oracle.blaslapack, 19.0.0.0.0...
60 Patching component oracle.buildtools.rsf, 19.0.0.0.0...
61 Patching component oracle.ctx, 19.0.0.0.0...
62 Patching component oracle.dbdev, 19.0.0.0.0...
63 Patching component oracle.dbjava.ic, 19.0.0.0.0...
64 Patching component oracle.dbjava.jdbc, 19.0.0.0.0...
65 Patching component oracle.dbjava.ucp, 19.0.0.0.0...
66 Patching component oracle.duma, 19.0.0.0.0...
67 Patching component oracle.javavm.client, 19.0.0.0.0...
68 Patching component oracle.ldap.owm, 19.0.0.0.0...
69 Patching component oracle.ldap.rsf, 19.0.0.0.0...
70 Patching component oracle.ldap.security.osdt, 19.0.0.0.0...
71 Patching component oracle.marvel, 19.0.0.0.0...
72 Patching component oracle.network.rsf, 19.0.0.0.0...
73 Patching component oracle.odbc.ic, 19.0.0.0.0...
74 Patching component oracle.ons, 19.0.0.0.0...
75 Patching component oracle.ons.ic, 19.0.0.0.0...
76 Patching component oracle.oracore.rsf, 19.0.0.0.0...
77 Patching component oracle.perlint, 5.28.1.0.0...
78 Patching component oracle.precomp.common.core, 19.0.0.0.0...
79 Patching component oracle.precomp.rsf, 19.0.0.0.0...
80 Patching component oracle.rdbms.crs, 19.0.0.0.0...
81 Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...
82 Patching component oracle.rdbms.deconfig, 19.0.0.0.0...
83 Patching component oracle.rdbms.oci, 19.0.0.0.0...
84 Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0...
85 Patching component oracle.rdbms.scheduler, 19.0.0.0.0...
86 Patching component oracle.rhp.db, 19.0.0.0.0...
87 Patching component oracle.rsf, 19.0.0.0.0...
88 Patching component oracle.sdo, 19.0.0.0.0...
89 Patching component oracle.sdo.locator.jrf, 19.0.0.0.0...
90 Patching component oracle.sqlplus, 19.0.0.0.0...
91 Patching component oracle.sqlplus.ic, 19.0.0.0.0...
92 Patching component oracle.wwg.plsql, 19.0.0.0.0...
93 Patching component oracle.xdk.rsf, 19.0.0.0.0...
94 Patching component oracle.rdbms.hsodbc, 19.0.0.0.0...
95 Patching component oracle.ldap.client, 19.0.0.0.0...
96 Patching component oracle.rdbms.rman, 19.0.0.0.0...
97 Patching component oracle.rdbms.dv, 19.0.0.0.0...
98 Patching component oracle.xdk.parser.java, 19.0.0.0.0...
99 Patching component oracle.ldap.rsf.ic, 19.0.0.0.0...
100 Patching component oracle.oraolap.api, 19.0.0.0.0...
101 Patching component oracle.javavm.server, 19.0.0.0.0...
102 Patching component oracle.mgw.common, 19.0.0.0.0...
103 Patching component oracle.xdk, 19.0.0.0.0...
104 Patching component oracle.odbc, 19.0.0.0.0...
105 Patching component oracle.xdk.xquery, 19.0.0.0.0...
106 Patching component oracle.nlsrtl.rsf, 19.0.0.0.0...
107 Patching component oracle.rdbms.lbac, 19.0.0.0.0...
108 Patching component oracle.network.client, 19.0.0.0.0...
109 Patching component oracle.network.listener, 19.0.0.0.0...
110 Patching component oracle.install.deinstalltool, 19.0.0.0.0...
111 Patching component oracle.ctx.atg, 19.0.0.0.0...
112 Patching component oracle.nlsrtl.rsf.core, 19.0.0.0.0...
113 Patching component oracle.nlsrtl.rsf.ic, 19.0.0.0.0...
114 Patching component oracle.nlsrtl.rsf, 19.0.0.0.0...
115 Patching component oracle.rdbms.install.common, 19.0.0.0.0...
116 Patching component oracle.oraolap.dbscripts, 19.0.0.0.0...
117 Patching component oracle.sdo.locator, 19.0.0.0.0...
118 Patching component oracle.rdbms.drdaas, 19.0.0.0.0...
119 Patching component oracle.nlsrtl.rsf.lbuilder, 19.0.0.0.0...
120 Patching component oracle.oraolap, 19.0.0.0.0...
121 Patching component oracle.ovm, 19.0.0.0.0...
122 Patching component oracle.rdbms.hs_common, 19.0.0.0.0...
123 Patching component oracle.ctx.rsf, 19.0.0.0.0...
124 Patching component oracle.dbtoolslistener, 19.0.0.0.0...
125 Patching component oracle.ldap.ssl, 19.0.0.0.0...
126 Patching component oracle.rdbms.install.plugins, 19.0.0.0.0...
127 Patching component oracle.precomp.common, 19.0.0.0.0...
128 Patching component oracle.precomp.lang, 19.0.0.0.0...
129 Patching component oracle.jdk, 1.8.0.201.0...
130 Patch 36233263 successfully applied.
131 Sub-set patch [29517242] has become inactive due to the application of a super-set patch [36233263].
132 Please refer to Doc ID 2161861.1 for any possible further required actions.
133 Log file location: /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2025-12-31_00-41-21AM_1.log
134 --成功应用
135 OPatch succeeded.
136 [oracle@rhel799:/soft/36233263]$
137
138 --36240578补丁
139 [oracle@rhel799:/home/oracle]$ ll /soft/36240578
140 total 192
141 drwxr-xr-x 3 oracle oinstall 21 Apr 12 2024 custom
142 drwxr-xr-x 3 oracle oinstall 20 Apr 12 2024 etc
143 drwxr-xr-x 21 oracle oinstall 234 Apr 12 2024 files
144 -rw-r--r-- 1 oracle oinstall 192698 Apr 12 2024 README.txt
145 [oracle@rhel799:/home/oracle]$ cd /soft/36240578/
146 --补丁应用
147 [oracle@rhel799:/soft/36240578]$ opatch apply
148 Oracle Interim Patch Installer version 12.2.0.1.46
149 Copyright (c) 2026, Oracle Corporation. All rights reserved.
150 Oracle Home : /u01/app/oracle/product/19.3.0/db
151 Central Inventory : /u01/app/oraInventory
152 from : /u01/app/oracle/product/19.3.0/db/oraInst.loc
153 OPatch version : 12.2.0.1.46
154 OUI version : 12.2.0.7.0
155 Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2026-01-03_20-07-02PM_1.log
156 Verifying environment and performing prerequisite checks...
157
158 --------------------------------------------------------------------------------
159 Start OOP by Prereq process.
160 Launch OOP...
161 Oracle Interim Patch Installer version 12.2.0.1.46
162 Copyright (c) 2026, Oracle Corporation. All rights reserved.
163 Oracle Home : /u01/app/oracle/product/19.3.0/db
164 Central Inventory : /u01/app/oraInventory
165 from : /u01/app/oracle/product/19.3.0/db/oraInst.loc
166 OPatch version : 12.2.0.1.46
167 OUI version : 12.2.0.7.0
168 Log file location : /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2026-01-03_20-07-54PM_1.log
169 Verifying environment and performing prerequisite checks...
170 OPatch continues with these patches: 36240578
171 --选择输入Y
172 Do you want to proceed? [y|n]
173 y
174 User Responded with: Y
175 All checks passed.
176 Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
177 (Oracle Home = '/u01/app/oracle/product/19.3.0/db')
178 --选择输入Y
179 Is the local system ready for patching? [y|n]
180 y
181 User Responded with: Y
182 Backing up files...
183 Applying interim patch '36240578' to OH '/u01/app/oracle/product/19.3.0/db'
184 ApplySession: Optional component(s) [ oracle.xag, 19.0.0.0.0 ] , [ oracle.rhp.crs, 19.0.0.0.0 ] , [ oracle.has.crs.cvu, 19.0.0.0.0 ] , [ oracle.has.crs, 19.0.0.0.0 ] , [ oracle.has.cvu, 19.0.0.0.0 ] not present in the Oracle Home or a higher version is found.
185 Patching component oracle.rdbms, 19.0.0.0.0...
186 Patching component oracle.has.rsf, 19.0.0.0.0...
187 Patching component oracle.has.db, 19.0.0.0.0...
188 Patching component oracle.rhp.db, 19.0.0.0.0...
189 Patching component oracle.has.db.cvu, 19.0.0.0.0...
190 Patching component oracle.has.common, 19.0.0.0.0...
191 Patching component oracle.has.common.cvu, 19.0.0.0.0...
192 Patching component oracle.rhp.common, 19.0.0.0.0...
193 Patch 36240578 successfully applied.
194 Sub-set patch [29585399] has become inactive due to the application of a super-set patch [36240578].
195 Please refer to Doc ID 2161861.1 for any possible further required actions.
196 Log file location: /u01/app/oracle/product/19.3.0/db/cfgtoollogs/opatch/opatch2026-01-03_20-07-54PM_1.log
197 --成功应用
198 OPatch succeeded.
199 [oracle@rhel799:/soft/36240578]$
200
201 --启动DB
202 SYS@ora19c SQL> startup
203 ORACLE instance started.
204 Total System Global Area 5351928912 bytes
205 Fixed Size 8950864 bytes
206 Variable Size 905969664 bytes
207 Database Buffers 4429185024 bytes
208 Redo Buffers 7823360 bytes
209 Database mounted.
210 Database opened.
211 SYS@ora19c SQL>
212 --utlrp执行
213 SYS@ora19c SQL> @?/rdbms/admin/utlrp.sql
214 Session altered.
215 TIMESTAMP
216 ----------------------------------------------------------------------------------------------------
217 COMP_TIMESTAMP UTLRP_BGN 2025-12-31 01:47:33
218
219 DOC> The following PL/SQL block invokes UTL_RECOMP to recompile invalid
220 DOC> objects in the database. Recompilation time is proportional to the
221 DOC> number of invalid objects in the database, so this command may take
222 DOC> a long time to execute on a database with a large number of invalid
223 DOC> objects.
224 DOC>
225 DOC> Use the following queries to track recompilation progress:
226 DOC>
227 DOC> 1. Query returning the number of invalid objects remaining. This
228 DOC> number should decrease with time.
229 DOC> SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);
230 DOC>
231 DOC> 2. Query returning the number of objects compiled so far. This number
232 DOC> should increase with time.
233 DOC> SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
234 DOC>
235 DOC> This script automatically chooses serial or parallel recompilation
236 DOC> based on the number of CPUs available (parameter cpu_count) multiplied
237 DOC> by the number of threads per CPU (parameter parallel_threads_per_cpu).
238 DOC> On RAC, this number is added across all RAC nodes.
239 DOC>
240 DOC> UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel
241 DOC> recompilation. Jobs are created without instance affinity so that they
242 DOC> can migrate across RAC nodes. Use the following queries to verify
243 DOC> whether UTL_RECOMP jobs are being created and run correctly:
244 DOC>
245 DOC> 1. Query showing jobs created by UTL_RECOMP
246 DOC> SELECT job_name FROM dba_scheduler_jobs
247 DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';
248 DOC>
249 DOC> 2. Query showing UTL_RECOMP jobs that are running
250 DOC> SELECT job_name FROM dba_scheduler_running_jobs
251 DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';
252 DOC>#
253
254 PL/SQL procedure successfully completed.
255 TIMESTAMP
256 ----------------------------------------------------------------------------------------------------
257 COMP_TIMESTAMP UTLRP_END 2025-12-31 01:47:36
258
259 DOC> The following query reports the number of invalid objects.
260 DOC>
261 DOC> If the number is higher than expected, please examine the error
262 DOC> messages reported with each object (using SHOW ERRORS) to see if they
263 DOC> point to system misconfiguration or resource constraints that must be
264 DOC> fixed before attempting to recompile these objects.
265 DOC>#
266 OBJECTS WITH ERRORS
267 -------------------
268 0
269 DOC> The following query reports the number of exceptions caught during
270 DOC> recompilation. If this number is non-zero, please query the error
271 DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
272 DOC> are due to misconfiguration or resource constraints that must be
273 DOC> fixed before objects can compile successfully.
274 DOC> Note: Typical compilation errors (due to coding errors) are not
275 DOC> logged into this table: they go into DBA_ERRORS instead.
276 DOC>#
277
278 ERRORS DURING RECOMPILATION
279 ---------------------------
280 0
281 Function created.
282 PL/SQL procedure successfully completed.
283 Function dropped.
284 PL/SQL procedure successfully completed.
285 SYS@ora19c SQL>
286
287 --datapatch -sanity_checks
288 [oracle@rhel799:/u01/app/oracle/product/19.3.0/db/OPatch]$ ./datapatch -sanity_checks
289 SQL Patching sanity checks version 19.23.0.0.0 on Sat 03 Jan 2026 06:54:26 PM CST
290 Copyright (c) 2021, 2026, Oracle. All rights reserved.
291
292 Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sanity_checks_20260103_185426_2365/sanity_checks_20260103_185426_2365.log
293 Running checks
294 Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.3.0/db/sqlpatch/sqlpatch_sanity_checks.pm line 932.
295 Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.3.0/db/sqlpatch/sqlpatch_sanity_checks.pm line 932.
296 Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.3.0/db/sqlpatch/sqlpatch_sanity_checks.pm line 932.
297 Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.3.0/db/sqlpatch/sqlpatch_sanity_checks.pm line 932.
298 Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.3.0/db/sqlpatch/sqlpatch_sanity_checks.pm line 932.
299 Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.3.0/db/sqlpatch/sqlpatch_sanity_checks.pm line 932.
300 Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.3.0/db/sqlpatch/sqlpatch_sanity_checks.pm line 932.
301 Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.3.0/db/sqlpatch/sqlpatch_sanity_checks.pm line 932.
302 Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.3.0/db/sqlpatch/sqlpatch_sanity_checks.pm line 932.
303 Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.3.0/db/sqlpatch/sqlpatch_sanity_checks.pm line 932.
304 Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.3.0/db/sqlpatch/sqlpatch_sanity_checks.pm line 932.
305 Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.3.0/db/sqlpatch/sqlpatch_sanity_checks.pm line 932.
306 Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.3.0/db/sqlpatch/sqlpatch_sanity_checks.pm line 932.
307 Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.3.0/db/sqlpatch/sqlpatch_sanity_checks.pm line 932.
308 Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.3.0/db/sqlpatch/sqlpatch_sanity_checks.pm line 932.
309 Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.3.0/db/sqlpatch/sqlpatch_sanity_checks.pm line 932.
310 Use of uninitialized value $pdb in concatenation (.) or string at /u01/app/oracle/product/19.3.0/db/sqlpatch/sqlpatch_sanity_checks.pm line 932.
311 JSON report generated in /u01/app/oracle/cfgtoollogs/sqlpatch/sanity_checks_20260103_185426_2365/sqlpatch_sanity_checks_summary.json file
312 Checks completed. Printing report:
313 Check: Database component status - OK
314 Check: PDB Violations - OK
315 Check: Invalid System Objects - OK
316 Check: Tablespace Status - OK
317 Check: Backup jobs - OK
318 Check: Temp file exists - OK
319 Check: Temp file online - OK
320 Check: Data Pump running - OK
321 Check: Container status - OK
322 Check: Oracle Database Keystore - OK
323 Check: Dictionary statistics gathering - OK
324 Check: Scheduled Jobs - OK
325 Check: GoldenGate triggers - OK
326 Check: Logminer DDL triggers - OK
327 Check: Check sys public grants - OK
328 Check: Statistics gathering running - OK
329 Check: Optim dictionary upgrade parameter - OK
330 Check: Symlinks on oracle home path - OK
331 Check: Central Inventory - OK
332 Check: Queryable Inventory dba directories - OK
333 Check: Queryable Inventory locks - OK
334 Check: Queryable Inventory package - ERROR
335 Datapatch uses Queryable Inventory to get OPatch Inventory information and create a patching installation plan.
336 The Queryable Inventory package is not able to retrieve OPatch Inventory information.
337 Refer to MOS Note 1602089.1 for details on verifying the Queryable Inventory package before patching.
338 ora19c:
339 | RESULT |
340 |---------|
341 | Failure |
342 |---------|
343 Check: Queryable Inventory external table - SKIPPED (ERROR)
344 Message: Skipped as previous check wasn t executed successfully.
345 Check: Imperva processes - OK
346 Check: Guardium processes - OK
347 Check: Locale - OK
348
349 Refer to MOS Note 2680521.1 and debug log
350 /u01/app/oracle/cfgtoollogs/sqlpatch/sanity_checks_20260103_185426_2365/sanity_checks_debug_20260103_185426_2365.log
351
352 SQL Patching sanity checks completed on Sat 03 Jan 2026 06:54:38 PM CST
353 [oracle@rhel799:/u01/app/oracle/product/19.3.0/db/OPatch]$
354
355 --datapatch -verbose
356 [oracle@rhel799:/u01/app/oracle/product/19.3.0/db/OPatch]$ ./datapatch -verbose
357 SQL Patching tool version 19.23.0.0.0 Production on Sat Jan 3 18:56:16 2026
358 Copyright (c) 2012, 2024, Oracle. All rights reserved.
359
360 Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_2664_2026_01_03_18_56_16/sqlpatch_invocation.log
361
362 Connecting to database...OK
363 Gathering database info...done
364 Bootstrapping registry and package to current versions...done
365 Determining current state...done
366
367 Current state of interim SQL patches:
368 No interim patches found
369
370 Current state of release update SQL patches:
371 Binary registry:
372 19.23.0.0.0 Release_Update 240406004238: Installed
373 SQL registry:
374 Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 30-DEC-25 06.49.40.435436 PM
375
376 Adding patches to installation queue and performing prereq checks...done
377 Installation queue:
378 No interim patches need to be rolled back
379 Patch 36233263 (Database Release Update : 19.23.0.0.240416 (36233263)):
380 Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.23.0.0.0 Release_Update 240406004238
381 No interim patches need to be applied
382
383 Installing patches...
384
385 Patch installation complete. Total patches installed: 1
386
387 Validating logfiles...done
388 Patch 36233263 apply: SUCCESS
389 logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/36233263/25638263/36233263_apply_ORA19C_2026Jan03_18_57_09.log (no errors)
390 SQL Patching tool complete on Sat Jan 3 19:05:28 2026
391 [oracle@rhel799:/u01/app/oracle/product/19.3.0/db/OPatch]$
392
393 --opatch lspatches
394 [oracle@rhel799:/u01/app/oracle/product/19.3.0/db/OPatch]$ opatch lspatches
395 36240578;OCW RELEASE UPDATE 19.23.0.0.0 (36240578)
396 36233263;Database Release Update : 19.23.0.0.240416 (36233263)
397
398 OPatch succeeded.
399 [oracle@rhel799:/u01/app/oracle/product/19.3.0/db/OPatch]$
400
401 --查询
402 SYS@ora19c SQL> set linesize 300
403 SYS@ora19c SQL> col ACTION_TIME for a30
404 SYS@ora19c SQL> col DESCRIPTION for a55
405 SYS@ora19c SQL> select patch_id, action,status,action_time,description from dba_registry_sqlpatch;
406
407 PATCH_ID ACTION STATUS ACTION_TIME DESCRIPTION
408 ---------- --------------- ------------------------- ------------------------------ -------------------------------------------------------
409 29517242 APPLY SUCCESS 30-DEC-25 06.49.40.435436 PM Database Release Update : 19.3.0.0.190416 (29517242)
410
411 SYS@ora19c SQL> exit
412 Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
413 Version 19.23.0.0.0
414 [oracle@rhel799:/soft/36233263]$
浙公网安备 33010602011771号