We are planning to upgrade from V12 to V14.1
Current : Clarity V12.1.1 with Oracle 10g on AIS+WAS
TOBE: Clarity V13.3 or v14.1 with Oracle 11g on Tomcat
We are planning to have Oracle 11g installed on destination server and restore DB backup from current clarity system onto the destination server.
Our DBA raised a concern that Cold backup from oracle 10g can not be restored onto 11G.
Has anybody come across this situation and what was done to achieve this?
The option I as Non-DBA person think of are
1. Install Oracle 11g on source server and convert the DB to oracle 11g (Duplicate copy) and take backup of this copy and restore it onto new server.
2. Take Export and do import (Not sure if this does all that is needed to make sure the database will be up and running without any issues with Clarity application)
3. There must be some option so that Server B with 11g can Pull the entire data from Server B running 10g