Operating System - HP-UX
1747980 Members
3871 Online
108756 Solutions
New Discussion юеВ

Re: Oracle 8.1.6 to 8.1.7 database migration

 
SOLVED
Go to solution
Chartier Jerome
Frequent Advisor

Oracle 8.1.6 to 8.1.7 database migration

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
J@Y
6 REPLIES 6
Andreas D. Skjervold
Honored Contributor

Re: Oracle 8.1.6 to 8.1.7 database migration

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
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
Andreas D. Skjervold
Honored Contributor
Solution

Re: Oracle 8.1.6 to 8.1.7 database migration

.. the script name is ofcourse
u0801060.SQL

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

Andreas
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
Jim Butler
Valued Contributor

Re: Oracle 8.1.6 to 8.1.7 database migration

Andreas is correct -
Very painless -

just run the scripts.


Man The Bilge Pumps!
twang
Honored Contributor

Re: Oracle 8.1.6 to 8.1.7 database migration

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
twang
Honored Contributor

Re: Oracle 8.1.6 to 8.1.7 database migration

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
Yogeeraj_1
Honored Contributor

Re: Oracle 8.1.6 to 8.1.7 database migration

hi jerome,

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

regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)