Home » RDBMS Server » Server Administration » Oracle 9i to 10g upgrade (oracle 9.2.0.5)
Oracle 9i to 10g upgrade [message #446460] Mon, 08 March 2010 10:03 Go to next message
d_ponnilavan
Messages: 13
Registered: May 2005
Location: india
Junior Member
Hi,
I've 20GB oracle 9.2.0.5 DB running in sun Solaris sparc.
We are planning to upgrade the DB to 10.2.0.1. But we have confusion over the method of upgrading. I'm suggesting about going for manual upgrade, but Mgmt suggests going for imp/exp.
They ask for concrete reason for choosing manual upgrade instead of imp/exp.
Could someone explain what are the advantages/disadvantages of both the methods, so that we could choose one of the methods?

Thanks in advance for looking into this
Ponnilavan

Report message to a moderator

Re: Oracle 9i to 10g upgrade [message #446461 is a reply to message #446460] Mon, 08 March 2010 10:06 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
dbua - faster (less downtime)
exp/imp - safer (have original DB in case of problem)

Report message to a moderator

Re: Oracle 9i to 10g upgrade [message #446464 is a reply to message #446460] Mon, 08 March 2010 10:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The different options are listed in Database Upgrade Guide, Chapter 3 Upgrading to the New Oracle Database 10g Release.

Regards
Michel

Report message to a moderator

Re: Oracle 9i to 10g upgrade [message #453596 is a reply to message #446460] Thu, 29 April 2010 18:34 Go to previous messageGo to next message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
Going 9i to 10g, suggest DBUA.

Just take a FULL backup before any upgrade. 10g DBUA is pretty robust.

--
Sanjay B.

Report message to a moderator

Re: Oracle 9i to 10g upgrade [message #453607 is a reply to message #453596] Thu, 29 April 2010 23:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which does not add anthing to the previous answer, so why wasting your time on this topic ended 2 month ago?

Regards
Michel

Report message to a moderator

Re: Oracle 9i to 10g upgrade [message #453708 is a reply to message #453607] Fri, 30 April 2010 06:37 Go to previous messageGo to next message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
Michel Cadot wrote on Fri, 30 April 2010 00:50
Which does not add anthing to the previous answer, so why wasting your time on this topic ended 2 month ago?

Regards
Michel


That was less than 2 months ago.

[Updated on: Fri, 30 April 2010 06:40]

Report message to a moderator

Re: Oracle 9i to 10g upgrade [message #453715 is a reply to message #453708] Fri, 30 April 2010 06:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, but that's useless.

Regards
Michel

Report message to a moderator

Re: Oracle 9i to 10g upgrade [message #453716 is a reply to message #453715] Fri, 30 April 2010 06:54 Go to previous message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
Michel Cadot wrote on Fri, 30 April 2010 07:48
Yes, but that's useless.

Regards
Michel


Thank you for reminding.

Report message to a moderator

Previous Topic: The aim of WMSYS
Next Topic: Undo_Management
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 19 13:41:21 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.