8.0.4 To 9i rel 2 -- inputs needed
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: 8.0.4 To 9i rel 2 -- inputs needed

  1. #1
    Join Date
    Feb 2001
    Posts
    290
    Hello All,

    We have a plan to upgrade one of the database which is running on 8.0.4 ( an unsupported version from ORACLE ), to the latest version 9i Rel 2. Here i would like to know the following from your expertise.

    0. Any Known issues
    1. Steps invloved in my situation
    2. Pointers where i can get some valuable information
    3. last but not least, Why I have to choose Rel 2 instead of Rel 1.

    Your valuable inputs will be well considered.
    Thanks in advance
    Madhu Reddy
    xdollor@yahoo.com

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Originally posted by mrvajrala
    Hello All,

    We have a plan to upgrade one of the database which is running on 8.0.4 ( an unsupported version from ORACLE ), to the latest version 9i Rel 2. Here i would like to know the following from your expertise.

    0. Any Known issues
    Fresh out of shelfs, vrey premature to determine any issues


    1. Steps invloved in my situation
    Follow the
    http://otn.oracle.com/docs/products/...a96530/toc.htm



    3. last but not least, Why I have to choose Rel 2 instead of Rel 1.
    Most of the major bugs on Rel.1 are fixed on Rel.2



    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Feb 2001
    Posts
    290
    Thanks Sambavan,

    We would like to go for manual upgrade , instead of migration tool, that is why i have major concern about the issues invloved, do you have a step by step approach document which can be shared with me ??

    Or anybody ??

    your help will be very much appreciated
    Madhu Reddy
    xdollor@yahoo.com

  4. #4
    Join Date
    Apr 2002
    Posts
    291
    Hi,
    If you are creating your DB through DBCA, then no worries, but be sure to specify the undotbs and its retention also. From here onwards, u have no RBS and set the UNDOTBS Auto allocate uniform. Whats your OS? for the tablespaces, you can give extent management as local with some uniform size and segment space management as auto.
    And this is very early to come out with any issues for Rel2. If you are on Unix, you can have a minimum of 2 Gigs SGA.

    For any further info, go to OTN. you will get much more

    PNRDBA

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    we followed

    http://metalink.oracle.com/metalink/...&p_id=159657.1

    to upgrade two database from 9.0.1 to 9.2 however this note is also for 8.x databases


  6. #6
    Join Date
    Feb 2001
    Posts
    290
    Thanks Pando,

    It is a fantastic document.. It will come handy for me

    Thanks again
    Madhu Reddy
    xdollor@yahoo.com

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