Upgrading from 8.0.6 to 8.1.7.2.0 ?

[Striker99]

All,

I have Oracle 8.0.6 database running and have some important data. I have to migrate to version 8.1.7.2.0 and preserve the data. The 8.0.6 is on HP UX 10.2 and 8.1.7.2 is on HP UX 11.0.

Any suggessions on what's the best way to do this.

Thanks in advance,
striker99

 

[Georgdba]

Hi -

the best way to solve your question depends
on the mass of data.
I had this requierement solved with the
EXPORT -Tool (across platforms from HPUX -> AIX)
EXPORT tablespaces transfer via local Net (or Tape) an Import with appr. User. In case of ts >2GB use the
filesize clause in Exportdoing.
-Keep an eye on free storage-
-Keep an eye on OS filesize limit on new maschine-

greetings Georg

 

[spenglerr]

Actually I remember that you will also have to keep an eye to the HP kernel parameters when switching to 8.1.7, the number of new kernel parameters increased for Oracle