Upgrade 7.3.4 to 8.1.7

[pascal01]

Hi. Can I upgrade my db from 7.3.4 to 8.1.7 by doing an export/import? If not, can someone please assist me in finding the procedure. Thank you . Regards.

[marist89]

I personally prefer ODMA, but you can do it with export/import. Review http://otn.oracle.com/docs/products/...a86632/toc.htm

[pascal01]

Hi. What do you mean by ODMA? Is this a tool thats on the Oracle 7.3 server? Is it included in 8.1.7 server?

[mike2000]

Oracle data Migration Assistant

[pascal01]

Hi, When I launch the ODMA on my server, it only identifies the databases running on my server. I would like to migrate an Oracle 7.3.4 running on another server and migrate it to 8.1.7 on my server. How can I do this with ODMA?

[mike2000]

in order to use ODMA to upgrade your database you have to install Oracle 8.1.7 on that machine which mean that you have to have two Oracle Home.

If they are on two seperate machine, IMP/EXP is the soluton

good luck

[marist89]

Originally posted by pascal01
Hi, When I launch the ODMA on my server, it only identifies the databases running on my server. I would like to migrate an Oracle 7.3.4 running on another server and migrate it to 8.1.7 on my server. How can I do this with ODMA?

Install 7.3 AND 8.1 on the new server.
Clone the database from oldServer to newServer and bring up the database in 7.3 (for warm fuzzies).
Use ODMA on the new server.

[servant]

I would have done this way

1)take a cold backup of original DB

2)export ORACLE_HOME=(8.1.7)

3)export PATH=$ORACLE_HOME/bin:$PATH

4)export ORACLE_SID=<7.3.4 database>

5)svrmgrl (this new svrmgrl connects to old_oracle_sid,don't panic)

connect internal

@$ORACLE_HOME/rdbms/admin/u0703040.sql

This will upgrade your database from 7.3.4 to 8.1.7

you can run $ORACLE_HOME/rdbms/admin/utlrp.sql to
validate any invalid objects


Please take the export of data also before you do this.
u0703040.sql upgrades data-dictionary views.If you face any problem with the data you can import into new DB

GOOD LUCK
GOOD LUCK

Cheers


[Edited by servant on 10-08-2002 at 05:37 AM]

[servant]

I am little over enthusiastic.

Anyway you can't connect to 734 database from 817 ORACLE_HOME while the database is up and running

After taking cold backup while the database is down only

you have to export new_oracle_home etc...

you have to start the database using new ORACLE_HOME

i.e you have to start 734 database using 817 oracle_home

you may get errors like

this parameter is obsolete etc..ignore them..

after the instance is opened

you run $ORACLE_HOME/rdbms/admin/u0703040.sql

If you already migrated the database ignore the above


Please take the export of data also before you do this.
u0703040.sql upgrades data-dictionary views.If you face any problem with the data you can import into new DB


GOOD LUCK



[Edited by servant on 10-08-2002 at 05:39 AM]