Home » RDBMS Server » Server Administration » Upgrade from Oracle9.0.1.0 to 9.2.0.7
Upgrade from Oracle9.0.1.0 to 9.2.0.7 [message #193659] Mon, 18 September 2006 16:22 Go to next message
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
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 Go to previous messageGo to next message
BlackSwan
Messages: 25035
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.
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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
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 Go to previous message
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
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:
  


Current Time: Sat Dec 03 20:41:17 CST 2016

Total time taken to generate the page: 0.06558 seconds