1 / 67

Doug Cackett RTS Incorporated Remote DBA Services

Doug Cackett RTS Incorporated Remote DBA Services. Topics of Discussion. Installing Oracle10g Upgrading to Oracle10g New Features of Oracle10g. Installing Oracle 10g. Startup the OUI. File Locations. Loading product list ……. Installation Type. Select Database. Database Options.

darva
Download Presentation

Doug Cackett RTS Incorporated Remote DBA Services

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Doug Cackett RTS Incorporated Remote DBA Services

  2. Topics of Discussion • Installing Oracle10g • Upgrading to Oracle10g • New Features of Oracle10g

  3. Installing Oracle 10g

  4. Startup the OUI

  5. File Locations

  6. Loading product list …….

  7. Installation Type

  8. Select Database

  9. Database Options

  10. Enterprise Manager Option

  11. Datafile Storage

  12. Backup and Recovery Option

  13. Passwords

  14. Installation Summary

  15. Installing …..

  16. That’s it…..

  17. End … Links and info

  18. Upgrading to Oracle Database 10g

  19. 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

  20. 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

  21. 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!

  22. 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

  23. 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 -> 8.1.7 -> 10.1.0 • 7.3.4 -> 9.2.0 -> 10.1.0

  24. 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

  25. Advantages of DBUA • 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

  26. Manual Upgrade Advantages & Disadvantages • Advantage: • Gives the DBA finer control over the upgrade process • Disadvantage: • More work • More error prone

  27. Pre Upgrade Analysis (Auto)script: utlu101i.sql • Checks for certain known database, init.ora, etc settings that may cause upgrade to fail, and generates warnings • i.e. shared_pool_size init.ora parameter is too low • Utility runs in “old server” & “old database” context • Based on database knowledge & needs of Oracle Database 10g • DBUA automatically performs any required actions

  28. Pre Upgrade Analysis • Database version and compatibility • Redo logs <4MB • Updated Parameters e.g. shared_pool_size • Deprecated (renamed) parameters • Obsolete parameters • Cluster check • Account Check

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

  30. 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

  31. 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

  32. 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.

  33. Key DBUA Features • Silent mode for single command upgrade i.e. dbua –silent –sid ora9idb [-backup <location>]

  34. Welcome Screen

  35. Select the database to upgrade

  36. Tablespace

  37. Log Files

  38. Create SYSAUX Tablespace

  39. Parallel Recompilation

  40. Database Backup

  41. Pre-Upgrade Summary Page

  42. Upgrade Progress

  43. Upgrade Results

  44. Manual Upgrade • Install Oracle Database 10g • Analyze the existing database using pre-upgrade information tool • @?/rdbms/admin/utlu101i.sql • Make necessary adjustments based on feedback • Shutdown database • Take a backup • Switch to New Oracle Home • Startup Database • SQL> startup upgrade

  45. Manual Upgrade • Create SYSAUX tablespace • Invoke the proper upgrade “u” script • SQL> @rdbms/admin/u0801070.sql • Shutdown database • Startup database • Run utlrp • SQL>@rdbms/admin/utlrp • Check upgrade status using post upgrade status tool • SQL>@?/rdbms/admin/utlu101s.sql

  46. Upgrade Validation • “STARTUP UPGRADE” mode will suppress certain spurious and unnecessary errors • Catch and handle ORA-00942 on DROP TABLE • Automatically handles setting parameters that can cause problems during upgrade • DBMS_REGISTRY package and dictionary view used to record and manage information about all the component upgrades, for example: • SQL> select ... from dba_registry; • COMP_ID COMP_NAME VERSION STATUS • ------- ---------------------- ------- ------ • CATALOG Oracle10g Catalog Views 10.1.0.1.0 VALID

  47. Upgrade Validation • New “Post Upgrade Status Utility” script - 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

  48. 10g New Features - Sampling

  49. Online Segment Shrink • Can be recommended by Segment Advisor • alter table enable row movement; • alter table t1 shrink space [compact] cascade; TABLE HEADER 10111101 11001101 10101111 11101101 00001101 11001101 00001101 10111101 0101010111011010 High Water Mark Free Space TABLE HEADER 11001101 10101111 11101101 00001101 11001101 10101111 11101101 00001101 11001101 00001101 High Water Mark Free Space

  50. Rename Tablespace • Useful in Transportable Tablespace scenarios • ALTER TABLESPACE prod RENAME to arc1; • Can’t rename SYSTEM or SYSAUX • Tablespace and all datafiles must be online • Can also rename READ ONLY tablespaces PROD ARC1

More Related