Upgrading 9.2.0.4 to 9.2.0.8

Upgrading 9.2.0.4 to 9.2.0.8


Assumptions:
1) oracle software owner ora9i
2) ORACLE_HOME /d01/mt/ora9i/9.2.0.4
3) ORACLE_SID ora9i
4) Hostname of91.orafact.com



General Requiremets:

1) For upgrading 9.2.0.4 to 9.2.0.8, first we have to download the required patchset from metalink . The required patchset to upgrade 9.2.0.4 to 9.2.0.8 is p4547809.

2) For Linux users, check that your kernel version is minimum 2.4.9-e.57.


Pre installation Steps:

1) Download and extract the patch set installation software:

Download and extract the patch set p4547809_9208_LINUX.zip installation archive to a directory that is not the Oracle home directory or under the Oracle home directory. For example, Oracle_patch.

Enter the following commands to unzip and extract the installation files:

$ unzip p4547809_9208_LINUX.zip.


2) Set ORACLE_HOME and ORACLE_SID environment variables
For Bourne,bash shells

$ export ORACLE_HOME= /d01/mt/ora9i/
$export ORACLE_SID = ora9i

For C shell ,
$setenv ORACLE_HOME /d01/mt/ora9i


3) Shut down any oracle database instances with normal or immediate

sql>shut immediate;
4) Stop all listener and other processes running in the Oracle home directory.

$lsnrctl stop


5) take complete backup of the Oracle9i installation before you install the patch set.



Installation :


You can install the patch set either interactively or non interactively.


Interactive install:


1) log in as the oracle software user ( ora9i)

2) If you are not installing the software on the local system, enter the following command to direct X applications to display on the local system:
For Bourne, Bash, or Korn shell
$ DISPLAY=hostname(of91.orafact.com):0.0 ; export DISPLAY ;
For C shell:
% setenv DISPLAY hostname(of91.orafact.com):0.0
3) Set the LD_LIBRARY_PATH environment variable to $ORACLE_HOME/lib;

5) Go to patch top directory where we unzipped the patchset and follow the below navigation path and execute the runinstaller utility.

$cd $PATCH_TOP/Disk1

$./runInstaller


6) Then , welcome screen comes like this ….


Click next to continue ,


7) On the Specify File Locations screen, click Browse next to the Path field in the Source section.


8) Select the products.xml file from the stage directory where you unpacked the patch set files, then click Next. For example:

patchset_directory/Disk1/stage/products.xml

9) In the Name field in the Destination section, select the name of the Oracle home that you want to update from the drop down list, then click Next.

10) then select a product to install and then click install ,it will automatically installed
Click 9i r12 patchset and click install


11) When prompted, run the $ORACLE_HOME/root.sh script as the root user.
Click exit after completion of installation.

Installing Patchset Non Interactively:


1) log in to oracle software user ( ora9i)
2) copy the response file template from the ,where patchset is unzipped . there is response directory is there.
3) Copy the file patchset.rsp to ORACLE_HOMEand edit the values appropriately like ORACLE_HOME etc etc .
4) To run Oracle Universal Installer, enter a command
$ ./runInstaller -silent -responsefile /d01/mt/ora9i/9.2.0.4/patchset.rsp
5) After the installation run the $ORACLE_HOME/root.sh script as a root user




Post installation Steps:



1) Users who have JVM (Java enabled) or JVM and XDB installed on their 9.2.0.1 databases should make sure that the init.ora parameters SHARED_POOL_SIZE and JAVA_POOL_SIZE are each 150 MB or more before running the catpatch.sql upgrade script

2) log in to oracle software user ( ora9i)

3) start the oracle Net listener by
$lsnrctl start

4) Use SQL*Plus to log in to the database as the SYS user with SYSDBA privileges:

$sqlplus /nolog;
Sql > connect sys/ as sysdba

6) Enter the following commands :
SQL> STARTUP MIGRATE
SQL> SPOOL patch.log
SQL> @ORACLE_HOME/rdbms/admin/catpatch.sql
SQL> SPOOL OFF


7) review the patch.log for any errors and look the list of components that is listed in the end of the log.

This is the log file output
COMP_NAME STATUS
----------------------------------- -----------
VERSION
----------------------------------------
Oracle9i Catalog Views VALID
9.2.0.8.0

Oracle9i Packages and Types VALID
9.2.0.8.0

Oracle Workspace Manager VALID
9.2.0.1.0


COMP_NAME STATUS
----------------------------------- -----------
VERSION
----------------------------------------
JServer JAVA Virtual Machine VALID
9.2.0.8.0

Oracle XDK for Java VALID
9.2.0.10.0

Oracle9i Java Packages VALID
9.2.0.8.0


COMP_NAME STATUS
----------------------------------- -----------
VERSION
----------------------------------------
Oracle interMedia VALID
9.2.0.8.0

Spatial VALID
9.2.0.8.0

Oracle Text VALID
9.2.0.8.0


COMP_NAME STATUS
----------------------------------- -----------
VERSION
----------------------------------------
Oracle XML Database VALID
9.2.0.8.0

Oracle Ultra Search VALID
9.2.0.8.0

Oracle Data Mining VALID
9.2.0.8.0


COMP_NAME STATUS
----------------------------------- -----------
VERSION
----------------------------------------
OLAP Analytic Workspace UPGRADED
9.2.0.8.0

Oracle OLAP API UPGRADED
9.2.0.8.0

OLAP Catalog VALID
9.2.0.8.0

DOC>================================================================
DOC> The above query lists the components in the database, along
DOC> with their current patchset version and status.
DOC>================================================================
DOC>*/



7) Restart the database
$shut immediate
$startup


8) Run the utlrp.sql script to recompile all invalid PL/SQL packages.
It is located in $ORACLE_HOME/rdbms/admin directory

Sql>@ORACLE_HOME/rdbms/admin/utlrp.sql

9) During patchset installation, all new files and directories are created
With restricted access,by default.In order to give permissions we will
Run changePerm.sh script which is locate in

$ORACLE_HOME/install directory.

• Go to $ORACLE_HOME/install
• ./changePerm.sh