[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

upgrade to oracle 11g

Posted on 2009-04-16
4
Medium Priority
?
1,054 Views
Last Modified: 2013-11-11
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
Comment
Question by:N_sharma27
  • 2
  • 2
4 Comments
 
LVL 48

Expert Comment

by:schwertner
ID: 24167786
First upgrade to 10.2.0.4 and the timezones will be there.
0
 

Author Comment

by:N_sharma27
ID: 24177659
ok sir thankyou
0
 

Author Comment

by:N_sharma27
ID: 24177671
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
 
LVL 48

Accepted Solution

by:
schwertner earned 200 total points
ID: 24178467
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

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Suggested Courses

834 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