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 from the old servers to the new ones because the duplicate from active database was failing with this error:
|
1 2 3 4 5 6 7 8 9 |
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 09/11/2017 15:59:32 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script RMAN-03009: failure of backup command on prmy1 channel at 09/11/2017 15:59:32 ORA-17629: Cannot connect to the remote database server ORA-17630: Mismatch in the remote file protocol version client 2 server 3 |
The last lines shows the same error that Franck blogged about some months ago.
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
Now, the bundle patch that we installed on BP 170718 contains the same bugfix (Patch for bug 18633374).
So, the incompatibility happens now between databases of the same “Major Release” (12.1.0.2).
There are two possible workarounds:
- Apply the same patch level on both sides (BP170718 in my case)
- Apply just the patch 18633374 on top of your current PSU/DBBP (a merge might be necessary).
We used the second approach and now we can setup Data Guard again to move our databases without downtime:
|
1 2 3 4 5 6 7 8 |
oracle@oldserver $ opatch lspatches 18633374; <<<<<< FIX! 24340679;DATABASE BUNDLE PATCH: 12.1.0.2.161018 (24340679) oracle@newserver $ opatch lspatches 22652097; 22243983; 25869760;DATABASE BUNDLE PATCH: 12.1.0.2.170718 (25869760) |
HTH
—
Ludovico
Latest posts by Ludovico (see all)
- New views in Oracle Data Guard 23c - January 3, 2024
- New in Data Guard 21c and 23c: Automatic preparation of the primary - December 22, 2023
- Does FLASHBACK QUERY work across incarnations or after a Data Guard failover? - December 13, 2023
We had the same issue,The Primary was patched whereas the standby was not patched , once we the patched standby our issue was fixed