OraFAQ Forum: Server Administration » migration from 9i to 10g

Home » RDBMS Server » Server Administration » migration from 9i to 10g (oracle 9i , solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

migration from 9i to 10g [message #375942]

Mon, 15 December 2008 07:19

koff10
Messages: 58
Registered: December 2006
Location: france

Member

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 ?

Thanks.
koff

Report message to a moderator

Re: migration from 9i to 10g [message #375947 is a reply to message #375942]

Mon, 15 December 2008 07:22

Frank Naude
Messages: 4580
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.

Report message to a moderator

Re: migration from 9i to 10g [message #383210 is a reply to message #375942]

Tue, 27 January 2009 14:44

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.

Report message to a moderator

Previous Topic:	Difference in connecting as sqlplus / as sysdba, sqlplus "/ as sysdba" and sqlplus '/ as
Next Topic:	end of file communication channel

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 17:55:35 CDT 2024