OraFAQ Forum: Server Administration » database upgrade from 8.1.6.0 to 10g release2

Home » RDBMS Server » Server Administration » database upgrade from 8.1.6.0 to 10g release2

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

database upgrade from 8.1.6.0 to 10g release2 [message #257222]

Tue, 07 August 2007 16:00

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

Report message to a moderator

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

BlackSwan
Messages: 26766
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

ghotu
Messages: 11
Registered: August 2007
Location: Richmond

Junior Member

I did not clearly understand what you answer was...

sorry for inconvinience

thanks
abhi

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68686
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

Report message to a moderator

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

ghotu
Messages: 11
Registered: August 2007
Location: Richmond

Junior Member

Thank you very much for your response guys. Its really useful information.

Thanks
Abhi

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What does the note say?

Regards
Michel

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68686
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

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

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

Michel Cadot
Messages: 68686
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

Report message to a moderator

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

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.

Report message to a moderator

Previous Topic:	dbora startup issues
Next Topic:	Trace file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 20:25:51 CDT 2024