topic Re: Oracle 8.1.6 to 8.1.7 database migration in Operating System - HP-UX

Oracle 8.1.6 to 8.1.7 database migration

Chartier Jerome — Thu, 09 Jan 2003 11:40:25 GMT

Hello,

I'm planning to migrate a whole database (very large) from oracle 8.1.6 to oracle 8.1.7.
Is there a best way to operate than dumping the database under 8.1.6, then import the dump after installing the 8.1.7.

Thanks in adance for your help

Regards

Jerome

Re: Oracle 8.1.6 to 8.1.7 database migration

Andreas D. Skjervold — Thu, 09 Jan 2003 12:07:35 GMT

Hi

As this is no migration, just a upgrade;
-Stop the database and do a backup.
-Install 8.1.7 in a new ORACLE_HOME
-start the database from the new ORACLE_HOME
-Run the update script supplied in $OH/rdbms/admin:
u0801070.SQL

And run:
-catalog.sql
-catproc.sql
-UTLRP.sql

Andreas

Re: Oracle 8.1.6 to 8.1.7 database migration

Andreas D. Skjervold — Thu, 09 Jan 2003 12:20:12 GMT

.. the script name is ofcourse
u0801060.SQL

The *70.sql script is for transition to 8.1.7.x patches.

Andreas

Re: Oracle 8.1.6 to 8.1.7 database migration

Jim Butler — Thu, 09 Jan 2003 13:36:32 GMT

Andreas is correct -
Very painless -

just run the scripts.

Re: Oracle 8.1.6 to 8.1.7 database migration

twang — Fri, 10 Jan 2003 05:25:10 GMT

Hi,
Because no change required for data in 816 and 817 environment, therefore you only have to install the new software and create the system's packages and objects.

regards
tommy

Re: Oracle 8.1.6 to 8.1.7 database migration

twang — Fri, 10 Jan 2003 05:25:25 GMT

Hi,
Because no change required for data from 816 to 817 environment, therefore you only have to install the new software and create the system's packages and objects.

regards
tommy

Re: Oracle 8.1.6 to 8.1.7 database migration

Yogeeraj_1 — Fri, 10 Jan 2003 08:41:11 GMT

hi jerome,

to add to the above posts, don't forget to also apply the latest Oracle RDBMS patches!

regards
yogeeraj