BPEL 11g - Sending Large Payloads to an EDN Event Causes "ORA-19011: Character string buffer too small" Error (Doc ID 1548579.1)

BPEL 11g - Sending Large Payloads to an EDN Event Causes "ORA-19011: Character string buffer too small" Error (Doc ID 1548579.1)

Patch Name/Number: 13801175

1         Steps followed for applying patch:

1.       Shutdown  all the SOA servers(Admin and SOA Servers).

2.       Set the ORACLE_HOME environment variable to SOA Home,

       for example "[MW_HOME]/Oracle_SOA1" directory.

3.       Place the downloaded patch into /Oracle_SOA1/PATCH_TOP(If folder structure does not exist, create it).

4.       Unzip the Patch and change the directory to “cd PATCH_TOP/13801175 ”.

5.       Run Opatch apply.

$ORACLE_HOME/OPatch/opatch apply

 We can see the message as “patch applied successfully”.

Note : In case SOA servers running in two different machine, Place the downloaded patch in both the machines. Also Patch needs to be deployed in both the machines using below instructions.

Post Install Instructions:

6.       Run sqlplus to apply the patch. Note that this needs to be run for all the

SOA schemas in the installation.  Ensure you provide a username for and .

   Run following command:

cd $ORACLE_HOME/rcu/integration/soainfra/patches/    sqlplus /@ @upgrade_soainfra_edn_13811964.sql

Examples:

 In an Oracle SOA Suite installation,  and  could be DEV_SOAINFRA, TEST_SOAINFRA, PROD_SOAINFRA or ; eg:

cd $ORACLE_HOME/rcu/integration/soainfra/patches/

   sqlplus DEV_SOAINFRA/@ @upgrade_soainfra_edn_13811964.sql DEV_SOAINFRA

7.       Start all servers (AdminServer and all SOA Servers)

2         Verifying the patch applied:

1.       Execute by following command.

$ORACLE_HOME/OPatch/opatch lsinventory

Ensure that the patch name is available in the list. 

Note : In case SOA servers running in two different machine, verify patch existence in both the machines.

3         Rollback the Patch applied

1.       Execute by following command in both SOA boxes.

$ORACLE_HOME/OPatch/opatch rollback -id 13801175

2.       Start all the SOA servers.