Database Upgrade. How to do it

[dwsupport]

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?

[avitabj]

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