Oracle Database 11g Release 2 (11.2.0.3.0)

Oracle Text Patch for Bug# 13366268 for Generic Platforms

(DG Rolling Installable Patch and RAC Rolling Installable Patch)

Released: Dec 21, 2011

This document describes how you can install the Oracle Text one-off patch for bug# 13366268 on your Oracle Database 11g Release 2 (11.2.0.3.0).


Prerequisites
--------------

Before you install or deinstall the patch, ensure that you meet the
following requirements:


Note:

In case of an Oracle RAC environment, meet these prerequisites on each
of the nodes.


 1. Ensure that the Oracle Database on which you are installing the
    patch or from which you are rolling back the patch is Oracle
    Database 11g Release 2 (11.2.0.3.0).

 2. Ensure that you have the latest version of OPatch.

    If you do not have the latest version, then follow the instructions
    outlined in the My Oracle Support note 224346.1 available at:

    https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=224346.1

 3. Ensure that you set the ORACLE_HOME environment variable to the
    Oracle home of the Oracle Database.

 4. Ensure that you set the PATH environment variable to include the
    location of the unzip executable, and the <ORACLE_HOME>/bin and
    the <ORACLE_HOME>/OPatch directories present in the Oracle home of
    the Oracle Database.

 5. Ensure that you verify the Oracle Inventory because OPatch accesses
    it to install the patches. To verify the inventory, run the
    following command. If the command displays some errors, then contact
    Oracle Support and resolve the issue.

    $ opatch lsinventory

 6. Ensure that you shut down all the services running from the Oracle home.


    Note:

      * For a Non-RAC environment, shut down all the services running
        from the Oracle home.

      * For a RAC environment, shut down all the services (database,
        ASM, listeners, nodeapps, and CRS daemons) running from the
        Oracle home of the node you want to patch. After you patch this
        node, start the services on this node. Repeat this process for
        each of the other nodes of the Oracle RAC system. OPatch is used
        on only one node at a time.


 7. Ensure that you install the following prerequisite patches:

      * NONE

Installation
-------------

To install the patch, follow these steps:


Note:

In case of an Oracle RAC environment, perform these steps on each of the
nodes.


 1. Maintain a location for storing the contents of the patch ZIP file.
    In the rest of the document, this location (absolute path) is
    referred to as <PATCH_TOP_DIR>.

 2. Extract the contents of the patch ZIP file to the location you
    created in Step (1). To do so, run the following command:

    $ unzip -d <PATCH_TOP_DIR> p13366268_112030_GENERIC.zip

 3. Navigate to the <PATCH_TOP_DIR>/13366268 directory:

    $ cd <PATCH_TOP_DIR>/13366268

 4. Install the patch by running the following command:

    $ opatch apply


    Note:

    When OPatch starts, it validates the patch and ensures that there
    are no conflicts with the software already installed in the
    ORACLE_HOME of the Oracle Database. OPatch categorizes conflicts
    into the following types:
      * Conflicts with a patch already applied to the ORACLE_HOME - In
        this case, stop the patch installation and contact Oracle
        Support Services.

      * Conflicts with a patch already applied to the ORACLE_HOME that
        is a subset of the patch you are trying to apply - In this case,
        continue with the patch installation because the new patch
        contains all the fixes from the existing patch in the
        ORACLE_HOME. The subset patch will automatically be rolled
        back prior to the installation of the new patch.


 5. Start the services from the Oracle home.


Postinstallation
------------------

After you install the patch, reload the packages into the Oracle Database.

SQL> ALTER SESSION SET CURRENT_SCHEMA=CTXSYS
SQL> @/ctx/admin/drisgp.plb 
SQL> @/ctx/admin/drvddl.plb 
SQL> @/ctx/admin/drvxtab.plb

Note:

In case of an Oracle RAC environment, reload the packages on one of the
nodes.


Deinstallation
---------------

To deinstall the patch, follow these steps:


Note:

In case of an Oracle RAC environment, perform these steps on each of the
nodes.


 1. Navigate to the <PATCH_TOP_DIR>/13366268 directory:

    $ cd <PATCH_TOP_DIR>/13366268

 2. Deinstall the patch by running the following command:

    $ opatch rollback -id 13366268

 3. Start the services from the Oracle home.


Postdeinstallation
-------------------

After you deinstall the patch, reload the packages into the Oracle Database.

SQL> ALTER SESSION SET CURRENT_SCHEMA=CTXSYS
SQL> @/ctx/admin/drisgp.plb
SQL> @/ctx/admin/drvddl.plb
SQL> @/ctx/admin/drvxtab.plb

Note:

In case of an Oracle RAC environment, reload the packages on one of the
nodes.


Bugs Fixed by This Patch
--------------------------

The following are the bugs fixed by this patch:

  * 13366268 - ENCOUNTERED ORA 7445 [DRUHFIND()+370] WHILE RUNNING APPS RT 

------------------------------------------------------------------------

Copyright 2011, Oracle and/or its affiliates. All rights reserved.

