| New Oracle Home patches do not match database registry patches after migration [message #686954] |
Tue, 07 February 2023 10:48  |
 |
rcct
Messages: 36
Registered: May 2013
Location: Ottawa, ON
|
Member |
|
|
Hi all, I recently migrated our databases to a new Linux server, as the old one had become end-of-life. So I installed a new Oracle home on the server, and migrated our database to it. The migration worked successfully. However, I am facing a patches mismatch, details are as follows:
The database in the old home been patched right up to Jan 2022 patches
a. Patch 33587128 - Database Jan 2022 Release Update 12.2.0.1.220118
b. Patch 33561275 - Oracle JavaVM Component Release Update 12.2.0.1.220118
When I patched the new home, opatch completed successfully, since it’s a brand-new Oracle home installation. However, datapatch on the database is failing, since it already has the patches in the registry. I have attached the sqlpatch_invocation.log file for reference. I’m getting messages such as:
Patch 30502018 ():
Not installed in the binary or the SQL registry
Patch 30593149 ():
Installed in the SQL registry only
Finally, the prereq checks fail with multiple messages:
Error: prereq checks failed!
patch 26123830: Error reading descriptor from registry: Not a SCALAR reference at /oracle/app/product/12.2.0.1/db_1/sqlpatch/lib/XML/Simple.pm line 433, <LOGFILE> line 383.
Can someone let me know how to fix this patch mismatch issue? Thanks!
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
