For details Please explore Document 1189783.1
Starting with the first patch set for Oracle Database 11g Release 2 (11.2.0.2), Oracle Database patch sets are full installations of the Oracle Database software. In past releases, Oracle Database patch sets consisted of a set of files that replaced files in an existing Oracle home. Beginning with Oracle Database 11g Release 2, patch sets are full installations that replace existing installations.
Because Oracle Database 11g Release 2 and later patch sets are a full installation, Oracle patch sets are now released as several installation bundles, just as are the base releases:
• Oracle Database Server
• Oracle Grid Infrastructure
• Oracle Database Client
• Companion/examples
• Oracle Gateways
Simplified new installation: Because the release 11.2.0.2 patch set is a full installation package, if you are installing Oracle Database on a system without an existing Oracle Database installation, then you can simply install the release 11.2.0.2 patch set. You are no longer required to install the base release, and then apply the patch set.
Upgrade process: Beginning with the release 11.2.0.2 patch set, you have two ways to apply a patch set:
• Out-of-place upgrade – This is Oracle's recommended way to apply a patch set. You install the patch set into a new, separate Oracle home location. After you install the patch upgrade, you then migrate the Oracle Database from the older Oracle home. The patch set upgrade is now the same process to upgrade from one version to another. Oracle recommends that you perform an out-of-place patch set upgrade, because this patch set application option requires much less downtime, and is safer because it does not require patching an ORACLE_HOME that is already being used in production. However, you must ensure that you have sufficient free disk space to accommodate two Oracle home directories at the same time.
• In-place upgrade – You install the patch set into an existing Oracle home location. Oracle recommends that you select this option only if you do not have sufficient free disk space to perform an out-of-place upgrade, as the upgrade removes the existing Oracle installation. This patch option requires less disk space, but requires more time, and is riskier, because if you encounter an installation failure, then you must recover the entire existing Oracle home from a backup. If you choose this more risky option, then before you begin the patch installation, complete the following tasks:
o Make a complete backup of your existing Oracle home
o Read through the entire Upgrade Guide section dealing with in-place upgrades
Direct upgrade from previous releases: You can upgrade from a previous Oracle Database release directly to the latest patch set, without having to install the base release. For example, if you want to upgrade from Oracle Database 10g Release 2, or Oracle Database 11g Release 1, then you can upgrade directly to Oracle Database 11g Release 2, patch set 2 (11.2.0.2) using an out-of-place upgrade. Oracle now supports direct upgrades to the release 11.2.0.2 patch set from any release where direct upgrade to the base release (11.2.0.1) is supported, as well as direct upgrades from 11.2.0.1 to 11.2.0.2.
New Features Available in Patch Sets
In addition to the usual set of fixes, the release 11.2.0.2 patch set contains a small number of features that complete the Database 11g Release 2 feature set. The new features fall into the following five categories:
• General improvements
• Oracle Automatic Storage Management Cluster File System (ACFS) improvements
• Quality of Service Management
• Database Replay
• Management
How to Download
To download the software from My Oracle Support:
1.Log on to My Oracle Support.
2.Click Patches & Updates.
3.In the Patch Search section, click the Search tab.
4.Enter 10098816 in the patch number field.
5.Select a platform to download.
6.Click Search.
7.In the Patch Search Results page, under Patch Name, click the patch number to display the patch details.
8.Click Download.
9.From the File Download window, click each file name to download the selected software.
List of files:
Zip File Installation Type
p10098816_112020_platform_1of7.zip Oracle Database (includes Oracle Database and Oracle RAC)
p10098816_112020_platform_2of7.zip Note: you must download both zip files to install Oracle Database.
p10098816_112020_platform_3of7.zip Oracle Grid Infrastructure (includes Oracle ASM, Oracle Clusterware, and Oracle Restart)
p10098816_112020_platform_4of7.zip Oracle Database Client
p10098816_112020_platform_5of7.zip Oracle Gateways
p10098816_112020_platform_6of7.zip Oracle Examples
p10098816_112020_platform_7of7.zip Deinstall
Showing posts with label Database Upgrade/Downgrade. Show all posts
Showing posts with label Database Upgrade/Downgrade. Show all posts
Monday, November 29, 2010
Wednesday, February 3, 2010
Downgrading a Database
Step 1:
Check the compatibility level of your database to see if the database might have incompatibilities that prevent you from downgrading. If the compatibility level of your Oracle Database 11g Release 1 (11.1) database is 11.0.0 or higher, then you are not able to downgrade.
To check the current value of the COMPATIBLE initialization parameter, enter the following SQL statement:
SQL> SELECT name, value, description FROM v$parameter
WHERE name = 'compatible';
Step 2:
Perform a full Backup of your 11g Database.
Step 3:
Log in to the system as the owner of the Oracle Database 11g Release 1 (11.1) Oracle home directory.
Note: This step is required only if Enterprise Manager Database Control is already configured for the database.
Stop the Database Control, as follows:
1. Set the ORACLE_SID environment variable to the databaseSid
2. Run the following command:
3. ORACLE_HOME/bin/emctl stop dbconsole
Step 4:
• At a system prompt, change to the ORACLE_HOME/rdbms/admin directory.
• Start SQL*Plus.
• Connect to the database instance as a user with SYSDBA privileges.
• Start up the instance in DOWNGRADE mode:
SQL> STARTUP DOWNGRADE
Step 5:
• Drop the SYSMAN schema:
SQL> DROP USER sysman CASCADE;
Step 6:
• Set the system to spool results to a log file for later verification of success:
SQL> SPOOL downgrade.log
• Run catdwgrd.sql:
SQL> @catdwgrd.sql
• Turn off the spooling of script results to the log file:
SQL> SPOOL OFF
• Shut down the instance:
SQL> SHUTDOWN IMMEDIATE
Exit SQL*Plus.
In case if the downgrade is to be done on windows please complete the following steps:
• Stop all Oracle services, including the OracleServiceSID Oracle service of the Oracle database 11g Release 1 (11.1) database, where SID is the instance name.
For example, if your SID is ORCL, then enter the following at a command prompt:
C:\> NET STOP OracleServiceORCL
• Delete the Oracle service at a command prompt by issuing the ORADIM command. For example, if your SID is ORCL, then enter the following command:
C:\> ORADIM -DELETE -SID ORCL
• Create the Oracle service of the database that you are downgrading at a command prompt using the ORADIM command.
C:\> ORADIM -NEW -SID SID -INTPWD PASSWORD -MAXUSERS USERS
-STARTMODE AUTO -PFILE ORACLE_HOME\DATABASE\INITSID.ORA
Step 7:
• Install the Oracle Software Version to which the database is to be downgraded.
• Set ORACLE_HOME
• Set PATH
Step 8:
Restore the configuration files (for example, parameter files, password files, and so on) of the release to which you are downgrading.
Step 9:
• At a system prompt, change to the ORACLE_HOME/rdbms/admin directory of the previous release.
• Start SQL*Plus.
• Connect to the database instance as a user with SYSDBA privileges.
• Start up the instance:
SQL> STARTUP UPGRADE
• Set the system to spool results to a log file for later verification of success:
SQL> SPOOL reload.log
• Run catrelod.sql:
SQL> @catrelod.sql
o If you are downgrading to release 10.1.0.5 and you have XDB in your database, then run the following script after running catrelod.sql:
@dbmsxdbt.sql
• Turn off the spooling of script results to the log file:
SQL> SPOOL OFF
• Shut down and restart the instance for normal operation:
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP
You might be required to use the PFILE option to specify the location of your initialization parameter file.
• Run the utlrp.sql script:
SQL> @utlrp.sql
The utlrp.sql script recompiles all existing PL/SQL modules that were previously in an INVALID state, such as packages, procedures, types, and so on.
• Exit SQL*Plus.
Your database is now downgraded.
Check the compatibility level of your database to see if the database might have incompatibilities that prevent you from downgrading. If the compatibility level of your Oracle Database 11g Release 1 (11.1) database is 11.0.0 or higher, then you are not able to downgrade.
To check the current value of the COMPATIBLE initialization parameter, enter the following SQL statement:
SQL> SELECT name, value, description FROM v$parameter
WHERE name = 'compatible';
Step 2:
Perform a full Backup of your 11g Database.
Step 3:
Log in to the system as the owner of the Oracle Database 11g Release 1 (11.1) Oracle home directory.
Note: This step is required only if Enterprise Manager Database Control is already configured for the database.
Stop the Database Control, as follows:
1. Set the ORACLE_SID environment variable to the databaseSid
2. Run the following command:
3. ORACLE_HOME/bin/emctl stop dbconsole
Step 4:
• At a system prompt, change to the ORACLE_HOME/rdbms/admin directory.
• Start SQL*Plus.
• Connect to the database instance as a user with SYSDBA privileges.
• Start up the instance in DOWNGRADE mode:
SQL> STARTUP DOWNGRADE
Step 5:
• Drop the SYSMAN schema:
SQL> DROP USER sysman CASCADE;
Step 6:
• Set the system to spool results to a log file for later verification of success:
SQL> SPOOL downgrade.log
• Run catdwgrd.sql:
SQL> @catdwgrd.sql
• Turn off the spooling of script results to the log file:
SQL> SPOOL OFF
• Shut down the instance:
SQL> SHUTDOWN IMMEDIATE
Exit SQL*Plus.
In case if the downgrade is to be done on windows please complete the following steps:
• Stop all Oracle services, including the OracleServiceSID Oracle service of the Oracle database 11g Release 1 (11.1) database, where SID is the instance name.
For example, if your SID is ORCL, then enter the following at a command prompt:
C:\> NET STOP OracleServiceORCL
• Delete the Oracle service at a command prompt by issuing the ORADIM command. For example, if your SID is ORCL, then enter the following command:
C:\> ORADIM -DELETE -SID ORCL
• Create the Oracle service of the database that you are downgrading at a command prompt using the ORADIM command.
C:\> ORADIM -NEW -SID SID -INTPWD PASSWORD -MAXUSERS USERS
-STARTMODE AUTO -PFILE ORACLE_HOME\DATABASE\INITSID.ORA
Step 7:
• Install the Oracle Software Version to which the database is to be downgraded.
• Set ORACLE_HOME
• Set PATH
Step 8:
Restore the configuration files (for example, parameter files, password files, and so on) of the release to which you are downgrading.
Step 9:
• At a system prompt, change to the ORACLE_HOME/rdbms/admin directory of the previous release.
• Start SQL*Plus.
• Connect to the database instance as a user with SYSDBA privileges.
• Start up the instance:
SQL> STARTUP UPGRADE
• Set the system to spool results to a log file for later verification of success:
SQL> SPOOL reload.log
• Run catrelod.sql:
SQL> @catrelod.sql
o If you are downgrading to release 10.1.0.5 and you have XDB in your database, then run the following script after running catrelod.sql:
@dbmsxdbt.sql
• Turn off the spooling of script results to the log file:
SQL> SPOOL OFF
• Shut down and restart the instance for normal operation:
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP
You might be required to use the PFILE option to specify the location of your initialization parameter file.
• Run the utlrp.sql script:
SQL> @utlrp.sql
The utlrp.sql script recompiles all existing PL/SQL modules that were previously in an INVALID state, such as packages, procedures, types, and so on.
• Exit SQL*Plus.
Your database is now downgraded.
Subscribe to:
Posts (Atom)