-
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
-
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
-
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
Hisham Nagia
IT Manager For Development
Oracle Consultant - OCP
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|