Upgrade problems

[Mara]

I have an Oracle 8.1.5 database named IIS. I installed Oracle 8.1.7. In the process of deleting Oracle 8.1.5 I created a"Clean Machine" so I deleted the service for the IIS database (using Oradim utility).
After I installed 8.1.7 I've created a new service then I tried to open the database. When SQL Workseet opens I get some weird messages like" DBMS_APPLICATION not installed". Could anyone tell me what to do to upgrade the 8.1.5 database to 8.1.7 , what steps do I have to follow?

Thanx

[jlakhani]

For DBMS_APPLICATION there must be a procedure to run to create it but
TO PERFORM RDBMS UPGRADE:

you need to dl 8.1.7 RDBMS upgrades from Oracle. READ release notes. Check Metalink or Oracle WW support. Usually steps are of the following:

1: shutdown, backup filesystem for recovery purpose
1: setup environment | run Installer
2: Perform upgrade
3: re-run catproc.sql, catalog.sql, recompile objects including
system objects
4:bring up database and test/check system health

ONE ADVICE WOULD BE TO TEST THIS UPGRADE ON A TEST INSTANCE.

hope this helps
jigar

[hnagia]

open your database under the new Oracle 817 normally from Server manager and run upgrade batch on the database , get back to Oracle documentation for specific script name.

It is very very easy to implement