upgrade to 10G
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: upgrade to 10G

  1. #1
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840

    upgrade to 10G

    Hi Friends,
    Our company is planing to upgrade from 8.1.7.4 to 10G.
    Can u please guide me to some document for the same and also what all patches needs to be applied.

    Also we are not use LMT, its still dictionary managed tablespaces.
    Our oracle db is on solars 2.8.

    Thanks in advance.

    regards
    anandkl
    anandkl

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    the migration guide available at tahiti.oracle.com

  3. #3
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    Hi anandkl,

    i am just sharing my experience since i also recently upgraded from 8.1.7.3 to 10g . i recommend don't go with ASM instance , i have opened some bugs for duplicating database when asm is enabled . and just fixed another bug of SGA not able to grow more than 4GB on windows environment. i am using 10.1.0.3, though.

    i suggest you wait for nexct release of 10g database. since we wasted lot of time following these bugs.

  4. #4
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    hi friends,

    We also wanted to migrate our 8.1.7 DB on AIX 4.3.3 to 10g AIX 5L.
    Maybe i will skip some new features in 10g (which might have some bugs?) and use the features available or stable in 9i? is ASM just
    new to 10g?
    Another concern is...what parameter settings should i carry or copy
    from my old 8.1.7 init.ora to the 10g spfile.ora? One thing im sure
    of is the process,shared_pool,... any other signicant ones?

    Thanks a lot

  5. #5
    Join Date
    Jan 2003
    Location
    Delhi
    Posts
    63
    Hi Kris,

    Instead of assigning values for SHARED_POOL_SIZE, DB_CACHE_SIZE,LARGE_POOL_SIZE,JAVA_POOL_SIZE
    You can assign value to sga_target , which will take care of all the 4 parameters .

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