Oracle%20Database:%20Easy%20Upgrade

1
(No Transcript)
2
Self-Managing Database Easy Upgrade
Session id 40084

• Tom GravesConsulting Member of Technical Staff
• Oracle Corporation

3
Oracle Database 10g Upgrade

• Database upgrade is the process of transforming
  the internal Oracle database dictionary from one
  release to another
• Driven primarily through SQL and PL/SQL scripts
• Very careful ordering of execution and
  dependencies
• Must complete cleanly and correctly before the
  database can be used

4
Oracle Database 10g Upgrade Enhancements

• Reduced Complexity
• Component integration
• Consolidation of steps
• Single script to upgrade all components
• Enhanced GUI tool to assist the upgrade
• Database Upgrade Assistant (DBUA)

5
Oracle Database 10g Upgrade Enhancements

• Analysis of database before upgrade to increase
  likelihood of successful upgrade
• Pre upgrade information tool
• Upgrade Performance Enhancement
• Parallel recompilation of invalid pl/sql database
  objects on multiprocessor CPUs
• Verification of database upgrade
• Post upgrade status tool

6
Reduced Complexity

• Automaticly determines what components (e.g.
  Java, Spatial) need to be upgraded and then
  performs all necessary upgrades in correct
  dependency order
• All components in DBMS_REGISTRY
• Prior to Oracle Database 10g, much of the
  component script invocation was manual

7
Reduced Complexity

• One measure of simplicity Database Upgrade Guide
  documentation size is decreasing dramatically
• 8i 512 pages
• 9i 484 pages 111 steps total for RDBMS
  with all 9 components!
• 9iR2 344 pages
• 10g 230 pages - 6 steps!

8
Prepare to Upgrade

• Become familiar with the features of the new
  Oracle Database 10g release
• Determine the Upgrade Path to the new release
• Choose an upgrade Method
• Choose an Oracle Home Directory
• Prepare a Backup Strategy
• Develop a test plan

9
10g Upgrade Paths

• Direct upgrade from 9iR2 (9.2.0), 9i (9.0.1), 8i
  (8.1.7), 8.0.6
• If you are not at one of these versions you need
  to perform a double-hop Upgrade
• E.g. 8.1.5 -gt 8.1.7 -gt 10.1.0
• 7.3.4 -gt 9.2.0 -gt 10.1.0

10
Choose an Upgrade Method

• Database Upgrade Assistant (DBUA)
• The Database Upgrade Assistant is a graphical
  user interface (GUI) tool that interactively
  steps the user through the upgrade process and
  configures the database to run with the new
  Oracle Database 10g release.
• Manual Upgrade
• A manual upgrade consists of running SQL scripts
  and utilities from the command line

11
Database Upgrade Assistant Advantages

• Performs all necessary steps for the upgrade
• Interacts with the DBA if decisions need to be
  made
• Provides complete HTML report of the upgrade
  process
• Significantly reduces database downtime

12
Manual Upgrade Advantages Disadvantages

• Advantage
• Gives the DBA finer control over the upgrade
  process
• Disadvantage
• More work
• More error prone

13
Pre Upgrade Analysis

• Checks for certain known database, init.ora, etc
  settings that may cause upgrade to fail, and
  generates warnings
• E.g. shared_pool_size init.ora parameter is too
  low
• Utility runs in old server old database
  context
• Based on posterity database knowledge needs
  of Oracle Database 10g
• DBUA automatically performs any required actions

14
Pre Upgrade Analysis

• Database version and compatibility
• Redo logs lt4MB
• Updated Parameters e.g. shared_pool_size
• Deprecated (renamed) parameters
• Obsolete parameters
• Cluster check
• Account Check

15
Pre Upgrade Analysis

• Names of Components in database e.g. JAVAVM,
  Spatial, etc
• Tablespaces
• Increase in size recommendations
• New SYSAUX tablespace
• Character set incompatibilities
• Installed options
• Upgrade time estimate

16
Key DBUA Features

• The Assistant automates the upgrade process by
  performing all the tasks you normally accomplish
  manually
• Invokes the Pre Upgrade Information Utility and
  automatically makes appropriate adjustments
  (including tablespace, redo logs, etc)
• Checks for adequate resources (disk space,
  rollback segments)
• Creates mandatory tablespace SYSAUX
• Optionally, backs up all necessary files.
• Creates new configuration files (init.ora,
  spfile, listener) in the new Oracle home

17
Key DBUA Features

• During the upgrade process, the DBUA
• Runs all necessary scripts (pre-upgrade
  information utility, u script, post upgrade
  status utility)
• Shows upgrade progress
• Write detailed trace and logging files

18
Key DBUA Features

• Settings during upgrade
• DBUA disables archiving during upgrade phase
• Security features
• DBUA locks new users in the upgraded database
• RAC-DBUA
• RAC-DBUA facilitates upgrade of 8.1.7, 9.0.1, 9.2
  to 10.1.0
• Upgrade done on the cluster. All database and
  configuration files are upgraded on all the nodes
  in the cluster.

19
Key DBUA Features

• Customizable
• ISVs can customize DBUA to run their migration
  scripts
• XML files driving the DBUA engine (created by pre
  upgrade information utility post upgrade status
  utility)
• Silent mode for single command upgrade
• dbua silent sid ora9idb
• -backup ltlocationgt

20
Welcome Screen
21
Select the database to upgrade
22
Tablespace
23
Log Files
24
Create SYSAUX Tablespace
25
Parallel Recompilation
26
Database Backup
27
Pre-Upgrade Summary Page
28
Upgrade Progress
29
Upgrade Results
30
Upgrade Validation

• New Post Upgrade Status Utility utlu101s.sql
• Queries component REGISTRY to determine upgrade
  status
• Provides information about invalid/incorrect
  component upgrades
• Provides script name to re-run if necessary
• DBUA calls this script to display status and then
  takes corrective action

31
Upgrade Validation

• OPEN UPGRADE mode will suppress certain
  spurious and unnecessary errors
• Catch and handle ORA-00942 on DROP TABLE
• Automatically handles setting certain system
  parameters that can otherwise cause problems
  during upgrade (E.g. set job_queue_processes 0)
• DBMS_REGISTRY package and system table are used
  to record and manage information about all the
  component upgrades
• E.g. SQLgt select ... from dba_registry
• COMP_ID COMP_NAME VERSION
  STATUS
• ------- ---------------------- -------
  ------
• CATALOG Oracle10g Catalog Views 10.1.0.1.0 VALID

32
Manual Upgrade

• Install Oracle Database 10g
• Analyze the existing database using pre upgrade
  information tool
• _at_rdbms/admin/utlu101i
• Make necessary adjustments based on feedback
• Shutdown database
• Switch to New Oracle Home

33
Manual Upgrade

• Startup Database
• SQLgt startup upgrade
• Create SYSAUX tablespace
• Invoke the proper upgrade u script
• SQLgt _at_rdbms/admin/u0801070
• Shutdown database
• Startup database
• SQLgt startup

34
Manual Upgrade

• Run utlrp
• SQLgt_at_rdbms/admin/utlrp
• Check upgrade status using post upgrade status
  tool
• SQLgt_at_rdbms/admin/utlu101s

35
Whats Next

• Improve after-upgrade confirmation
• Improve recovery options
• Improve upgrade performance
• Reduce downtime for upgrades

36
Next Steps.

• Visit our demo ground
• Self Managing Database Easy Upgrade
• In the database area.

37
Reminder please complete the OracleWorld
online session surveyThank you.
38
A
39
(No Transcript)