Reply To: After upgrade from Oracle 11 to Oracle 12 HVR Log-based capture fails

#8862
Frank Knot
Participant

This error occurs because after the upgrade the Oracle REDO and archive files are still in Oracle 11 format.

Older HVR version (4.7 and down) do not recognize this.

The solution is to upgrade HVR to version 5 which will recognize and handle this situation automatically.

Alternatively you can upgrade the the Oracle redo en archive files to 12 format by running statement

alter system set compatible='12.1.0.0.0' scope=spfile;

on the Oracle database and restarting it.

Please note that this action cannot be reverted. That means you cannot downgrade your Oracle database from 12 to 11 anymore.

  • This reply was modified 3 months, 1 week ago by HVR Software.
Test drive
Contact us