OraFAQ Forum: Server Administration » Upgrade from Oracle 9i R2 to Oracle 10g R2

Home » RDBMS Server » Server Administration » Upgrade from Oracle 9i R2 to Oracle 10g R2

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

Upgrade from Oracle 9i R2 to Oracle 10g R2 [message #176351]

Thu, 08 June 2006 01:34

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Hi,

I am planning to upgrade 9i R2 DB to 10g R2 DB in windows 2000.
I am not aware of the patches to be installed before upgrade.
Please guide me.

Regards
Salih KM

Report message to a moderator

Re: Upgrade from Oracle 9i R2 to Oracle 10g R2 [message #176385 is a reply to message #176351]

Thu, 08 June 2006 02:54

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

http://www.oracle-base.com/articles/10g/UpgradingTo10g.php

Report message to a moderator

Re: Upgrade from Oracle 9i R2 to Oracle 10g R2 [message #176390 is a reply to message #176385]

Thu, 08 June 2006 03:20

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Thanks tarundua,

But that doc doesn't contain any information about patches.
Is it necessary that patches should be applied before upgrade?

Report message to a moderator

Re: Upgrade from Oracle 9i R2 to Oracle 10g R2 [message #176739 is a reply to message #176390]

Fri, 09 June 2006 06:28

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

First upgrade your database, then download the 10.2.0.2 (or later) patch-set from Metalink and install it as well.

Report message to a moderator

Re: Upgrade from Oracle 9i R2 to Oracle 10g R2 [message #176765 is a reply to message #176351]

Fri, 09 June 2006 08:42

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

And check the support matrix on otn.oracle.com. When you go in to download the database, there is a link for the support matrix. Click it and plug in your info, to double check support for your version OS and DB. It will also list the various db patch numbers that exist, and the minimum one required for your selected OS and OS service pack.

Report message to a moderator

Re: Upgrade from Oracle 9i R2 to Oracle 10g R2 [message #176935 is a reply to message #176351]

Mon, 12 June 2006 02:16

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Thanks a lot to Frank and smartin.

Report message to a moderator

Previous Topic:	whats catpatch.sql for ???
Next Topic:	ORA-01031: insufficient privileges

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:44:29 CDT 2024