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?
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
4:bring up database and test/check system health
ONE ADVICE WOULD BE TO TEST THIS UPGRADE ON A TEST INSTANCE.
hope this helps
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
IT Manager For Development
Oracle Consultant - OCP
Click Here to Expand Forum to Full Width