• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1070
  • Last Modified:

upgrade to oracle 11g

I was going through the doc for DBUA upgrade to 11.1.0.6.0 from 10.2.0.3.0 on windows and come to know Timezone is very important factor.I check my 10.2.0.3.0 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 11.1.0.6.0. from 10.2.0.3.0 on window then i have give the patch to the 10.2.0.3.0. 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 .
0
N_sharma27
Asked:
N_sharma27
  • 2
  • 2
1 Solution
 
schwertnerCommented:
First upgrade to 10.2.0.4 and the timezones will be there.
0
 
N_sharma27Author Commented:
ok sir thankyou
0
 
N_sharma27Author Commented:
one small think is in my mind, after upgrading to 10.2.0.4.0 and then i will go for upgrade to 11.1.0.6.0
after upgrading to 11, can i delete the databases on 10.2.0.4.0 which has been upgarded to 11.1.0.6.0.
0
 
schwertnerCommented:
Upgrade will repair the timezones, nomater which upgrade (to 10.2.0.4 or to 11.1.0.6)
BUT
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)!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now