Database Upgradation

[Shahbaz_1]

Hi,
I was looking at the way to upgrade our database, running on Oracle 8.1.6.1.0 to 8.1.7.3.0.
What would be the best way to do this upgrading process?

Thanks & Regards
Syed

[Alexander M. Ermes]

Hi there.
Install the 8.1.7 software ( don't forget the HP-UX patches ).
DO A BACKUP NOW ! ( if possible, complete system )

check scripts for creation of database.
do an export of your old database.
save this export to tape.
scratch old database.
Change ORACLE_HOME etc ( oratab ...) to new software.
Create new database with old ORACLE_SID.
Import data from export of old database.
one run to import data, another run without data to create and compile unresolved items
( views, procedures etc. ) During the import you should compile invalid objects every minute, because otherwise the import will get stuck.
If you need more info, just let me know.
Rgds
Alexander M. Ermes

[Steven Gillard_2]

You should first install the new software into a new ORACLE_HOME directory, then you can use the Oracle migration assistant to upgrade your database files.

See the Oracle migration guide for detailed steps:

http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a86632/toc.htm

Make sure you have a good read of this guide before starting!

Regards,
Steve