Home » RDBMS Server » Server Administration » Upgrade of database
Upgrade of database [message #249822] Fri, 06 July 2007 01:06 Go to next message
pooja_g
Messages: 56
Registered: December 2005
Location: India
Member
Hi,
I am in the process of upgrading the oracle database from 9.2.0.8 to 10.2.0.3 on HP-UX PA RISC 64 bit machine.Does the patchset of 10.2.0.3 work directly to upgrade ,or the patch set has to be applied after upgrading to 10.2.0.1.Kindly guide regarding this.

Thanks,
Re: Upgrade of database [message #249885 is a reply to message #249822] Fri, 06 July 2007 07:20 Go to previous messageGo to next message
pooja_g
Messages: 56
Registered: December 2005
Location: India
Member
Hi,
If anyone has upgraded from 9i to 10g release 2 please reply.From where do we download the software,Metalink or OTN.Please help in this.

Thanks,
Re: Upgrade of database [message #249943 is a reply to message #249885] Fri, 06 July 2007 10:16 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
http://www.oracle-base.com/articles/10g/UpgradingTo10g.php

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14238/toc.htm
Re: Upgrade of database [message #250018 is a reply to message #249885] Fri, 06 July 2007 23:53 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You can download patches and patch set from metalink website.
or you have to first upgrade you database from 9i to 10gr2 after upgrading apply latest patchset for 10gr2 database.


Regards
Taj
Re: Upgrade of database [message #250180 is a reply to message #250018] Mon, 09 July 2007 00:50 Go to previous messageGo to next message
pooja_g
Messages: 56
Registered: December 2005
Location: India
Member
Hi,
Thanks Taj,I was confused as 9i had 3 cds and 10g has only one cd(software).I have downloaded 10.2.0.1 from otn and the latest patchset of 10.2.0.3 from metalink.

thanks,
Re: Upgrade of database [message #250813 is a reply to message #250180] Wed, 11 July 2007 07:22 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

Yes it is correct oracle 9i comes with 3 cd's pack.
and 10g is comes with 1 cd pack.

and latest patch set for 10gr2 is 10.2.0.3 and for 10gr1 is 10.1.0.5

Regards
Taj
Previous Topic: Ip address of the host cannot be determined
Next Topic: find out top sql
Goto Forum:
  


Current Time: Sat Dec 14 13:18:20 CST 2024