Upgrade problems
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Upgrade problems

  1. #1
    Join Date
    Jun 2000
    Location
    Toronto, ON, Canada
    Posts
    50
    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

  2. #2
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    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

  3. #3
    Join Date
    Jun 2000
    Posts
    179

    Talking

    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
  •  


Click Here to Expand Forum to Full Width