Home » RDBMS Server » Server Administration » Database patching when moving to new ORACLE_HOME (12c R2 Enterprise, Oracle Linux 7.9)
Database patching when moving to new ORACLE_HOME [message #687816] Mon, 19 June 2023 11:25 Go to next message
rcct
Messages: 36
Registered: May 2013
Location: Ottawa, ON
Member
Hi, I am currently running some 12c R2 databases, and they have been patched to the latest 12c patches CPUJan2022 (33561275, 33587128). However, I need to commission a new server, as the current one is past its end-of-life. After I install 12c on the new server and migrate the databases, I have a couple of questions about patching.

1) After I install the patches on the new ORACLE_HOME (opatch apply), what do I need to do with the databases? Since they were already patched on the old server, do I need to run datapatch on them again?
2) Is there any way to check if the binary registry and SQL registry match?

Thanks.
Re: Database patching when moving to new ORACLE_HOME [message #687817 is a reply to message #687816] Mon, 19 June 2023 13:34 Go to previous messageGo to next message
John Watson
Messages: 8916
Registered: January 2010
Location: Global Village
Senior Member
I would always run datapatch. It will do anything needed, and if there is nothing to do, it will do nothing. You can trust Uncle Oracle.  
Re: Database patching when moving to new ORACLE_HOME [message #687818 is a reply to message #687817] Mon, 19 June 2023 13:38 Go to previous message
rcct
Messages: 36
Registered: May 2013
Location: Ottawa, ON
Member
Thank you!
Previous Topic: resource manager used with SE2
Next Topic: oracle compression issues
Goto Forum:
  


Current Time: Sun Feb 25 15:42:23 CST 2024