Move to Oracle Database 11g – The whole Story
Roy Swonger, Carol Tagliaferri, Mike Dietrich
Database Upgrade & Utilities
ORACLE Corporation
Welcome!!!
Upgrade Development Group
Aalok Muley, PTS
Agenda
Preparation
Upgrade
News and Task List
Tuning
Performance Testing
Best Practices
Agenda
Preparation
Support Policy
Patches
Upgrade Certification
Documentation
Upgrade paths
News and Task List Installation
Editions
Tuning
Performance Testing
Best Practices
Lifetime Support Policy
today
August 2012 August 2015
July 2010 July 2013
R2
January 2009 January 2012
Sustaining Support
Premier Support Extended Support
R2 July 2007 July 2008 July 2010
t
2011
2013
2014
2002
2003
2004
2005
2006
2007
2008
2009
2010
2012
2016
2015
http://www.oracle.com/support/library/brochure/lifetime-support-technology.pdf
Lifetime Support Policy
• See:
http://www.oracle.com/support/library/brochure/lifetime-
support-technology.pdf
Releases – Support-SRs
9%
Upgrade to Oracle Database 11g
≥ 7.3.4
≥ 7.3.4
R2
R2
≥ 9.2.0.4
≥ 9.2.0.4
≥ 8.0.6
≥ 8.0.6
≥ 8.1.7.4
≥ 8.1.7.4
R2
R2
≥ 9.0.1.4
≥ 9.0.1.4
Recommended Patches
Important Alerts?
• Note 161818.1
Upgrade Information / Alerts
• Note:454507.1
Support Status and Alerts for Oracle 11g Release 1 (11.1.0.X)
Upgrade Information / Alerts
• Note 738538.1 Known Issues specific to the 11.1.0.7 Patch Set
Timezone Patches
• Why DST timezone patches? (DST: Daylight Savings Time)
• The date for moving to DST has been changed for 7 different
timezones since 2007
• HST - EST - MST - EST5EDT - MST7MDT - CST6CDT - PST8PDT
• Current DST definitions are included from within the following
patch set
• 10.2.0.4
• Oracle Database 11g requires timezone version V.4
• Oracle 9i: Timezone V1
• Oracle 10g: Timezone V2
• Without timezone V4 no upgrade to Oracle Database
11g will be possible!!!
Timezone Patches
• Summary – 4 important ML notes:
• Note 414590.1: FAQ and Issues
• Note 413671.1: Timezone V4 - Checks and Links to the Patches
•
• Note 359145.1: Links to download utltzuv2.sql
• Note 396387.1: Explanations
• Run script utltzuv2.sql to recognize TIMESTAMP WITH TIMEZONE
• Files timezone.dat and timezlrg.dat will be applied
Timezone Patches
• Timezone How To:
• Download the right patch according to the table in Note 413671.1
• Download the script utltzuv2.sql according to Note 359145.1
• Run the script utltzuv2.sql in your current source database
• Apply files timezone.dat and timezlrg.dat to the source
$ORACLE_HOME/oracore/zoneinfo directory with either Opatch
or manually and restart the database
Verify Database Creation Wordsize - 10.2.0.3
• Has the database been created originally in a 32-bit
environment and is now on a 64-bit platform?
•
select decode(instr(metadata,'B023'),0,
select decode(instr(metadata,'B023'),0,
'64bit Database','32bit Database') "DB Creation"
'64bit Database','32bit Database') "DB Creation"
from kopm$;
from kopm$;
• Happens in 10.2.0.3 - see Note:412271.1
• Apply patch:5871314 and patch:5892355 if:
• KOPM$.METADATA contains 'B023'
created in 32-bit env
• Don't apply patch if:
• KOPM$.METADATA contains 'B047'
created in 64-bit env
• Database version is 10.2.0.4
Related to Database Creation Wordsize - 11gR1
• Database upgrade to 11.1.0.6:
• Delete orphan rows from KOTTD$
• Apply patch 6770913
• Database upgrade to 11.1.0.7:
• Delete orphan rows from KOTTD$
• No patches necessary
select
select sys_nc_oid$ from kottd$ where sys_nc_oid$
sys_nc_oid$ from kottd$ where sys_nc_oid$
not in
not in (select oid$ from obj$ where type#=13);
(select oid$ from obj$ where type#=13);
• If result is not null:
delete from kottd$ where sys_nc_oid$ not in
delete from kottd$ where sys_nc_oid$ not in
(select oid$ from obj$ where type#=13);
(select oid$ from obj$ where type#=13);
commit;
commit;
• See Note:579523.1 - bug:6770913
Oracle Certification
•
Recommended OS patches
• Note: 169706.1
• Note: 401705.1 specifically for Linux