Saturday, July 11, 2009

Upgrade 11.1.0.6 to 11.1.0.7

On each application tier server node,
shut down all server processes or services.

On the database tier server node,
shut down the database listener in the old Oracle home.

On the database server node,
as the owner of the Oracle 11g file system and database instance, unzip and extract the 11.1.0.7 patch set file for your platform.

Set the environment to the oracle_home to be upgraded.
Use the runInstaller in the patchset to start the OUI.

./runinstaller -invPtrLoc /oraDb/app/oracle/....../11.1.0

I did this as my global inventory is not set.

Once the OUi starts from the LOV s in the Oracle_home list choose the appropriate one to be upgraded and the location also.

The present oracle_home and its location will appear if the environment is set correctly.

Proceed with the next steps on the OUI screen.

Click Next when it says Configuration Assistant has failed.
This skips the other configuration assistants also ,whixh actually are not required by E-business Suite Installations.

Post Installation

Once done Apply the RDBMS patches
7486407 and 7684818

to this Oracle_home, which are as always applied using opatch..

Gather statistics for SYS schema

Copy $APPL_TOP/admin/adstats.sql from the administration server node to the database server node.

$ sqlplus '/ as sysdba'
SQL> shutdown normal;
SQL> startup restrict;
SQL> @adstats.sql
SQL> shutdown normal;
SQL> startup;
SQL> exit;

This finishes upgrade of 11.1.0.6 to 11.1.0.7

Check it :
SQL> select banner from v$version;

Restart all the Applications server processes
that you shut down before installing the patch set. Users may return to the system.

No comments:

Post a Comment