We are currently using Cognos ReportNet 1.1 with Oracle 9i.
We want to move everything to Oracle 10g
Has anyone done this in the past
How to do the entire migration from Oracle 9i to Oracle 10g?
Hi! I just did this over the summer. First the DBA backed up the database.
My Steps:
shutdown app
uninstall Oracle 9 client on server (both content manager and dispatchers run on one box)
remove ORACLE_HOME env var
installed Oracle 10 client
set ORACLE_HOME and TNS_NAMES env vars for new version
ran Oracle NetManager to configure database connections
copied classes12.zip from 10 to webapps\p2pd\web-inf\lib and renamed to classes12.jar
The DBA converted the database to 10 g, I brought up the app and all was well
hth...jean