Patch 5983622 to certify oas on suse 10

Follow this steps to apply the patch 5983622 (all components middle tier, infraestructure and database are on the same server):

1.      Apply the Oracle Database 10g Release 10.1.0.5 Patch Set on infraestructure repository. The patch is  p4505133_10105_LINUX.
2.      Apply the Software Update (patch 5983622) to the middle tier installation.
3.      Apply the Software Update (patch 5983622) to infraestructure.
4.      Apply the Metadata Repository Update  (patch 5983622) using the middle tier installation
 

Applying the Oracle Database 10g Release 1 (10.1.0.5) Patch Set
Stop all: the middle tier, the infraestructure, the listener and the database.

Set this enviroment variables:

export ORACLE_HOME=/opt/oracle/infra

export ORACLE_SID=infra

export DISPLAY=hostname:0.0

Run runInstaller on Disk1 of patch p4505133_10105_LINUX, after installation follow this steps:

Start the Oracle instance using the following commands:

            SQL> connect SYS as SYSDBA

            SQL> startup

Set the value of the SHARED_POOL_SIZE initialization parameter to at least 150 MB, if using a server parameter file. Log in as the sys user and use the following command to check the parameter:

            SQL> show parameter SHARED_POOL_SIZE

If the parameter is less than 150 MB, then use the following command to set it:

            SQL> ALTER SYSTEM SET SHARED_POOL_SIZE='150M' SCOPE=spfile;

Set the value of the JAVA_POOL_SIZE initialization parameter to at least 150 MB, if necessary. Log in as the sys user and use the following command to check the parameter:

            SQL> show parameter JAVA_POOL_SIZE

If the parameter is less than 150 MB, then use the following command to set the parameter:

            SQL> ALTER SYSTEM SET JAVA_POOL_SIZE='150M' SCOPE=spfile;

Shut down the database using the following command:

            SQL> SHUTDOWN IMMEDIATE

Enter the following SQL*Plus commands:

            SQL> STARTUP UPGRADE

            SQL> SPOOL patch.log

            SQL> @/ORACLE_HOME/rdbms/admin/catpatch.sql

            SQL> SPOOL OFF

Review the patch.log file for errors and inspect the list of components that is displayed at the end of the catpatch.sql script. This list provides the release and status of each SERVER component in the database.

If necessary, re-run the catpatch.sql script to correct any problems.

Restart the database as follows. You must be logged in as a member of the dba group in order to start the database.

            SQL> SHUTDOWN

            SQL> STARTUP

Run the utlrp.sql script as the sys user to recompile all invalid PL/SQL packages. Use the following command to run the script:

            SQL> @/ORACLE_HOME/rdbms/admin/utlrp.sql
 
When i run this script it hangs, so i search on database log in /opt/oracle/admin/infra/bdump>  alert_infra.log

And this altert log shows me that my flash recovery area was full, because of that I couldn’t shutdown the database, so I alter the db_recovery_file_dest_size:

select name
, floor(space_limit / 1024 / 1024) “Size MB”
, ceil(space_used / 1024 / 1024) “Used MB”
from v$recovery_file_dest
order by name
/

alter system set db_recovery_file_dest_size=4g

Then i put my database in noarchivelog:

1) Shutdown the database using Shutdown normal/immediate
2) Mount the database using startup mount
3) Alter database noarchivelog;
4) Alter database open;

And now the script runs ok:

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

You will see an ORA-29558:JAccelerator (NCOMP) not installed error when you apply the patchset to a database where the Natively Compiled Java Libraries (NCOMP) files are not present. If you do not use Java in the database, then ignore this error message.

If you use Java in the database, then install the NCOMP libraries by selecting the Oracle Database 10g Products installation type from the Oracle Database Companion CD. For information about installing the Oracle Database 10g Products installation type from the Companion CD, see Oracle Database Companion CD Installation Guide.

After applying this patch when i start my infraestructure it gives this error: Internal error message 684 could not be found in the msb file

I found the solution on metalink:
Applies to:

Oracle Application Server 10g Enterprise Edition - Version: 10.1.2.0.0 to 10.1.2.3.0
This problem can occur on any platform.
Checked for relevance on 07-May-2009
Symptoms

    * After applying the RDBMS 10.1.0.5 patchset to an Application Server 10.1.2.x.x ORACLE_HOME, any $ORACLE_HOME/opmn/bin/opmnctl command generates the following error message:

Internal error message 684 could not be found in the msb file
Internal error message 684 could not be found in the msb file
Internal error message 684 could not be found in the msb file

    * The opmn command executes correctly, but this error message is given out.
    * You may also hit this issue after applying the 10.1.2.3 Application Server Patchset to any install type on HP-UX Itanium

Cause

With regard to applying a 10.1.0.5 patchset, the issue is caused due to a mismatch of the OPMN MSB files

This error message will occur any time that the OPMN NLS message files do not match the binaries with which they are associated. Since the 10g database uses OPMN as well, a patch from the database has caused this issue. The database MSB files do not match the OPMN MSB files shipped with the Application Server.

For the 10.1.2.3 HPUX Itanium issue this is Bug 8414226 APPEAR ERROR MESSAGE ' 684 COULD NOT BE FOUND' AFTER APPLYING PSR 10.1.2.3
Solution

To implement the solution on UNIX, please execute the following steps:

1. Stop the Application Server (AS) processes with $ORACLE_HOME/opmn/bin/opmnctl stopall
2. Get the backup of the AS environment taken before the database patch has been installed.
3. Navigate to the directory $ORACLE_HOME/opmn/mesg
4. Replace all files in this directory with the files from the backup (Location $ORACLE_HOME/opmn/mesg)

Alternatively, the msb files can also be restored from the Application Server 10.1.2.0.2 installation CD:

1. cd $ORACLE_HOME/opmn/mesg
2. mkdir save
3. mv *mesg save
4. jar xvf <mpt>/Disk1/stage/Components/oracle.opmn/10.1.2.0.0/1/DataFiles/mesg.3.<x>.jar
    or
    jar xvf <mpt>/Disk1/stage/Components/oracle.opmn/10.1.2.0.2/1/DataFiles/mesg.3.<x>.jar
    or
   jar xvf <mpt>/Disk1/stage/Components/oracle.opmn/10.1.2.1.0/1/DataFiles/mesg.3.<x>.jar

Notes:
1. Please ensure your $PATH includes $ORACLE_HOMEjdk/bin
2. <mpt> is the name of the mountpoint on which your install CD is mounted
3. <x> is any minor version number for this file. Apply the Software Update (patch 5983622) to the middle tier installation.

Stop db console:

ORACLE_HOME/bin/emctl stop dbconsole

Run /home/oracle/Disk1 ./runInstaller

Select option Oracle Application Server and Developer suite 10g rel 2 software update 10.1.2.3.0
 
3. Apply the Software Update (patch 5983622) to infraestructure.
Run again /home/oracle/Disk1 ./runInstaller

Choose this option Oracle Application Server and Developer suite 10g rel 2 software update 10.1.2.3.0

The installer ask to stop the listener and the database, so if they are up stop them.
When the installer was configurating OID it gives an error, so I start the database and the listener, and set the variables :
oracle_home
oracle_sid
tns_admin=/opt/oracle/infra/network/admin/
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:/usr/ccs/bin:$PATH
 
And then the installer finish ok.
 
4. Apply the Metadata Repository Update (patch 5983622)  using the middle tier installation

Stop middle tier :
ORACLE_HOME/bin/emctl stop
ORACLE_HOME/opmn/bin/opmnctl stopall
Run again /home/oracle/Disk1 ./runInstaller
And choose this option: Oracle metadata repositorio