Recently my customer patched its 12.1.0.2 databases with the Bundle Patch 170718 on the new servers (half of the customer’s environment). The old servers are still on 161018 Bundle Patch.<\/p>\n
We realized that we could not move anymore the databases from the old servers to the new ones because the duplicate from active database was failing with this error:<\/p>\n
RMAN-00571: ===========================================================\r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\nRMAN-00571: ===========================================================\r\nRMAN-03002: failure of Duplicate Db command at 09\/11\/2017 15:59:32\r\nRMAN-05501: aborting duplication of target database\r\nRMAN-03015: error occurred in stored script Memory Script\r\nRMAN-03009: failure of backup command on prmy1 channel at 09\/11\/2017 15:59:32\r\nORA-17629: Cannot connect to the remote database server\r\nORA-17630: Mismatch in the remote file protocol version client 2 server 3<\/pre>\nThe last lines shows the same error that Franck blogged about some months ago.<\/a><\/p>\n
Oracle 12.2 had introduced incompatibility with previous releases in remote file transfer via SQL*Net. At least this is what it seems. According to Oracle, this is due to a bugfix present in Oracle 12.2<\/p>\n
Now, the bundle patch that we installed on BP 170718 contains the same bugfix (Patch for bug 18633374).<\/p>\n
So, the incompatibility happens now between databases of the same “Major Release” (12.1.0.2).<\/p>\n
There are two possible workarounds:<\/p>\n
\n
- Apply the same patch level on both sides (BP170718 in my case)<\/li>\n
- Apply just the patch 18633374 on top of your current PSU\/DBBP (a merge might be necessary).<\/li>\n<\/ol>\n
We used the second approach and now we can setup Data Guard again to move our databases without downtime:<\/p>\n
oracle@oldserver $ opatch lspatches\r\n18633374; <<<<<< FIX!\r\n24340679;DATABASE BUNDLE PATCH: 12.1.0.2.161018 (24340679)\r\n\r\noracle@newserver $ opatch lspatches\r\n22652097;\r\n22243983;\r\n25869760;DATABASE BUNDLE PATCH: 12.1.0.2.170718 (25869760)\r\n<\/pre>\nHTH<\/p>\n
—<\/p>\n
Ludovico<\/p>\n
<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Recently my customer patched its 12.1.0.2 databases with the Bundle Patch 170718 on the new servers (half of the customer’s environment). The old servers are still on 161018 Bundle Patch. We realized that we could not move anymore the databases … Continue reading