OraFAQ Forum: Server Administration » Upgrade from Oracle9.0.1.0 to 9.2.0.7

Home » RDBMS Server » Server Administration » Upgrade from Oracle9.0.1.0 to 9.2.0.7

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

Upgrade from Oracle9.0.1.0 to 9.2.0.7 [message #193659]

Mon, 18 September 2006 16:22

animeshh
Messages: 3
Registered: September 2006
Location: Windsor, Canada

Junior Member

Hi,
I want to upgrade Oracle Database in Solaris(SPARC-64bit) platform. The current version of Oracle DB is 9.0.1.0. I want to upgrade it to Oracle 9.2.0.7.
I need some help to proceed for upgrading it. Is there any direct way to do so?

Thanks in advance,
Animesh

Report message to a moderator

Re: Upgrade from Oracle9.0.1.0 to 9.2.0.7 [message #193661 is a reply to message #193659]

Mon, 18 September 2006 16:34

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I need some help to proceed for upgrading it.
I suggest that you simply READ & FOLLOW the instructions which come with the patchset.

Report message to a moderator

Re: Upgrade from Oracle9.0.1.0 to 9.2.0.7 [message #193789 is a reply to message #193659]

Tue, 19 September 2006 07:29

Shamsher
Messages: 18
Registered: September 2006

Junior Member

To upgrade the database from 9.2.0.1 to 9.2.0.7 first you have to shutdown the database normal/transactional/immediate. If windows then all the services related to database should be down. Then install the 9.2.0.7 with the setup kit (that will be around 150 mb or so).
Note: This setup will only upgrade the software but not the database, to upgrade the database also you have to do the following steps:-

-- Up all the services related to oracle, then on sql prompt :-

sql> startup migrate;
sql > @ oracle_home\rdbms\admin\catpatch.sql
sql> shutdown normal/immediate/transactional
sql> startup
sql> @ oracle_home\rdbms\admin\utlrp.sql

Regards
Shamsheer

Report message to a moderator

Re: Upgrade from Oracle9.0.1.0 to 9.2.0.7 [message #193825 is a reply to message #193789]

Tue, 19 September 2006 10:20

animeshh
Messages: 3
Registered: September 2006
Location: Windsor, Canada

Junior Member

Thanks..
I think the process mentioned will work to upgrade from 9.2.0.1 to 9.2.0.7. But I need to upgrade it from 9.0.1.0.
Will the same process applicable for upgrading from 9.0.1.0?

Regards,
Animesh

Report message to a moderator

Re: Upgrade from Oracle9.0.1.0 to 9.2.0.7 [message #193826 is a reply to message #193661]

Tue, 19 September 2006 10:23

animeshh
Messages: 3
Registered: September 2006
Location: Windsor, Canada

Junior Member

I searched the Oracle metalink site but could not find any such patchset.
Do you know the number of any such patchset?

Regards,
Animesh

Report message to a moderator

Re: Upgrade from Oracle9.0.1.0 to 9.2.0.7 [message #193896 is a reply to message #193826]

Tue, 19 September 2006 17:41

www.sidibe.net
Messages: 9
Registered: March 2004

Junior Member

Install the Release 9.2.0.4 Oracle Software
Upgrade the Database from 9.0.1.0 using the Database Upgrade Assistant or Manually.

Then You can apply the patchset 9.2.0.7.

Regards,
www.sidibe.net

Report message to a moderator

Re: Upgrade from Oracle9.0.1.0 to 9.2.0.7 [message #193920 is a reply to message #193826]

Tue, 19 September 2006 23:28

Shamsher
Messages: 18
Registered: September 2006

Junior Member

Yes the same process will work, But Pls find the appropriate patchset for the desired release from metalink and download. Rest the steps are the same which I posted earlier.

Thanks and Regards
Shamsheer

Report message to a moderator

Previous Topic:	How to allocate space for next extent whne no space hard disk.....
Next Topic:	Unable to drop the user using the system login

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 08:30:12 CDT 2024