145
<Insert Picture Here> Oracle ISV Migration Center Вадим Мельников Консультант по базам данных Upgrade to Oracle Database 11g

Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

  • Upload
    others

  • View
    4

  • Download
    0

Embed Size (px)

Citation preview

Page 1: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

<Insert Picture Here>

Oracle ISV Migration Center

Вадим МельниковКонсультант по базам данных

Upgrade to Oracle Database 11g

Page 2: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

2

Database Upgrade

Fast & Simple

Page 3: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

3

Подготовка

План

Upgrade

Новое в 11g

Полезные советы

Page 4: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

4

Подготовка

План

Support PolicyПатчи

СертификацияДокументацияУстановка ПОРедакции ПО

Upgrade

Новое в 11g

Полезные советы

Page 5: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

5

t

2008

2003

2004

2005

2006

2007

2002

2009

2010

today

Lifetime Support Policy

2011

2012

2013

2014

Sustaining Support

Premier Support

R2 July 2007

Extended SupportJuly 2010

January 2009 January 2012

R2 July 2010 July 2013

http://www.oracle.com/support/library/brochure/lifetime-support-technology.pdf

2015

2016

August 2012 August 2015

July 2008

Page 6: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

6

Lifetime Support Policy

• http://www.oracle.com/support/library/brochure/lifetime-support-technology.pdf

Page 7: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

7

Oracle releases

11.1.0.6.0

Номер версииСУБД

Номер релизаСУБД

Номер релизаApplication Server

Patch set

Номерпромежуточного

патча

Page 8: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

8

9.2 10.2Release

Patch Set

Patches

9.2.0.2 9.2.0.3 9.2.0.8. . . 10.2.0.2 10.2.0.3 10.2.0.x. . .

CPU Ju

l07

Interim

patch

Update Update

Upgrade

Releases, Patch Sets, Patches

Разные типы патчей:

Page 9: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

9

Upgrade to 11g

R2R2

≥≥≥≥ 7.3.47.3.47.3.47.3.4≥≥≥≥ 7.3.47.3.47.3.47.3.4

≥≥≥≥ 9.2.0.49.2.0.49.2.0.49.2.0.4≥≥≥≥ 9.2.0.49.2.0.49.2.0.49.2.0.4

≥≥≥≥ 8.0.68.0.68.0.68.0.6≥≥≥≥ 8.0.68.0.68.0.68.0.6

≥≥≥≥ 8.1.7.48.1.7.48.1.7.48.1.7.4≥≥≥≥ 8.1.7.48.1.7.48.1.7.48.1.7.4

≥≥≥≥ 9.1.0.49.1.0.49.1.0.49.1.0.4≥≥≥≥ 9.1.0.49.1.0.49.1.0.49.1.0.4

R2R2

Page 10: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

10

Patches

• Patch level исходной БД:• Upgrade to Oracle Database 10gR2:8.1.7.4 ... ≥ 9.0.1.4 ... ≥ 9.2.0.4 ... ≥ 10.1.0.2

• Upgrade to Oracle Database 11g:≥ 9.2.0.4 ... ≥ 10.1.0.2 ... ≥ 10.2.0.1

• Установите последний patch set перед началомобновления версии.

• Проверьте наличие внутренних патчей

• Не забывайте про патчи ОС !

Page 11: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

11

Recommended Patches

Page 12: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

12

• Зачем нужны timezone патчи? (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 followingpatch 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

Page 13: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

13

• Note 161818.1

Important Alerts?

Page 14: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

14

• Note 316900.1Support Status and Alerts for Oracle 10g Release 2 (10.2.0.X)

Upgrade Information / Alerts

Page 15: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

15

• Note 555579.1Known Issues specific to the 10.2.0.4 PatchSet

Upgrade Information / Alerts

Page 16: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

16

Verify Database Creation Wordsize

• Что проверить при смене разрядности с 32 на 64 бит:•

• Результат содержит 'B023'� created in 32-bit env – applypatch

• Результат содержит 'B047' � created in 64-bit env – no patch

• See Note:579523.1 (patch:6770913)

select decode(instr(metadata,'B023'),0,

'64bit Database','32bit Database') "DB Creation"

from kopm$;

select decode(instr(metadata,'B023'),0,

'64bit Database','32bit Database') "DB Creation"

from kopm$;

Page 17: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

17

Oracle Certification

Page 18: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

18

Upgrade проще!

• Upgrade на Oracle Database 11g - легче чем напрошлые версии Oracle

• Size of Upgrade guides:• 8.1.7 - 512 pages

• 9.0.1 - 484 pages – 111 steps for an RDBMS with 9 components

• 9.2.0 - 344 pages

• 10.1.0 - 170 pages - only 6 stepsl!!!

• 10.2.0 - 140 pages

• 11.1.0 - 186 pages - now detailed explanations andinformation about new options included

Page 19: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

19

Документация

• Documents to study before you start?

• PDF

• HTML

• Note:429825.1Complete Checklist for Manual Upgrades to 11gR1

• Note: 421191.1CompleteCompleteCompleteComplete checklistchecklistchecklistchecklist forforforfor manualmanualmanualmanual upgradesupgradesupgradesupgrades fromfromfromfrom X to YX to YX to YX to Y

Page 20: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

20

Документация

• Note: 466181.1 Upgrade Companion 10gR2

• Note: 601807.1 Upgrade Companion 11g

Page 21: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

21

Подготовка

• Найдите объекты в состоянии INVALID:

Перекомпилируйте объекты скриптом ultrp.sql

• Подготовьте результаты критичных запросов• Comparison: before↔ after• Time specific queries and batches

• Сделайте тестовый upgrade• Проведите функциональные тесты• И тесты на производительность с реальной нагрузкой!!!

SQL> SELECT UNIQUE object_name, object_type, ownerFROM dba_objects WHERE status='INVALID';

SQL> SELECT UNIQUE object_name, object_type, ownerFROM dba_objects WHERE status='INVALID';

Page 22: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

22

Подготовка

• Соберите статистику по словарю данных – это поможетускорить процесс обновления

• Дополнительную информацию можно получить тут:Oracle® Database Upgrade Guide Appendix B

• Или / :

SQL> EXECUTE dbms_stats.gather_schema_stats('SYS',options => 'GATHER',estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,method_opt => 'FOR ALL COLUMNS SIZE AUTO',

cascade => TRUE);

SQL> EXECUTE dbms_stats.gather_schema_stats('SYS',options => 'GATHER',estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,method_opt => 'FOR ALL COLUMNS SIZE AUTO',

cascade => TRUE);

SQL> EXECUTE dbms_stats.gather_dictionary_stats;SQL> EXECUTE dbms_stats.gather_dictionary_stats;

Page 23: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

23

Подготовка

• Отключите DATABASE VAULT (если используется)• Oracle® Database Vault Administrator's Guide: Appendix B

• Unix: (simplified)

• Relinking without Database Vault[$ make -f ins_rdbms.mk dv_off ]

• Windows:

• Rename oradv10.dll in ORACLE_HOME\bin

• Upon restart:

• After upgrading relink with dv_on or rename the DLL and enableDatabase Vault again:

$ dvca -action disable ...$ dvca -action disable ...

$ dvca -action disable ...$ dvca -action disable ...

$ dvca -action enable ...$ dvca -action enable ...

Page 24: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

24

Установка ПО

• Системные требования• Software installation:

• 150-200 MB in /tmp or \TEMP necessary

• Seed database: ≥ 1,6 GB

• RAM: ≥ 1GB• Swapspace

• RAM between 513Mb and 2048Mb → 1.5x RAM

• RAM between 2049Mb and 8192Mb → 1x RAM

• RAM more than 8192Mb → 0.75x RAM

Example: Linux

Page 25: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

25

Установка ПО

• Системные требования• Oracle executable binary - comparison done on Linux 32-bit x86:

• 8.1.7.4: 26 MB

• 9.0.1: 37 MB

• 9.2.0.4: 49 MB

• 10.2.0.3: 91 MB

• 11.1.0.6: 144 MB

Page 26: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

26

Установка ПО

• How to access the software?• Download from OTN:http://otn.oracle.com/software/index.html

• Metalink:

http://edelivery.oracle.com/

Page 27: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

27

Установка ПО

• DVD contents?• Database

• Enterprise Edition

• Standard Edition

• Personal Edition (Windows)

• Client

• Clusterware

• Extra: Examples (formerly known as companion)• Required Products• Oracle Globalization Support Demos• Oracle Multimedia Demos• Oracle Precompiler Demos• Oracle Spatial Demos• Oracle SQLJ Demos• Oracle XML Demos• Oracle JDBC Development Drivers• Oracle Text Knowledge Base

Page 28: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

28

Установка ПО

• Download from OTN:

Page 29: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

29

Установка ПО

• Pre-installation checks:

• Warning: 500MB swap space needed – also on Windows!!!

• Ignore the result:./runInstaller -ignoreSysPrereqs

Page 30: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

30

Установка ПО

Page 31: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

31

Установка ПО

Page 32: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

32

Установка ПО

Page 33: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

33

Установка ПО

Important:„CUSTOM“ ALWAYS installs

Enterprise Edition

Important:„CUSTOM“ ALWAYS installs

Enterprise Edition

Page 34: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

34

Установка ПО

• Custom installation:• 10gR2 doc installation guide

• 11gR1 doc installation guide

Page 35: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

35

Установка ПО

• Различия между редакциями Oracle Database • Feature differences:Note.465465.1Differences Between Enterprise, Standard and Personal Editions on Oracle 10.2

Note.465460.1Differences Between Enterprise, Standard and Personal Editions on Oracle 11.1

• Oracle® Database Licensing Information11g Release 1 (11.1)Part Number B28287-01

http://download.oracle.com/docs/cd/B28359_01/license.111/b28287/editions.htm

Page 36: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

36

Standard Edition ONE (SEone)Install "Standard Edition" software from DVD

Установка ПО

Socket

Socket

Page 37: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

37

Standard Edition (SE)� includes RAC and requires

• ASM (no LVM!!!)• Oracle Clusterware

Установка ПО

Socket

Socket

Socket

Socket

Page 38: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

38

Enterprise Edition (EE)• Data Guard• Flashback Database• Resource Manager• Parallel Backup/Recovery• Oracle Clusterware• SQL Plan Management• Virtual Private Database

+licensable options+ Partitioning+ RAC+ Spatial Data+ Active Data Guard+ Total Recall+ Real Application Testing+ Advanced Security Option+ Database Vault+ several database packs+ ...

Установка ПО

Page 39: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

39

Установка ПО

Personal EditionWindows only - funсtionality like EE

Page 40: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

40

eXpress Edition (XE)• Only downloadable from OTN• No license fees• Support available only via OTN forum• Supports max.:

• 1GB RAM• 4GB database size (user data)• 1 CPU• 1 database instance per server

Установка ПО

Page 41: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

41

Установка ПО

Page 42: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

42

Установка ПО

Page 43: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

43

Установка ПО

Page 44: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

44

Установка ПО

Page 45: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

45

Установка ПО

Page 46: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

46

Установка ПО

Page 47: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

47

Установка ПО

• Windows OS - Home Selector :

Page 48: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

48

Подготовка

План

UpgradeМетоды Upgrade

Database Upgrade Assistant

Command Line Upgrade

Alternatives

ASM Upgrade

Новое в 11g

Полезные советы

Page 49: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

49

Методы Upgrade

• Требуется много усилий поподготовке

• Существует много ограничений

• Очень быстроTTS, SQL Apply,

Standby, etc..

• Только структура и данные –остальное вручную

• Не зависит от платформыSQL*Plus-COPY,

CTAS and Scripts

• Процесс занимает существенноевремя для больших БД

• Требуется дисковое пространстводля дамп-файла

• Reorganisation

• Можно сменить ОС

• Возможность для Oracle 5/6

Full Export/Import

• Не предусмотрена возможностьсмены ОС

• Больше ручной работы

• Полный контроль

• В случае ошибки : простоперезапустить upgrade script

Upgrade by script (CLI)

• В случае непредвиденных ошибокupgrade приходится делать вручнуючерез скрипты

• Ограниченные возможности дляуправления

• Не предусмотрена возможностьсмены ОС

• Проще и короче

• Происходит автоматически

• Проверки ресурсов / доступногоместа

• Изменения параметров

• Подробный error log

Oracle Database

Upgrade Assistant

(GUI)

(-) Недостатки(+) Преимущества

Oracle rec

ommended

Page 50: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

50

Подготовка

План

UpgradeМетоды Upgrade

Database Upgrade Assistant

Command Line Upgrade

Alternatives

ASM Upgrade

Новое в 11g

Полезные советы

Page 51: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

51

Database Upgrade Assistant (GUI)

• Преимущества:• Наглядная индикация

• Автоматизирует множество важных проверок

• RAC aware - inclusion of all nodes• for RAC (almost) a must !!!

• Возможность Offline Backup и Restore

• ASM upgrade

• Oracle XE upgrade

• Patch upgrades

• Silent mode:$ dbua –help shows all valid options

• Documentation:• Oracle® Database Upgrade Guide

Page 52: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

52

Database Upgrade Assistant (GUI)

Page 53: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

53

Database Upgrade Assistant (GUI)

Page 54: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

54

Database Upgrade Assistant (GUI)

Page 55: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

55

Database Upgrade Assistant (GUI)

Page 56: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

56

Database Upgrade Assistant (GUI)

Page 57: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

57

Database Upgrade Assistant (GUI)

Page 58: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

58

Database Upgrade Assistant (GUI)

Page 59: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

59

Database Upgrade Assistant (GUI)

Page 60: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

60

Database Upgrade Assistant (GUI)

Page 61: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

61

Database Upgrade Assistant (GUI)

Page 62: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

62

Database Upgrade Assistant (GUI)

Page 63: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

63

Database Upgrade Assistant (GUI)

From 11g on alwaysSECURESECURESECURESECURE

From 11g on alwaysSECURESECURESECURESECURE

Page 64: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

64

Database Upgrade Assistant (GUI)

Page 65: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

65

Database Upgrade Assistant (GUI)

Page 66: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

66

Database Upgrade Assistant (GUI)

Page 67: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

67

Database Upgrade Assistant (GUI)

Page 68: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

68

Database Upgrade Assistant (GUI)

Page 69: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

69

Database Upgrade Assistant (GUI)

Page 70: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

70

Database Upgrade Assistant (GUI)

Page 71: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

71

Database Upgrade Assistant (GUI)

Page 72: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

72

Database Upgrade Assistant (GUI)

Page 73: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

73

Database Upgrade Assistant (GUI)

Page 74: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

74

Database Upgrade Assistant (GUI)

Page 75: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

75

Database Upgrade Assistant (GUI)

Page 76: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

76

Подготовка

План

UpgradeМетоды Upgrade

Database Upgrade Assistant

Command Line Upgrade

Alternatives

ASM Upgrade

Новое в 11g

Полезные советы

Page 77: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

77

Command Line Upgrade

• Как это работает, step-by-step:1. Complete online backup of the database

2. Install 11g Oracle software

3. Analyze the DB using utlu111i.sql and follow all requirements given by the script

4. Create a new listener with NETCA

5. Switch to the new environment, startup the DB (startupupgrade) and create the SYSAUX tablespace (if source db isan Oracle 9i db)

6. Run upgrade script catupgrd.sql and afterwards recompile: utlrp.sql

7. Check the post upgrade status: utlu111s.sql

8. Run catuppst.sql if you are upgrading from 10g

Page 78: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

78

Command Line Upgrade

• Upgrade information script: utlu111i.sql• Выполняется на исходной БД

• Проверяет все init параметры и показывает предупреждения о obsolete или deprecated параметрах

• Проверяет

• Компоненты

• Табличное пространство SYSAUX

• Кодировку

• Версию Timezone file

• Cluster check

Info

Page 79: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

79

Command Line Upgrade

• utlu111i.sql: Информация о БД и проверка timezone? (see also PREPARATION)

• DST (Daylight Savings Time) patches for Version V4 have to haveapplied as a requirement for the upgrade to Oracle Database 11g

Page 80: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

80

Command Line Upgrade

•utlu111i.sql: Достаточно ли размера Tablespaces?

Page 81: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

81

Command Line Upgrade

•utlu111i.sql: Изменения параметровинициализации?

Page 82: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

82

Command Line Upgrade

• utlu111i.sql: Компоненты и опции?

• Внимание:Необходимо установить все опции который присутствуют врелизе с которого выполняется Upgrade

Page 83: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

83

Command Line Upgrade

•utlu111i.sql: Дополнительные предупреждения?

Page 84: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

84

Command Line Upgrade

• Create Dictionary statistics

• Shutdown the database (IMMEDIATE/NORMAL)

• Adjust init parameters:• COMPATIBLE ≥ 10.0.0

• SGA_TARGET ≥ 340MB (32-bit) ... ≥ 640MB (64-bit)

• PGA_AGGREGATE_TARGET ≥ 25MB

• LOG_ARCHIVE_FORMAT must contain %s, &t and %r

• Move init.ora/SPFILE and PWDsid.ora to their new location

• Create a new 11g-Listener (use the NETCA)

• Change environment to point to the new $ORACLE_HOME

Page 85: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

85

Command Line Upgrade

• Windows only:• Delete the old Service:

> oradim -DELETE -SID ORCL

• Create a new Service:

> oradim -NEW-SID ORCL-SYSPWD passwrd-STARTMODE a-PFILE initfile

ORADIM creates a logfile in %ORACLE_HOME%\database

Page 86: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

86

SQL> STARTUP UPGRADE;SQL> STARTUP UPGRADE;

• Supresses unnecessary error messages likeORA-00942: table or view does not exist -thus logfiles will be easier to read and check

Command Line Upgrade

Taken from an example alert.log

Page 87: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

87

Command Line Upgrade

• Create tablespace SYSAUX (only if source is a 9i db) :

SQL> CREATE TABLESPACE sysauxDATAFILE 'file' SIZE 500MEXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTOONLINE;

SQL> CREATE TABLESPACE sysauxDATAFILE 'file' SIZE 500MEXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTOONLINE;

Page 88: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

88

Command Line Upgrade

• Единый update скрипт для всех релизов и компонентов:

• Useful:

SQL> @catupgrd.sqlSQL> @catupgrd.sql

SQL> SPOOL c:\temp\upgrade.logSQL> SPOOL c:\temp\upgrade.log

Page 89: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

89

• Перекомпиляция:• utlrp.sql

• Calls utlprp.sql with CPU_COUNT-1

• Determines automatically if serial or parallel recompilation with multiple threads can be done

• Recompiles all INVALID objects

• Utilizes package utl_recomp

• Re-enables functional indixes automatically

• utlprp.sql can be called directly like:

• SQL> utlprp 7

• This can be useful to minimize CPU usage

Command Line Upgrade

Page 90: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

90

• Post upgrade script: utlu111s.sql• Выполняется в среде 11g

• Проверяет результаты обновления с помощью DBA_REGISTRY

• Показывает хинты и доп. информацию в случае неудачногообновления какого из компонентов

• Показывает сколько времени было затрачено на каждыйкомпонент и в целом на Upgrade

Command Line UpgradeStatus

Page 91: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

91

Command Line Upgrade

• Post upgrade script: utlu111s.sql

Page 92: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

92

Подготовка

План

UpgradeМетоды Upgrade

Database Upgrade Assistant

Command Line Upgrade

Alternatives

ASM Upgrade

Новое в 11g

Полезные советы

Page 93: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

93

Upgrade Alternatives

• Export/Import

• DataPump

• Transportable Tablespaces

• Logical Standby

Page 94: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

94

Upgrade Alternatives

• Export/Import• Универсальный способ

• Import возможен для ≥ Oracle V5

• Export не поддерживается в Oracle 11g

• Отнимает много времени и ресурсов

• Полезно использовать для:• Изменения кодировки БД

• Изменения платформы или ОС

• Объединения схем

• Для всех релизов upgrade которых не поддерживается(непример 8.1.6)

Page 95: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

95

Upgrade Alternatives

• Export/Import• Смена кодировки

• Changing the Database Character SetNote: 225912.1

• Use Scanner Utility CSscan before altering the DB CharactersetNote: 123670.1

• Unicode

• Problematic can be:Umlaut Ä in WE8ISO... = 1 ByteUmlaut Ä in UTF8 = 2 Byte

• UTF8 Database Character Set ImplicationsNote: 119119.1

• WE8ISO8859P1 ==> P15: Note 257722.1

• Characterset Migration - White Paper:• http://www.oracle.com/technology/tech/globalization/pdf/mwp.pdf

Page 96: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

96

Upgrade Alternatives

• Hints and tricks• Dump - всегда BINARY mode

• Import длится примерно в 3x раза дольше чем Export• Всегда делайте Export утилитами самого старого релиза• Всегда делайте Import imp целевой БД

• Export performance• DIRECT=Y ... bypasses SQL-Layer, but no conversions!• RECORDLENGTH=64KB ... amount of data written to disk• Распараллельте экспорт разделив данные логически

• Import performance• BUFFER=xy ... но не слишком большой - swapping !!• INDEXES=N ... индесксы можно создать позже... INDEXFILE=...

• Параметр commit_write=NOWAIT

Page 97: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

97

Upgrade Alternatives

• Data Pump• Преимущество:

• Намного быстрее и больше возможностей чем у exp/imp

• Как это использовать? :• impdp работает через database link – экономим на записи надиск

• Это удобно:+ Сохраняются все преимущества использования datapump+ Dump файл не создается (so no additional IO)+ Очень просто- Работает с версиями ≥ 10.1.0.2

• For documentation see:Oracle® Database Utilities

• Further information and examples: Note:553337.1

IMPDP usr1/password NETWORK_LINK=db_link1 FULL=Y IMPDP usr1/password NETWORK_LINK=db_link1 FULL=Y

Page 98: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

98

Upgrade Alternatives

• Transportable Tablespaces• Преимущество:

• Время простоя - минимально

• Как это использовать? :• Tablespaces и метаданные переносятся из одной БД в другую ипросто подключаются там

• Это удобно :+ Очень быстро- Нельзя использовать для SYSTEM+SYSAUX tablespaces.- Появляются дополнительные задачи - перенести views, synonyms и т.д. в новую БД

• Информация с OTN:• Amadeus Customer Case• White Paper: TTS Upgrade 10.2• White Paper: TTS OS-Migration 10.2

Page 99: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

99

Upgrade Alternatives

• TTS concept since Oracle 8i

Target DBSource DB

imp meta data

Copy datafiles

exp meta data

Read Only

Read Write

Page 100: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

100

Upgrade Alternatives

• TTS x-platform (v$transportable_platform):

FILE

COPY

FILE

COPY

Big EndianLittle Endian RMANconvert

HP Open VMSHP Tru64 UNIX

Linux IA (32-bit)Linux IA (64-bit)Linux 64-bit for AMD

Microsoft Windows IA (64-bit)Microsoft Windows 64-bit for AMDMicrosoft Windows IA (32-bit)

Solaris Operating System (x86)

Apple Mac OS

HP-UX (64-bit)HP-UX IA (64-bit)

AIX-Based Systems (64-bit)IBM zSeries Based LinuxIBM Power Based Linux

Solaris[tm] OE (32-bit)Solaris[tm] OE (64-bit)

Page 101: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

101

Upgrade Alternatives

Source DB

Import non-segment

user data (views etc.)

10.2.0.4 11.1.0.6

Target DB

Create new

Transport

Page 102: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

102

Upgrade Alternatives

• Logical Standby (Data Guard)• Преимущество :

• Минимальное время простоя

• Как это использовать? :• Сначала Upgrade делается на standby

• Далее: Switchover - standby становится production

• Upgrade ex-production - switchover обратно

• Это удобно :+ Время простоя ~2min на оба переключения

- Нельзя сменить платформу или ОС

- Ограничения Logminer на некоторые типы данных

- Требуется первоначальная настройка, версия релизаproduction должна быть ≥ 10.1.0.3

Page 103: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

103

Logical Standby configuration

Clients Redo

10.1.0.3 10.1.0.3

1

LP

Switchover (role change),

then upgrade on L (ex-P)

Redo

4

Upgrade

11.1.0.711.1.07

PL

"Mixed setup" for testing

Redo

3

11.1.0.710.1.0.3

P L

Upgrade node L to 11.1

Upgrade

Log

ARCH

10.1.0.3

2

11.1.0.7

P L

Upgrade Alternatives

Page 104: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

104

Подготовка

План

UpgradeМетоды Upgrade

Database Upgrade Assistant

Command Line Upgrade

Alternatives

ASM Upgrade

Новое в 11g

Полезные советы

Page 105: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

105

ASM Upgrade using DBUA

Page 106: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

106

ASM Upgrade using DBUA

Page 107: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

107

ASM Upgrade using DBUA

Page 108: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

108

ASM Upgrade using DBUA

Page 109: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

109

ASM Upgrade using DBUA

Page 110: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

110

ASM Upgrade using DBUA

Page 111: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

111

ASM Upgrade using DBUA

Page 112: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

112

Подготовка

План

Upgrade

Новое в 11g

Полезные советы

ПараметрыПроцессы

ПрочееИнструменты

Page 113: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

113

Параметр COMPATIBLE

• COMPATIBLE has to be at least 10.0.0 for an 11g database

• No way back once ≥11.0.0 has been enabled• Supported release downgrade only down to 10.0.0

• Supported patch downgrade only down to 11.0.0

• No ALTER DATABASE RESET COMPATIBILITY command anymore

COMPATIBLE = 10.0/1/2.0COMPATIBLE = 10.0/1/2.0

COMPATIBLE = 11.0.0COMPATIBLE = 11.0.0

Page 114: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

114

Параметр COMPATIBLE

• DBUA raises COMPATIBLE only for 9i databases to 10.0.0

• To enable Oracle 11g features:

• Afterwards restart the database

• New features will be enabled

• Datafile headers will be adjusted

• Redologfiles will be adjusted during first access

SQL> alter systemset compatible='11.1.0' scope=spfile;

SQL> alter systemset compatible='11.1.0' scope=spfile;

Page 115: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

115

Параметры

• Number of init parameter having changed:

3430New

330Obsolete

1117Deprecated

11g10g1+2

Page 116: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

116

Новые параметры 11g

New in 11gsee: Oracle® Database Reference

ASM_PREFERRED_READ_FAILURE_GROUPSCLIENT_RESULT_CACHE_LAGCLIENT_RESULT_CACHE_SIZECOMMIT_LOGGINGCOMMIT_WAITCONTROL_MANAGEMENT_PACK_ACCESSDB_LOST_WRITE_PROTECTDB_SECUREFILEDB_ULTRA_SAFEDDL_LOCK_TIMEOUTDIAGNOSTIC_DESTGLOBAL_TXN_PROCESSESJAVA_JIT_ENABLEDLDAP_DIRECTORY_SYSAUTHMEMORY_MAX_TARGETMEMORY_TARGETOPTIMIZER_CAPTURE_SQL_PLAN_BASELINES

OPTIMIZER_USE_INVISIBLE_INDEXESOPTIMIZER_USE_PENDING_STATISTICSOPTIMIZER_USE_SQL_PLAN_BASELINESPARALLEL_IO_CAP_ENABLEDPLSCOPE_SETTINGSREDO_TRANSPORT_USERRESOURCE_MANAGER_CPU_ALLOCATIONRESULT_CACHE_MAX_RESULTRESULT_CACHE_MAX_SIZERESULT_CACHE_MODERESULT_CACHE_REMOTE_EXPIRATIONSEC_CASE_SENSITIVE_LOGONSEC_MAX_FAILED_LOGIN_ATTEMPTSSEC_PROTOCOL_ERROR_FURTHER_ACTIONSEC_PROTOCOL_ERROR_TRACE_ACTIONSEC_RETURN_SERVER_RELEASE_BANNERXML_DB_EVENTS

ES

Page 117: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

117

Новые параметры - Selection

• MEMORY_TARGET and MEMORY_MAX_TARGET

• Default: 0

• Value: integer [K | M | G]

• Purpose:Specifies the complete plus the maximum memoryavailable to the Oracle server

SGA_TARGETSGA_TARGET

SGA_MAX_SIZESGA_MAX_SIZE

MEMORY_MAX_TARGETMEMORY_MAX_TARGET

MEMORY_TARGETMEMORY_TARGET

PGA_AGGREGATE_TARGETPGA_AGGREGATE_TARGET

Page 118: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

118

Подготовка

План

Upgrade

Новое в 11g

Полезные советы

ПараметрыПроцессы

ПрочееИнструменты

Page 119: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

119

Новые фоновые процессы

ASMMaintains disk membership in ASM disk groupsGMON

ALL.The process archives historical rows for tracked tables into flashback data archives and manages the

flashback archives. FBDA

ALL with any

registered event

activity

(optional non-fatal)

The Event Monitor Coordinator coordinates the event management and notification activity in the database which includes Streams Event Notifications, Continuous Query Notifications and Fast

Application Notifications.

EMNC /

e0xx

ALLPerforms diagnostic dumps and executes global oradebug commands.

DIAG

ALLResponsible for hang detection and deadlock resolution.

DIA0

ALLThe Resource Manager process is responsible for setting Resource Plans and other Resource Manager

related tasks. DBRM

RAC

In an RAC environment, this per-instance process (Atomic Controlfile to Memory Service) is an agent which contributes to ensuring a distributed SGA memory update is either globally committed on success

or globally aborted in the event of a failure. ACMS

RAC onlyProvides transparent support for XA global transactions in a RAC environment. The database autotunes the number of these processes based on the workload of XA global transactions. GTX0-j

Description FoundProcess

Name

Page 120: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

120

Новые фоновые процессы

RAC onlyThe RAC Management Processes perform manageability tasks for RAC, e.g. creation of RAC related

resources when new instances are added to the clusters RMSn

RAC only

In a RACenvironment, this process manages background slave process creation and communication on remote instances. These background slave processes perform tasks on behalf of a coordinating process

running in another instance. RMSN

ALLThe Virtual Keeper of TiMe

?is responsible for providing a Wall-Clock time (updated every second) and

Reference-Time Counter (updated every 20ms and available only when running at elevated priority). VKTM

ALL (optional non-

fatal)

The space management coordinator process coordinates the execution of various space management related tasks, such as proactive space allocation and space reclamation. It dynamically spawns slave

processes (Wnnn) to implement the task.

SMCO /

Wnnn

ASM, spawned on

demand.Marks ASM Allocation Units as stale following a missed write to an offline disk. MARK

ASM, spawned on

demand.Performs proxy I/O to an ASM metafile when a disk becomes offline.KATE

Spawns Oracle processes.

Description

ALLPSP0

FoundProcess

Name

Page 121: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

121

• Example:

Background Processes

select name, description from v$bgprocess, v$processwhere paddr=addr;

NAME DESCRIPTION----- -----------------------ARC0 Archival Process 0ARC1 Archival Process 1ARC2 Archival Process 2ARC3 Archival Process 3CJQ0 Job Queue CoordinatorCKPT checkpointDBRM Resource Manager processDBW0 db writer process 0DIA0 diagnosibility process 0DIAG diagnosibility processDSKM slave DiSKMon processFBDA Flashback Data Archiver Pr.LGWR Redo etc.MMAN Memory Manager

select name, description from v$bgprocess, v$processwhere paddr=addr;

NAME DESCRIPTION----- -----------------------ARC0 Archival Process 0ARC1 Archival Process 1ARC2 Archival Process 2ARC3 Archival Process 3CJQ0 Job Queue CoordinatorCKPT checkpointDBRM Resource Manager processDBW0 db writer process 0DIA0 diagnosibility process 0DIAG diagnosibility processDSKM slave DiSKMon processFBDA Flashback Data Archiver Pr.LGWR Redo etc.MMAN Memory Manager

NAME DESCRIPTION----- --------------------------MMNL Manageability Monitor Pr 2MMON Manageability Monitor PrPMON process cleanupPSP0 process spawner 0QMNC AQ CoordinatorRECO distributed recoverySMCO Space Manager ProcessSMON System Monitor ProcessVKTM Virtual Keeper of TiMe pr

Page 122: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

122

Подготовка

План

Upgrade

Новое в 11g

Полезные советы

ПараметрыПроцессы

ПрочееИнструменты

Page 123: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

123

• The CONNECT Role has been changed since 10gR2:

CONNECT Role

GRANTEE PRIVILEGE----------------------- -------------------CONNECT CREATE VIEWCONNECT CREATE TABLECONNECT ALTER SESSIONCONNECT CREATE CLUSTERCONNECT CREATE SESSIONCONNECT CREATE SYNONYMCONNECT CREATE SEQUENCECONNECT CREATE DATABASE LINK

GRANTEE PRIVILEGE----------------------- -------------------CONNECT CREATE VIEWCONNECT CREATE TABLECONNECT ALTER SESSIONCONNECT CREATE CLUSTERCONNECT CREATE SESSIONCONNECT CREATE SYNONYMCONNECT CREATE SEQUENCECONNECT CREATE DATABASE LINK

GRANTEE PRIVILEGE----------------------- -------------------CONNECT CREATE SESSION

GRANTEE PRIVILEGE----------------------- -------------------CONNECT CREATE SESSION

R2

Page 124: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

124

• Find out affected database users:

CONNECT Role

SELECT granteeFROM dba_role_privsWHERE granted_role = 'CONNECT' and

grantee NOT IN ('SYS', 'OUTLN', 'SYSTEM','CTXSYS', 'DBSNMP','LOGSTDBY_ADMINISTRATOR','ORDSYS', 'ORDPLUGINS','OEM_MONITOR', 'WKSYS','WKPROXY', 'WK_TEST', 'WKUSER', 'MDSYS','LBACSYS', 'DMSYS', 'WMSYS','EXFSYS', 'SYSMAN','MDDATA', 'XDB', 'ODM','SI_INFORMTN_SCHEMA');

SELECT granteeFROM dba_role_privsWHERE granted_role = 'CONNECT' and

grantee NOT IN ('SYS', 'OUTLN', 'SYSTEM','CTXSYS', 'DBSNMP','LOGSTDBY_ADMINISTRATOR','ORDSYS', 'ORDPLUGINS','OEM_MONITOR', 'WKSYS','WKPROXY', 'WK_TEST', 'WKUSER', 'MDSYS','LBACSYS', 'DMSYS', 'WMSYS','EXFSYS', 'SYSMAN','MDDATA', 'XDB', 'ODM','SI_INFORMTN_SCHEMA');

Page 125: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

125

• SYSAUX-Tablespace• SYSAUX служит для хранения системных репозиториев

• SYSAUX не может быть удалено или переименовано

• SYSAUX не может быть переведено в read-only

• SYSAUX - обязательный компонент

• Recommended size: 500 MB

• ASSM and Locally Managed

• Size estimation: ?/rdbms/admin/utlsyxsz.sql

• View V$SYSAUX_OCCUPANTS shows:

• Repositories and their owner

• Space usage

• Procedures for moving repositories

SYSAUX

Page 126: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

126

Instant Client

• Universal. small footprint Oracle client• Works with OCI, OCCI, Pro*C, ODBC and JDBC applications

• No OUI Oracle Client installation necessary anymore

• Easy and simple deployment• Download it from OTN

• Copy it to the target/client system(s)

• Add its directory to PATH/LD_LIBRARY_PATH and set TNS_ADMIN

• For ODBC run the provided batch script

• http://www.oracle.com/technology/tech/oci/instantclient/instantclient.html

Page 127: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

127

Instant Client

• Instant Client Download• Instant Client for Microsoft Windows (32-bit)• Instant Client for Microsoft Windows 64-bit Itanium• Instant Client for Microsoft Windows (x64)• Instant Client for Linux x86• Instant Client for Linux x86-64• Instant Client for Linux Itanium• Instant Client for Linux AMD64 (32-bit and 64-bit)• Instant Client for Linux on Power (32-bit)• Instant Client for Linux on Power (64-bit)• Instant Client for z/Linux (32-bit and 64-bit)• Instant Client for Mac OS X (PPC only) • Instant Client for Solaris Operating System (SPARC) (64-bit)• Instant Client for Solaris Operating System (SPARC) (32-bit)• Instant Client for Solaris x86• Instant Client for Solaris x86-64• Instant Client for HP-UX PA-RISC (64-bit)• Instant Client for HP-UX PA-RISC (32-bit)• Instant Client for AIX5L (64-bit)• Instant Client for AIX5L (32-bit)• Instant Client for HP Tru64 UNIX• Instant Client for HP-UX Itanium (64-bit)• Instant Client for HP-UX Itanium (32-bit)

Page 128: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

128

• Client certification - Note: 207303.1

Clients & Net

����

���� Certified

Not supported anymore Never supported

����

����

����

���� ���� ����

���� ���� ����

���� ����

10.1.0

10.1.0

9.2.0

9.0.1

9.2.0 9.0.1 8.1.7

8.1.7

Database Release

C

l

i

e

n

t

����

��������

���� ����10.2.0

����

����

10.2.0

����

����

����

����

����

����

���� ����

11.1.0

11.1.0 ����

����

���� Supported but EHS

Page 129: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

129

Clients & Net

• Database links• Only supported if matrix shows ‚Supported‘ in both directions

• Not supported means: Use it on your own risk

• JDBC certification• Note:203849.1

• Forms/Reports certification• Metalink Certify Tab Development Tools

Page 130: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

130

Смена редакции XE, SE и EE

• SE EE see Note:117048.1• Take a full backup• Uninstall SE• Install EE• Run catalog.sql and catproc.sql in the EE enviroment

• EE SE see Note:139642.1• Only Export/Import with exp/imp or expdp/imdp will be supported

• XE SE/SEone/EE• Oracle® Database Express Edition Upgrade Guide 10.2.0.3

Page 131: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

131

Features not supported anymore in 11g

• Oracle Ultra Search

• Java Development Kit (JDK) 1.4• Oracle recommends JDK 5.0, but JDK 1.5 is fully supported, too

• CTXXPATH Index• Recommendation: use an XMLIndex instead

Page 132: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

132

Feature Usage Overview

• Either use: DBA_FEATURE_USAGE_STATISTICS

• Or check in DatabaseControl:

Page 133: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

133

Подготовка

План

Upgrade

Новое в 11g

Полезные советы

ПараметрыПроцессы

ПрочееИнструменты

Page 134: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

134

Enterprise Manager 11g

• Upgrading the EM configuration• Creation per command line:

• emca -upgrade

• Create an EM repository:

• dbca

Page 135: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

135

SQL Developer 1.5

• Developer tool at no extra cost(Installation deploys V.1.1.3 - Update available via OTN)

• Key-Features:• PL/SQL development and debugging

• Extremely fast object browser

• Excellent reporting capabilities

• Supports Oracle 9i and above

• Migration workbench for:

• MS SQL-Server

• MS Access

• MySQL

• APEX monitor

Page 136: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

136

SQL Developer 1.5

• Connections and object browser

Page 137: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

137

SQL Developer 1.5

• Reports

��

Page 138: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

138

APEX 3.0

• APEX = Application Express = ex-HTLMDB• GUI development enviroment

• Easy to use - wizard driven

• APEX is available by default• No additional installation or license necessary

• Current release: 3.1.1

• Two configuration steps:• $ORACLE_HOME/apex/apxconf.sql

• ALTER USER anonymous ACCOUNT UNLOCK;

Page 139: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

139

APEX

• APEX web page: apex.oracle.com

Page 140: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

140

Data Pump

• Преимущества• Замена export/import• Поддерживается 10g и 11g • Не совместим с exp/imp• Синтаксис похож на exp/imp• Существенно быстрее exp/imp – за счет параллельнойобработки!!!

• Работает на стороне сервера

• Интерфейс• Command line: expdp and impdp

• Package DBMS_DATAPUMP• API

• Documentation:• Database Utilities and Note:553337.1

Page 141: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

141

Data Pump in Enterprise Manager

Page 142: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

142

Data Pump Capabilities

• Полезно знать• Перемещает данные в tablespaces

• Возможность извлекать DDLs из файла дампа

• Можно включить/исключить определеныне объекты/схемы спомощью EXCLUDE или INCLUDE

• Импорт через сеть, без создания дамп-файла•

• Сжатие – уменьшение dump file ≥ 50 %

• Advanced Compression Option license required

• Шифрование – можно шифоровать дамп-файлы - requires Advanced Security Option

expdp system/orc DUMPFILE=DPDIR:full.dmpFULL=y NOLOGFILE=y COMPRESSION=all

expdp system/orc DUMPFILE=DPDIR:full.dmpFULL=y NOLOGFILE=y COMPRESSION=all

impdp sytem/orc NETWORK_LINK=db_link1 FULL=Y impdp sytem/orc NETWORK_LINK=db_link1 FULL=Y

expdp system/orc DUMPFILE=DPDIR:enc.dmpENCRYPTION_PASSWORD=secret ENCRYPTION_ALGORITHM=AES128

expdp system/orc DUMPFILE=DPDIR:enc.dmpENCRYPTION_PASSWORD=secret ENCRYPTION_ALGORITHM=AES128

Page 143: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

143

Подготовка

План

Upgrade

Новое в 11g

Полезные советы

Page 144: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

144

Полезные советы

• Никогда не делайте множество изменений одновременно!

• Фиксируйте все изменения!

• Всегда (!!!) используйте реальные данные длятестирования!

• Уделяйте достаточное внимание тестам.

• Создавайте стратегию отката!

• Важно! Протестируйте вашу стратегию – она действительноработает??

• Please remember:Upgrade never has been easier - but you still have to test!!!

Page 145: Oracle ISV Migration Center Upgrade to Oracle Database 11g · 2009-02-10 · DifferencesBetweenEnterprise, Standard and Personal Editionson Oracle 10.2 Note.465460.1 DifferencesBetweenEnterprise,

145

• Общая информация: www.oracle.com/database

• Технологическая информация:Oracle Technology Network

otn.oracle.com• Metalink:

metalink.oracle.com

Информация