Example Oracle 10.2.0.1.0 upgrade to 10.2.0.4.0 example

1. View the current system version

[Email protected] disk1]$ Sqlplus'/as sysdba'SQL*plus:release10.2.0.1.0-Production on Thu Jan the  -: +: +  -Copyright (c)1982,2005, Oracle. All rights reserved. Connected to:oracle Database 10g Enterprise Edition Release10.2.0.1.0-Productionwith The partitioning, Oracle Label Security, OLAP and Data Mining optionssql>Select* fromv$version; BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release10.2.0.1.0-PRODPL/sql Release10.2.0.1.0-Productioncore10.2.0.1.0Productiontns forLinux:version10.2.0.1.0-Productionnlsrtl Version10.2.0.1.0-Production

can be to view the number of database bits by using the following command

[Email protected] disk1]$ file $ORACLE _home/bin/ORACLE/u02/app/product/10.2. 0 32-bit 80386 1  for 2.6. 9  for 2.6. 9, not stripped

2. Please read the upgrade document carefully before upgrading

Here we upload the upgrade package P6810189_10204_linux-x86.zip to the database server and execute the unzip P6810189_10204_linux-x86.zip

Note: Backing up data before upgrading

3. Stop all Oracle Services

[Email protected] disk1]$ Sqlplus'/as sysdba'SQL*plus:release10.2.0.1.0-Production on Thu Jan the  -: -: -  -Copyright (c)1982,2005, Oracle. All rights reserved. Connected to:oracle Database 10g Enterprise Edition Release10.2.0.1.0-Productionwith The partitioning, Oracle Label Security, OLAP and Data Mining optionssql>shutdown immediatedatabase closed. Database dismounted. ORACLE instance shut down.

[[email protected] disk1]$ lsnrctl stop[[email protected] disk1]$ isqlplusctl stop[[email protected] disk1]$ emctl Stop db Console

4. Executing the upgrade package

[[email protected] disk1]$./Runinstaller starting Oracle Universal Installer ... Checking Installer Requirements ... Checking operating system version:must be Redhat  -3, SuSE-9, SuSE-10, redhat-4, redhat-5, UnitedLinux-1.0, asianux-1, asianux-2 or asianux-3                                      Failed <<<< for the session can be found at/u02/orainventory/logs/ installactions2015--15_04- -21pm.log

To the above question http://blog.csdn.net/huashnag/article/details/8528829

To bring up the GUI upgrade interface:

Execute the script as root:

[Email protected] ~]#/u02/app/product/10.2.0/db_1/root.shrunning Oracle10 root.sh script ... The following environment variables isSet  as: Oracle_owner=Oracle Oracle_home=/u02/app/product/10.2.0/Db_1enter the full pathname of the Local bin directory: [/usr/local/bin]: the file"Dbhome"already existsinch/usr/local/bin. Overwrite it? (y/n) [n]: y Copying dbhome to/usr/local/bin ... The file"oraenv"already existsinch/usr/local/bin. Overwrite it? (y/n) [n]: y Copying oraenv to/usr/local/bin ... The file"coraenv"already existsinch/usr/local/bin. Overwrite it? (y/n) [n]: y Copying coraenv to/usr/local/bin ... Entries 'll be added to the/etc/oratab file asneeded bydatabase Configuration Assistant when a database iscreatedfinished running generic part of root.sh script. Now product-specific root actions would be performed. Successfully accumulated necessary OCR keys. Creating OCR Keys forUser'Root', PRIVGRP'Root'.. Operation successful. Configuration forlocal CSS have been initializedadding to Inittab Startup'll be queued to init within -seconds. Checking the status ofNewOracle init process ... Expecting the CRS daemons to being up within -seconds. CSS isactive on these nodes. Stdcss isactive on all nodes. Oracle CSS Service isInstalled and running under init (1M)

5. Perform the upgrade follow-up script

[Email protected] disk1]$ Sqlplus'/as sysdba'SQL*plus:release10.2.0.4.0-Production on Fri Jan - Ten: to: Geneva  -Copyright (c)1982, -, Oracle. All rights reserved.connected to an idle instance. SQL>Startup Upgradeoracle instance started. Total System Global Area608174080bytesfixed Size1268896bytesvariable Size163578720Bytesdatabase Buffers436207616Bytesredo Buffers7118848bytesdatabase mounted. Database opened. SQL> @?/rdbms/admin/catupgrd.sql
。。。。。。。。。。。。。。。。。。。。。。
 

Execute script gracefully shut down database restart view version:

Sql>shutdown immediatedatabase closed. Database dismounted. ORACLE instance shut down. SQL>Startuporacle instance started. Total System Global Area608174080bytesfixed Size1268896bytesvariable Size197133152Bytesdatabase Buffers402653184Bytesredo Buffers7118848bytesdatabase mounted. Database opened. SQL>Select* fromv$version; BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release10.2.0.4.0-PRODPL/sql Release10.2.0.4.0-Productioncore10.2.0.4.0Productiontns forLinux:version10.2.0.4.0-Productionnlsrtl Version10.2.0.4.0-Production

Sql>Show parameter Compati NAME TYPE VALUE------------------------------------ ----------- ------------------------------compatiblestring      10.2.0.1.0plsql_v2_compatibility Boolean Falsesql> Alter systemSetcompatible='10.2.0.4.0'Scope=SPFile; SQL>shutdown immediatedatabase closed. Database dismounted. ORACLE instance shut down. SQL>Startuporacle instance started. Total System Global Area608174080bytesfixed Size1268896bytesvariable Size197133152Bytesdatabase Buffers402653184Bytesredo Buffers7118848bytesdatabase mounted. Database opened. SQL>Show parameter Compatname TYPE VALUE------------------------------------ ----------- ------------------------------compatiblestring      10.2.0.4.0plsql_v2_compatibility Boolean FALSE

An overall sequence of procedures for upgrading:

Example Oracle 10.2.0.1.0 upgrade to 10.2.0.4.0 example