Home » RDBMS Server » Server Administration » database upgrade from 8.1.6.0 to 10g release2
database upgrade from 8.1.6.0 to 10g release2 [message #257222] Tue, 07 August 2007 16:00 Go to next message
ghotu
Messages: 11
Registered: August 2007
Location: Richmond
Junior Member
Hello All,

We have database version 8.1.6.0 in my company and power builder 9.0 is running on front end. I need to ugrade my database to 10.2.0.1...I am kind of confused here cuz different document says different thing...

one doc from metalink suggest that i can directly go from 8.1.6 to 9.0.1 and after that i think i can upgrade directly to 10.2.0.1

other 10 upgrade document from otn suggest this

8.1.6 ---> 8.1.7.4----> 10.2.0

but i think in this case i have to install 8.1.7 then apply patchset 8.1.7.4 , please correct me if it is wrong. If it is right then its lengthy process....

please guys help me out in this and give me proper suggestion what should i do...

thanks
abhi
Re: database upgrade from 8.1.6.0 to 10g release2 [message #257225 is a reply to message #257222] Tue, 07 August 2007 16:14 Go to previous messageGo to next message
BlackSwan
Messages: 25032
Registered: January 2009
Location: SoCal
Senior Member
>8.1.6 ---> 8.1.7.4----> 10.2.0
AFAIK, this is correct.

[Updated on: Tue, 07 August 2007 16:19] by Moderator

Report message to a moderator

Re: database upgrade from 8.1.6.0 to 10g release2 [message #257226 is a reply to message #257225] Tue, 07 August 2007 16:18 Go to previous messageGo to next message
ghotu
Messages: 11
Registered: August 2007
Location: Richmond
Junior Member
I did not clearly understand what you answer was...

sorry for inconvinience

thanks
abhi
Re: database upgrade from 8.1.6.0 to 10g release2 [message #257276 is a reply to message #257226] Tue, 07 August 2007 23:44 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

but i think in this case i have to install 8.1.7 then apply patchset 8.1.7.4 , please correct me if it is wrong. If it is right then its lengthy process....

Yes, your procedure is right....already answered by "Ana"

What is your database size if small and you feel it is very lengthly procedure then you can use EXPORT/IMPORT(original utility) and upgrade your database.

export database from 8.1.7 and import to 10g

Regards
Taj
Re: database upgrade from 8.1.6.0 to 10g release2 [message #257291 is a reply to message #257226] Wed, 08 August 2007 00:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
See Tom Kyte's answer:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:18064818873846#392918000346371890

Regards
Michel
Re: database upgrade from 8.1.6.0 to 10g release2 [message #257516 is a reply to message #257222] Wed, 08 August 2007 09:21 Go to previous messageGo to next message
ghotu
Messages: 11
Registered: August 2007
Location: Richmond
Junior Member
Thank you very much for your response guys. Its really useful information.

Thanks
Abhi
Re: database upgrade from 8.1.6.0 to 10g release2 [message #257522 is a reply to message #257222] Wed, 08 August 2007 09:25 Go to previous messageGo to next message
ghotu
Messages: 11
Registered: August 2007
Location: Richmond
Junior Member
Forgot to add in my last post...

what about the other option which is mentioned in metalink
DocID: Note:159657.1, according to this

8.1.6 ---> 9.0.1----> 10.2.0


Is this a bad option?

Thanks
Abhi

Re: database upgrade from 8.1.6.0 to 10g release2 [message #257530 is a reply to message #257522] Wed, 08 August 2007 10:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What does the note say?

Regards
Michel
Re: database upgrade from 8.1.6.0 to 10g release2 [message #257532 is a reply to message #257222] Wed, 08 August 2007 10:06 Go to previous messageGo to next message
ghotu
Messages: 11
Registered: August 2007
Location: Richmond
Junior Member
note just say upgradation from 8.1.6 to 9.0.1 ...It doesn't mention about anything 8.1.6 to 8.1.7.4... but i wanted to know your suggestion.

Since 8.1.6. to 8.1.7.4 has an extra step of applying patches...

Thanks Michel
Re: database upgrade from 8.1.6.0 to 10g release2 [message #257535 is a reply to message #257532] Wed, 08 August 2007 10:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The document is "Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9iR2 (9.2.0)" and does not talk about 10g.
For 10g, keep 10g upgrade manual.

Regards
Michel
Re: database upgrade from 8.1.6.0 to 10g release2 [message #257537 is a reply to message #257222] Wed, 08 August 2007 10:16 Go to previous messageGo to next message
ghotu
Messages: 11
Registered: August 2007
Location: Richmond
Junior Member
Thank you very much Michel for you quick response...

Yes you are right, i will definitely keep 10g upgrade document. I am just trying to find a best way to do it.

I suppose once i will upgrade 8i to 9i rel1 then i can upgrade it to 10g from 9i rel1. right?

Thanks
Re: database upgrade from 8.1.6.0 to 10g release2 [message #257538 is a reply to message #257532] Wed, 08 August 2007 10:17 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

And don't confiused.

<quote>
For example, if your current release is release 8.1.6, then you will need to first upgrade to release 8.1.7 using the instructions in Oracle8i Migration for release 8.1.7. The release 8.1.7 database can then be upgraded to the new Oracle Database 10g release using the instructions in this book.
</quote>
http://download.oracle.com/docs/cd/B14117_01/server.101/b10763/preup.htm#sthref54

You refer wrong metalink note.

Regards
Taj

Re: database upgrade from 8.1.6.0 to 10g release2 [message #257540 is a reply to message #257537] Wed, 08 August 2007 10:20 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

I suppose once i will upgrade 8i to 9i rel1 then i can upgrade it to 10g from 9i rel1. right?

But why ?

from 8.1.6 apply patch 8.1.7 upgrade 10.2.0
---> this is not better option ?

instead of
from 8.1.6 upgrade 9.0.1 upgrade 10.2.0



Regards
Taj

[Updated on: Wed, 08 August 2007 10:21]

Report message to a moderator

Re: database upgrade from 8.1.6.0 to 10g release2 [message #257541 is a reply to message #257540] Wed, 08 August 2007 10:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And more when you know that 9.0 was the worst version Oracle ever released.
It is a really bad idea to transit via a buggy version.

Regards
Michel
Re: database upgrade from 8.1.6.0 to 10g release2 [message #257542 is a reply to message #257222] Wed, 08 August 2007 10:30 Go to previous message
ghotu
Messages: 11
Registered: August 2007
Location: Richmond
Junior Member
I got the idea now.

Yes, 9i rel1 was the buggy version...i am gonna use other option..


Thanks you very much for help guys..i could have not found this info in any book.

Previous Topic: dbora startup issues
Next Topic: Trace file
Goto Forum:
  


Current Time: Fri Dec 02 12:25:52 CST 2016

Total time taken to generate the page: 0.13207 seconds