Upgrading to Oracle Database 11g

If you have previously installed an earlier version of the Oracle database server, you can upgrade your database to Oracle Database 11g. Multiple upgrade paths are supported; the right choice for you will depend on factors such as your current Oracle software version and your database size. In this chapter, you will see descriptions of these methods along with guidelines for their use.

If you have not used a version of Oracle prior to Oracle Database 11g you can skip this chapter for now. However, you will likely need to refer to it when you upgrade from Oracle Database 11g to a later version or when you migrate data from a different database into your database.

Prior to beginning the upgrade, you should read the Oracle Database 11g Installation Guide for your operating system. A successful installation is dependent on a properly configured environment—including operating system patch levels and system parameter settings. Plan to get the installation and upgrade right the first time rather than attempting to restart a partially successful installat

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Chapter Downloads Writing single-row and multiple-row subqueries List the types of SQL subqueries Using subqueries in SQL Define SQL subqueries Oracle 11g: PL/SQL Basics Oracle 11g: Backup and recovery concepts Migrating to Oracle: Expert Secrets to Migrate from SQL Server and MySQL Oracle Database 11g SQL Tuning Tuning the Oracle database with initialization parameters Protecting your online Oracle data Oracle database installation, upgrades and patches Oracle New Year's resolutions, part 2: GRC tips and customer resolutions revealed Oracle New Year's resolutions, part 1: Advice for navigating 2009 Oracle's Top 8 stories of 2008 Intermap details its Oracle database 11g upgrade Oracle OpenWorld 2008 Special Report Oracle extends Real Application Testing to 10g, 9i Third-party Oracle database tools remain an attractive option Enterprise search a key component of Oracle portal project Oracle Enterprise Manager leverages multiple environments for pharmaceutical giant Oracle 11g upgrade veteran offers step-by-step advice

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary 10g  (SearchOracle.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

ion. Configure the system to support both the installation of the Oracle software and the creation of a usable starter database.

This chapter assumes that your installation of the Oracle Database 11g software (see Chapter 1 and the appendix titled "Installation and Configuration") completed successfully and that you have an Oracle database that uses an earlier version of the Oracle software on the same server. Note that whether you are installing from scratch or upgrading a previous version of the Oracle Database, there are distinct advantages to installing the Oracle Database 11g software and creating the database in separate steps. When installing from scratch, you have greater control over initialization parameters, database file locations, memory allocation, and so forth when you create the database in a separate step; when upgrading from a previous release, installing the software first provides you with the Oracle Pre-Upgrade Information Tool that you use against the existing database to alert you to any potential compatibility problems when you upgrade to Oracle Database 11g . To upgrade that database, you have four options:

Continue reading this chapter by downloading a free .pdf of Upgrading to Oracle Database 11g from the Oracle Database 11g DBA Handbook .

Rate this Tip To rate tips, you must be a member of SearchOracle.com. Register now to start rating these tips. Log in if you are already a member. DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.