Upgrade Oracle 8.1.5.0.0 to 8.1.6
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Upgrade Oracle 8.1.5.0.0 to 8.1.6

  1. #1
    Join Date
    Jan 2000
    Posts
    387

    Question

    Hi,

    I am considering upgrading the database from version 8.1.5.0.0 to version 8.1.6. However, I saw an alert in Oracle metalink mentioning that the upgrade from 815 to 816 is not stable and there is error. May i know has anyone done this before? any errors? Thank u! :)

  2. #2
    Join Date
    Mar 2000
    Location
    india
    Posts
    54
    Hi
    I have done this on solaris,I havent faced any problems on sun solaris
    Raghu


  3. #3
    Join Date
    Nov 2000
    Posts
    344
    I was using 8.1.6.0 on hp and had to upgrade to 8.1.6.3 to get a fix for a bug with global temporary tables. In certain specific situations the database would crash. It only happened once though and we were on 8.1.6.0 for several months.

    -John

  4. #4
    Join Date
    Jan 2000
    Posts
    387
    Hi,

    Thanks for ur replies! :) Realli appreciate them! Hm... but i would really like to know has anyone upgraded from 815 to 816 before? Any bugs or crash? Thanks!

  5. #5
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    Yes. If you are upgrading from 815 to 816, then be prepared for the following error when you start and SQL plus session:

    ERROR:
    ORA-06553: PLS-908: The stored format of SYS.STANDARD is not supported by this
    release


    Error accessing package DBMS_APPLICATION_INFO
    ERROR:
    ORA-06553: PLS-908: The stored format of SYS.STANDARD is not supported by this
    release

    But don't worry, you can just run the RDBMS\ADMIN\U0801050.sql as an internal user and all your problems will be solved.
    Agasimani
    OCP(10g/9i/8i/8)

  6. #6
    Join Date
    Jan 2000
    Posts
    387
    Hi,

    1. Is it better to set a new ORACLE_HOME for the upgrade or do I have to uninstall the old version and use back the same path? What will be affected by the path?

    2. Is it better to do the upgrade manually or use the database migration utility?

    I am new to upgrading a database, therefor any comments or feedback will be good! :) Thanks!

  7. #7
    Join Date
    Mar 2000
    Location
    india
    Posts
    54
    Hi,
    1.Install it in new ORACLE_HOME
    2.When its doing installation it will detect the existing instances and will migrate one instance at that time of installation if you want with migration utility,u can do it with migration utility later.U can do the migration of other instances(if u have more than one) using migration utility.

    Ensure u have full back up of the database both logical and physical.

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