Oracle® Database Server Version 11.1.0.7 Patch 55
Bundle Patch Update Note 14 Jan 2014
Release 11.1.0.7 for Microsoft Windows (x64)Oracle Non - RAC Database
Pre-Installation Instructions
1) Back up the current database that is installed, the %ORACLE_HOME% directory and Oracle inventory under c:\Program files\oracle directory.
This will help if there are problems applying the patch, and to restore the Inventory in case of an issue with the patch.
2) Perform a clean shutdown of all Oracle services (databases, Oracle listeners, Oracle agents, and so on.) that run from the Oracle Home where you install this patch.
3)Stop all Oracle services, Recovery catalog, ODBC applications, and other applications that use Oracle Client. This may include Web servers that load the Oracle client in the mid-tier environment.
4)Explicitly stop the Distributed Transaction Coordinator service (which is not an Oracle service) if it is running
Patch Installation Instructions
Follow these steps:
1)Cleanly shut down all processes running from the ORACLE_HOME.
2)Set the ORACLE_HOME environment variable to the correct Oracle home that needs to be patched.
> set ORACLE_HOME=<Oracle Home Path>
set PATH=C:\app\oracle\product\11.1.0\db_1\OPatch;%PATH%
3)Go to the directory where you downloaded the patch:
> cd 17906936
4)Ensure that the directory containing the OPatch script appears in your PATH setting. Enter the following command to run OPatch:
> opatch version
> opatch apply
5)Inspect the opatch<timestamp>.log file generated in %ORACLE_HOME%\cfgtoollogs\opatch if any error
Post-Installation Instructions
1) Start the OracleService<SID> and Oracle Listener Services if already not started.
2) Start all database instances running out of the ORACLE_HOME that you just patched
Installation (PSU)
3) For each database instance running out of the ORACLE_HOME being patched,
> cd %ORACLE_HOME%\Bundle\Patch55
> sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catcpu.sql
SQL> QUIT
To ensure all dependant objects are valid after running catcpu.sql:
(For large numbers of objects, this compilation step can take some time.
If you are applying this patch through the Oracle Enterprise Manager console,
you will be prompted to run this compilation script.)
Run the view recompilation script. Note that this script is run with the database in upgrade mode, which restricts connections as SYSDBA.
cd %ORACLE_HOME%\BUNDLE\view_recompile
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> SHUTDOWN
SQL> STARTUP UPGRADE
SQL> @view_recompile_jan2008cpu.sql
SQL> SHUTDOWN; SQL> STARTUP; SQL> QUIT
utlrp.sql script as follows:cd %ORACLE_HOME%\rdbms\admin sqlplus /nolog SQL> CONNECT / AS SYSDBA SQL> @utlrp.sql
Manual Recompile Objects
To check for invalid objects, execute the following statement:
SQL> SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS = 'INVALID';
SQL> SELECT COMP_ID,STATUS FROM DBA_REGISTRY;The solution therefore is to recompile the Trigger as SYSDBA:
sqlplus / as sysdba
SQL> alter trigger XDB.XDB_PI_TRIG compile; Trigger altered.
Tip
A useful SYS table exists that allows the DBA to query the database patching status, including post-installation steps:SELECT * FROM registry$history; ACTION_TIME ACTION NAMESPACE VERSION ID COMMENTS --------------- ------- ---------- --------- ------- ------------------ 26-JAN-10 12.33 APPLY SERVER 11.1.0.7 1 PSU 11.1.0.7.1 26-JAN-10 12.43 CPU 6452863 view recompilation
