upgrade to oracle 11g

Posted on 2009-04-16
Last Modified: 2013-11-11
I was going through the doc for DBUA upgrade to from on windows and come to know Timezone is very important factor.I check my for version of timezone and its shows me 3 and in the doc it is written it if time zone file is less than 4 then apply patch 5632264. my question is that if i go with DBUA(Direct) upgrade to from on window then i have give the patch to the or it is only for Manual upgrade methods.
I am not sure.

If i go for DUBA upgrade then DBUA is the one who wud take car himself for the timezone and make timezone version 3 to timezone version 4 .
Question by:N_sharma27
    LVL 47

    Expert Comment

    First upgrade to and the timezones will be there.

    Author Comment

    ok sir thankyou

    Author Comment

    one small think is in my mind, after upgrading to and then i will go for upgrade to
    after upgrading to 11, can i delete the databases on which has been upgarded to
    LVL 47

    Accepted Solution

    Upgrade will repair the timezones, nomater which upgrade (to or to
    make a full cold back up before this if you use DBUA.
    It is hard task and there is no quarantee you will succeed.
    So the best way is to use Export/import way migrating to 11g.
    Because before to upgrade you can check if the export dump file works,
    how it works and so you will be sure that you can either return to 10g or  
    move to 11g.
    Set NLS_LANG on both DBs before this to avoid losing of nonEnglish letters (if any)!

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    Via a live example, show how to take different types of Oracle backups using RMAN.
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now