Migrating an 8.0.5 database to 8.1.6

[MrBass]

I've got an 8.0.5 database and want to upgrade it to 8.1.6. I've tried using the Database Migration Tool but that keeps failing. Is there a simple way to manually upgrade??

 

[karluk]

I wouldn't call it "simple" exactly, but one fairly reliable way to upgrade is to create a new 8i database, export the data from the 8.0.5 database, and import to the 8i db. The advantage of doing it this way is that you can do your database creation and configuration ahaead of time and then schedule a relatively brief outage to migrate the data.

 

[Turkbear]

In addition, remember to use the 8.0.5 tool to do the Export
not the 8.1.x one...

BTW, what type of failure--What errors if any do you get?

 

[MrBass]

Thanks for the suggestions.

The first error I was getting was ORA-12560: TNSrotocol adapter error. This was because I was running it via Terminal Services so if anyone has any idea how to sort that out that would be helpful.

I then ran it from the console and after it flagged up a couple of unsupported params in the init.ora it finally flagged up the following ORA-01571: redo version 8.0.5.0.0 incompatible with ORACLE version 8.0.0.0.0

As this is the first time I've attempted anything like this I'm probably doing it all wrong. The problem is that the database I want to upgrade was created by an external company so if I had to recreate it in 816 I wouldn't know where to start. Add to that the fact I have never created an Oracle database, it leaves me pretty much stuck!

 

[DoubleH]

Hi,
The first error is becuse of connection problems. Use tnsping dbname and check out whether the connection is fine.
For second error You can refer to oracle release notes for that particular release.
Generally Your migration kit should not fail. Try running it again. Database migration is a very good tool to migrate. Thanks & Regards,
DoubleH

 

[karluk]

Your ORA-01571 indicates that the initialization parameter COMPATIBLE" is not set properly. Please check your init.ora file and see what it's currently set at. I would try setting it to 8.1.6.0.0 (or whatever version you are upgrading to) and see if that fixes the problem.

 

[ThomVF]

Some help with manually migrating from 805 to 816 (my preferred method). I personally don't see a need to export/import to migrate:

http://www.bijoos.com/oratom/ot_200101.htm

Also, a bug affecting some upgraders to 8.1.6

http://www.evdbt.com/upg816bug.txt

Tom

Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com

 

[ThomVF]

I suggest you also go through this manual carefully.

http://www.znow.com/sales/oracle/server.816/a76957/migupgra.htm#6967

Tom
Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com