AnsweredAssumed Answered

V12 TO V14 upgrade involve Oracl 10g to Oracle 11g upgrade

Question asked by Suhas Kamble on Dec 11, 2014
Latest reply on Jan 23, 2015 by nick_darlington

We are planning to upgrade from V12 to V14.1



Environment is

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