How to Manually Enable the Patch for Bug:14373728 on Oracle 11g Release 11.2.0.4 (Doc ID 1537496.1)

Pre-installation

Shutdown the database cleanly.

Installation steps

1. If you are running on a RAC environment, set cluster_database=false in the init.ora, otherwise no change is necessary.
2. Check the "compatible" parameter. Make sure that it is set to 11.0.0.0 or higher. If "compatible" is less than 11.0.0.0., please update its value to at least 11.0.0.0 before the next step.
3. Startup the database in upgrade mode:

SQL> startup upgrade 

4. Run the dictionary upgrade script.

SQL> @?/rdbms/admin/b14373728.sql

5. Shutdown the database.
6. If you are running on a RAC environment, set cluster_database=true in the init.ora, otherwise no change is necessary.
7. Startup the database in normal mode:

SQL> startup

+++++++++++++++++++++

Note:14373728.8 Bug 14373728 - Old statistics not purged from SYSAUX tablespace

Doc ID 14373728.8