Home » RDBMS Server » Server Administration » New Oracle Home patches do not match database registry patches after migration (DB Enterprise 12.2.0.1, on Oracle Linux 7.9 server)
New Oracle Home patches do not match database registry patches after migration [message #686954] Tue, 07 February 2023 10:48 Go to next message
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!
Re: New Oracle Home patches do not match database registry patches after migration [message #686966 is a reply to message #686954] Wed, 08 February 2023 13:00 Go to previous messageGo to next message
John Watson
Messages: 8935
Registered: January 2010
Location: Global Village
Senior Member
You need to copy your $ORACLE_HOME/sqlpatch directory across. Without it, datapatch can't rollback the old patch before applying the new ones. You could raise a TAR with Support to confirm.
Re: New Oracle Home patches do not match database registry patches after migration [message #686985 is a reply to message #686966] Fri, 10 February 2023 09:19 Go to previous message
rcct
Messages: 36
Registered: May 2013
Location: Ottawa, ON
Member
Thank you John. I will work on that. Problem with raising a TAR is that it sends an automated message saying "Oracle 12c is no longer supported, upgrade" lol.
Previous Topic: duplicate entries in dba_free_space
Next Topic: Audit Logon of Specific User
Goto Forum:
  


Current Time: Thu May 30 01:08:41 CDT 2024