Home » RDBMS Server » Server Administration » migration from 9i to 10g (oracle 9i , solaris)
migration from 9i to 10g [message #375942] Mon, 15 December 2008 07:19 Go to next message
Messages: 58
Registered: December 2006
Location: france
Hi all,
I'm trying to migrate my 9i database to 10g.
I know I can use DBUA to perform it.
But How to proceed ?
Do I need to be installed both version (9i and 10 g) on the same server( machine)? if yes, may I use the same SID name before starting the migration ?

Re: migration from 9i to 10g [message #375947 is a reply to message #375942] Mon, 15 December 2008 07:22 Go to previous messageGo to next message
Frank Naude
Messages: 4509
Registered: April 1998
Senior Member
Yes, you need both 9i and 10g versions on the same system. The SID will not change during the upgrade.

For detailed instructions, check the Upgrade Guide.
Re: migration from 9i to 10g [message #383210 is a reply to message #375942] Tue, 27 January 2009 14:44 Go to previous message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
If you are trying to upgrade 9i db to 10g, don't you already have 9i installed since this db is up and running ??

Make sure you install 10g in a different ORACLE_HOME

Use DBUA ..much easier and follow the instructions.
Sanjay B.
Previous Topic: Difference in connecting as sqlplus / as sysdba, sqlplus "/ as sysdba" and sqlplus '/ as
Next Topic: end of file communication channel
Goto Forum:

Current Time: Sat Jul 22 15:51:18 CDT 2017

Total time taken to generate the page: 0.05394 seconds