1 / 41

Installing Oracle Database 10 g

Installing Oracle Database 10 g. Objectives. After completing this lesson, you should be able to do the following: Install Oracle Database 10 g software Use the Database Configuration Assistant (DBCA) to create a database. Performing the Upgrade.

cormac
Download Presentation

Installing Oracle Database 10 g

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. Installing Oracle Database 10g

  2. Objectives • After completing this lesson, you should be able to do the following: • Install Oracle Database 10g software • Use the Database Configuration Assistant (DBCA) to create a database

  3. Performing the Upgrade • Perform the following steps to upgrade your database: • 1. Prepare the Oracle8i database. • 2. Install the Oracle Database 10g software. • 3. Upgrade using the selected method. • 4. Perform postupgrade steps. • 5. Implement new features.

  4. Installing Oracle Database 10g Software • Incompatibility • Data that cannot be processed by your previous release • New features that behave differently in the new environment • Interoperability • The ability of databases in a distributed system to communicate and work together

  5. Compatibility • Using the COMPATIBLE parameter • Control new features that would make your database incompatible • Minimum value is 9.2.0 • Default value is 10.0.0 • Irreversible compatibility issues • Data file headers are modified when database is opened • Database cannot be downgraded ALTER SYSTEM SET COMPATIBLE = 10.0.0

  6. Using Oracle Universal Installer to Install Oracle Database 10g • Oracle Universal Installer (OUI) has several new features: • Preinstall checking • Support for various storage options • Install database management options • Silent install • Single password • Clean deinstallation • Requires only one CD • Completes in about 20 minutes

  7. Using Oracle Universal Installer • OUI enables you to: • View the Oracle software that is installed on your machine • Install new Oracle software • Uninstall the Oracle software that you no longer intend to use • Change the default ORACLE_HOME on Windows • OUI provides online help.

  8. Installation Prerequisites • Before installation, OUI checks: • Availability of a minimum of 512 MB of memory • Availability of sufficient paging space (swap space) • Whether appropriate operating system service packs or patches are installed • Whether the appropriate file system format is being used

  9. Setting Environment Variables • ORACLE_BASE: Specifies the base of the Oracle directory structure for Optimal Flexible Architecture (OFA) • ORACLE_HOME: Specifies the directory containing the Oracle software • ORACLE_SID: The initial instance name (ORCL by default) • LD_LIBRARY_PATH: Location of shared object libraries (UNIX) • NLS_LANG: The language, territory, and client character set settings

  10. Preinstallation Checks

  11. Oracle Universal Installer

  12. Selecting the Installation Method

  13. Specifying Inventory and Group Name

  14. Executing orainstRoot.sh # sh /u01/app/oracle/oraInventory/orainstRoot.sh Creating the Oracle inventory pointer file (/etc/oraInst.loc) Changing groupname of /u01/app/oracle/oraInventory to oinstall.

  15. Specifying File Locations

  16. Selecting the Installation Type

  17. Prerequisite Checks

  18. Selecting a Starter Database

  19. Specifying Configuration and Management

  20. Specifying File Storage and Backups

  21. Specifying Passwords and Summary Page

  22. Installation

  23. Configuration Assistants

  24. End of Installation

  25. Oracle Versions • Oracle has several versions and patch levels: • Oracle8i • 8.1.7 last release • 8.1.7.4.2 last patch on Windows • Oracle9i, Release 2 • 9.2.0.0 initial release • 9.2.0.5.0 latest patch release on Linux x-86 • Oracle Database 10g • 10.1.0.2 initial release • 10.1.0.3 patch set (Minipack)

  26. Applying Oracle Software Patches • Patches are available from MetaLink. There are two types of patches: • Temporary patches • Patch sets • To install the latest Oracle Database 10g release on Windows, you must apply patch set 10.1.0.3.

  27. Using the Oracle Patch Utility • Oracle Patch Utility (Opatch) is installed with Oracle Database 10g. • For Oracle9i, install Opatch by applying temporary patch 2617419. • Use OPatch to: • Apply other temporary patches • Roll back temporary patches • List installed Oracle components and temporary patches • Attach an installed ORACLE_HOME to a central inventory $ opatch apply ... OPatch succeeded.

  28. Using the Oracle Relink Utility • To relink Oracle executables: • Verify whether ORACLE_HOME is correctly set. • Set LD_LIBRARY_PATH to include $ORACLE_HOME/lib. • Execute the appropriate relink command: • relink all (relinks all Oracle executables) • relink oracle (relinks the database executables) • relink network (relinks listener, cman, names) • relink oemagent (relinks the Intelligent Agent) • relink utilities (relinks sqlplus, imp, exp) • relink ctx (relinks Oracle Text)

  29. Database Configuration Assistant (DBCA): Overview

  30. Creating a Database

  31. Database Identification

  32. Specifying Management Options

  33. Specifying Passwords and Storage

  34. Specifying File Locationsand Backup Options

  35. Viewing File Location Variables

  36. Content and Initialization Parameters

  37. Database Storage

  38. Creation Options and Create

  39. Performing Other Actions with DBCA

  40. Summary • In this lesson, you should have learned how to: • Install Oracle Database 10g software • Use the DBCA to create a database

  41. Practice 2 Overview:Installing Oracle Database 10g Software • This practice covers the following topics: • Installing Oracle Database 10g software • Applying patches to the Oracle Database 10g installation • Creating a database to be used with Import

More Related