Apply Oracle Database release 10.2.0.2 patch (4547817_10202) on Oracle Database 10g Release 2 (10.2.0.1) Installation On Red Hat Enterprise Linux 5 (RHEL5)

Preinstallaltion Task

• Shutdown the database instance cleanly
• Stop the database listner
• Stop the EM (emctl stop dbconsole)
• Set up environment variables ORACLE_HOME & ORACLE_SID
• Backup the system

Installation

• Extract the path into a temprory directory
• Run the installer from the patch directory

$./runInstaller

Welcome Screen

Oracle Home Details

Summary Screen

Progree Screen

Finish the patch software installation

Post Instllation

• 
  
  Sufficient space must be allocated for SYSTEM and SYSAUX tablespaces
• 
  
  Set the parameters values of SHARED_POOL_SIZE and JAVA_POOL_SIZE
• 
  
  If  necessary set the values of these parameters to at lease 150MB
• 
  
  How to view and set the values of these parameters
• 
  
  $sqlplus / as sysdba
• 
  
  SQL>startup nomount
• 
  
  SQL>show parameter shared_pool_size
• 
  
  SQL>show parameter java_pool_size
• 
  
  SQL>alter system set shared_pool_size='150M' scope=spfile;
• 
  
  SQL>alter system set java_pool_size='150M' scope=spfile;
• 
  
  SQL>shutdown
• 
  
  Upgrade the database
• 
  
  Start the listener
• 
  
  lsnrctl start
• 
  
  Start the database for upgrade
• 
  
  SQL>sqlplus / as sysdba
• 
  
  SQL>startup upgrade
• 
  
  SQL>spool patch.log
• 
  
  SQL>@$ORACLE_HOME/rdbms/admin/catupdgrd.sql
• 
  
  SQL>spool off
• 
  
  Verify the patch.log file for errors
• 
  
  Following error encountered in the patch.log file
• 
  
  select dbms_java.full_ncomp_enabled from dual
  
  *
  
  ERROR at line 1:
  
  ORA-29558: JAccelerator (NCOMP) not installed. Refer to Install Guide for
  
  instructions.
  
  ORA-06512: at "SYS.DBMS_JAVA", line 236
  
• 
  
  Above error can be ignored, or you can use the follwing solution

Solution for ORA-29558
SQL>shutdown

$lsnrctl stop

You will need to install Natively Compiled Java Libraries (NCOMP) from oracle database companion CD. This will install the basic version. So we need to apply the latest patch against the newly installed componenets.

Run the patch installer again and re-install Oracle Java client 10.2.0.1.

Run the database script again.

SQL>startup upgrade

SQL>spool patch.log

SQL>@$ORACLE_HOME/rdbms/admin/catupdgrd.sql
 
SQL>spool off


SQL>shutdown

SQL> startup



run the utlrp script to re-compile invalid databse opjects

SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sql