Newbie for database Upgrade
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Newbie for database Upgrade

  1. #1
    Join Date
    Dec 2002
    Posts
    89

    Newbie for database Upgrade

    This is the first time I am involved in database upgrade process, so please help me if I miss any step..
    Database upgrade from 9i to 10g rel2 same os ( windows)

    Preparing to upgrade
    -- run utlu102i.sql on 9i env. and check for erros/suggestion
    -- gather stats
    -- shutdown database
    -- exp userid= full=y

    Upgrade database
    -- Install 10g software
    -- made necessary changes to init.ora, create sysaux ...etc
    -- import

    Question

    will this import system object from 9i?
    also do I have to startup database after import with upgrade option?
    also do I have to run catupgrd.sql?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    why not just run dbua?

  3. #3
    Join Date
    Dec 2002
    Posts
    89
    Because I have to recreate tablespace to alter SEGMENT SPACE MANAGEMENT from MANUAL TO AUTO

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    so? you can do that after

  5. #5
    Join Date
    Dec 2002
    Posts
    89
    I am trying to prevent another outage

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    that doesnt make sense, upgrade using dbua and do your work - one outage

  7. #7
    Join Date
    Dec 2002
    Posts
    89
    So u mean upgrade with DBUA and then exp and imp.

    Still I won't to know what method others follow for their database upgrade.

  8. #8
    Join Date
    May 2005
    Location
    AZ, USA
    Posts
    131
    Quote Originally Posted by kpate
    Still I won't to know what method others follow for their database upgrade.
    Most refer to the documentation when doing upgrades:

    http://download.oracle.com/docs/cd/B...o.htm#sthref10


    To Quote the Propaganda:

    Note:

    The DBUA is the recommended method for upgrading a database. Beginning with release 10.2, you can also use the DBUA to upgrade to a new patch release of Oracle 10g release 2.

  9. #9
    Join Date
    Dec 2002
    Posts
    89
    Question to davey23uk

    If I choose DBUA method to upgrade database.

    How the tablespace can be altered to SEGMENT SPACE MANAGEMENT AUTO.

    Is there anyway except exp/imp?

  10. #10
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    alter table move
    create table as select

    many ways

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