DELETE OBSOLETE: ORA-19606: Cannot copy or restore to snapshot control file

DELETE OBSOLETE: ORA-19606: Cannot copy or restore to snapshot control file

Problem:
When trying to delete obsolete backups, rman includes the snapshot control file, and it is unable to delete it.
RMAN> delete noprompt obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1353 device type=DISK
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy     1      14-OCT-13          /mnt/PRDapps/oracle/trcprddb/11.2.0/dbhome_1/dbs/snapcf_TRCPRD.f
Backup Set           16413  17-OCT-13
  Backup Piece       16413  17-OCT-13          /backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16462_p1_2eomjh5d
Backup Set           16416  17-OCT-13
  Backup Piece       16416  17-OCT-13          /backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16464_p1_2gomk9fb
Backup Set           16417  17-OCT-13
  Backup Piece       16417  17-OCT-13          /backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16465_p1_2homk9fc
Backup Set           16415  17-OCT-13
  Backup Piece       16415  17-OCT-13          /backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16466_p1_2iomk9fc
Backup Set           16419  17-OCT-13
  Backup Piece       16419  17-OCT-13          /backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16468_p1_2komkd01
Backup Set           16421  17-OCT-13
  Backup Piece       16421  17-OCT-13          /backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16470_p1_2momkggs
Backup Set           16423  17-OCT-13
  Backup Piece       16423  17-OCT-13          /backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16472_p1_2oomkk0u
Backup Set           16425  17-OCT-13
  Backup Piece       16425  17-OCT-13          /backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16474_p1_2qomknhg
Backup Set           16427  17-OCT-13
  Backup Piece       16427  17-OCT-13          /backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16476_p1_2somkr1v
Backup Set           16429  17-OCT-13
  Backup Piece       16429  17-OCT-13          /backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16478_p1_2uomkuio
Backup Set           16431  17-OCT-13
  Backup Piece       16431  17-OCT-13          /backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16480_p1_30oml22v
Backup Set           16433  17-OCT-13
  Backup Piece       16433  17-OCT-13          /backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16482_p1_32oml5je
Backup Set           16435  17-OCT-13
  Backup Piece       16435  17-OCT-13          /backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16484_p1_34oml949
Backup Set           16437  17-OCT-13
  Backup Piece       16437  17-OCT-13          /backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16486_p1_36omlckg
Backup Set           16452  18-OCT-13
  Backup Piece       16452  18-OCT-13          /backups/RMAN_HOT/TRCPRD/db/TRCPRD_LVL1_20131018_s16500_p1_3komlusu
Backup Set           16453  18-OCT-13
  Backup Piece       16453  18-OCT-13          /backups/RMAN_HOT/TRCPRD/db/TRCPRD_LVL1_20131018_s16501_p1_3lomlut0
Backup Set           16450  18-OCT-13
  Backup Piece       16450  18-OCT-13          /backups/RMAN_HOT/TRCPRD/db/TRCPRD_LVL1_20131018_s16504_p1_3oomlutc
Backup Set           16451  18-OCT-13
  Backup Piece       16451  18-OCT-13          /backups/RMAN_HOT/TRCPRD/db/TRCPRD_LVL1_20131018_s16505_p1_3pomlute
deleted backup piece
backup piece handle=/backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16462_p1_2eomjh5d RECID=16413 STAMP=829015213
deleted backup piece
backup piece handle=/backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16464_p1_2gomk9fb RECID=16416 STAMP=829040108
deleted backup piece
backup piece handle=/backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16465_p1_2homk9fc RECID=16417 STAMP=829040108
deleted backup piece
backup piece handle=/backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16466_p1_2iomk9fc RECID=16415 STAMP=829040108
deleted backup piece
backup piece handle=/backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16468_p1_2komkd01 RECID=16419 STAMP=829043713
deleted backup piece
backup piece handle=/backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16470_p1_2momkggs RECID=16421 STAMP=829047324
deleted backup piece
backup piece handle=/backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16472_p1_2oomkk0u RECID=16423 STAMP=829050910
deleted backup piece
backup piece handle=/backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16474_p1_2qomknhg RECID=16425 STAMP=829054512
deleted backup piece
backup piece handle=/backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16476_p1_2somkr1v RECID=16427 STAMP=829058111
deleted backup piece
backup piece handle=/backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16478_p1_2uomkuio RECID=16429 STAMP=829061720
deleted backup piece
backup piece handle=/backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16480_p1_30oml22v RECID=16431 STAMP=829065311
deleted backup piece
backup piece handle=/backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16482_p1_32oml5je RECID=16433 STAMP=829068910
deleted backup piece
backup piece handle=/backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16484_p1_34oml949 RECID=16435 STAMP=829072521
deleted backup piece
backup piece handle=/backups/RMAN_HOT/TRCPRD/rman_arch/TRCPRD_ARCH_20131017_s16486_p1_36omlckg RECID=16437 STAMP=829076112
deleted backup piece
backup piece handle=/backups/RMAN_HOT/TRCPRD/db/TRCPRD_LVL1_20131018_s16500_p1_3komlusu RECID=16452 STAMP=829094819
deleted backup piece
backup piece handle=/backups/RMAN_HOT/TRCPRD/db/TRCPRD_LVL1_20131018_s16501_p1_3lomlut0 RECID=16453 STAMP=829094824
deleted backup piece
backup piece handle=/backups/RMAN_HOT/TRCPRD/db/TRCPRD_LVL1_20131018_s16504_p1_3oomlutc RECID=16450 STAMP=829094863
deleted backup piece
backup piece handle=/backups/RMAN_HOT/TRCPRD/db/TRCPRD_LVL1_20131018_s16505_p1_3pomlute RECID=16451 STAMP=829094863
Deleted 18 objects

RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212:   Object Type   Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Datafile Copy   /mnt/PRDapps/oracle/trcprddb/11.2.0/dbhome_1/dbs/snapcf_TRCPRD.f


Cause:
The snapshot controlfile is cataloged as a controlfile coy and is now obsolete. RMAN cannot delete this file as it is used by rman.

RMAN> show all;
RMAN configuration parameters for database with db_unique_name TRCPRD are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backups/RMAN_HOT/TRCPRD/db/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/mnt/PRDapps/oracle/trcprddb/11.2.0/dbhome_1/dbs/snapcf_TRCPRD.f'; # default


Solution:
•    Set new name (or location) for RMAN to use for snapshot controlfile:
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/tmp/snapcf_TRCPRD.f';

new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/tmp/snapcf_TRCPRD.f';
new RMAN configuration parameters are successfully stored

•    Crosscheck and delete the file from RMAN:
RMAN> crosscheck controlfilecopy "/mnt/PRDapps/oracle/trcprddb/11.2.0/dbhome_1/dbs/snapcf_TRCPRD.f";

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1353 device type=DISK
validation failed for control file copy
control file copy file name=/mnt/PRDapps/oracle/trcprddb/11.2.0/dbhome_1/dbs/snapcf_TRCPRD.f RECID=1 STAMP=828773553
Crosschecked 1 objects

RMAN> delete expired controlfilecopy "/mnt/PRDapps/oracle/trcprddb/11.2.0/dbhome_1/dbs/snapcf_TRCPRD.f";

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1353 device type=DISK
List of Control File Copies
===========================

Key     S Completion Time Ckp SCN    Ckp Time
------- - --------------- ---------- ---------------
1       X 14-OCT-13       32121181196 14-OCT-13
        Name: /mnt/PRDapps/oracle/trcprddb/11.2.0/dbhome_1/dbs/snapcf_TRCPRD.f
        Tag: TAG20131014T065231


Do you really want to delete the above objects (enter YES or NO)? YES
deleted control file copy
control file copy file name=/mnt/PRDapps/oracle/trcprddb/11.2.0/dbhome_1/dbs/snapcf_TRCPRD.f RECID=1 STAMP=828773553
Deleted 1 EXPIRED objects

•    Now try deleting the obsolete backups

RMAN> delete noprompt obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
using channel ORA_DISK_1
no obsolete backups found

•    Set the snapshot controlfile name (or location) to original:
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/mnt/PRDapps/oracle/trcprddb/11.2.0/dbhome_1/dbs/snapcf_TRCPRD.f';

old RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/tmp/snapcf_TRCPRD.f';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/mnt/PRDapps/oracle/trcprddb/11.2.0/dbhome_1/dbs/snapcf_TRCPRD.f';

libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6

Description:
On an E-Business Suite Release 11i Instance, Cloning /or Autoconfig execution is failing with error :
$ORACLE_HOME/8.0.6/jre1183o/bin/../lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference (libzip.so)
Unable to initialize threads: cannot find class java/lang/Thread
Could not create Java VM

 

Cause

The JRE 1.1.8 and the JRE / Java SDK 1.3.1 have never been certified for the Red Hat or Oracle Enterprise Linux 5 Operating System.

Workaround:

Basically what I did was:

$ which java
/app/oracle/testcomn/util/java/1.6/jdk1.6.0_38/bin/java

cd $ORACLE_HOME/

mv jre1183o jre1183o_old

mkdir jre1183o

cd jre1183o

cp -rp /app/oracle/testcomn/util/java/1.6/jdk1.6.0_38/jre/* .
chmod -R 777 *

This Solution can be used for many errors of java.

The other fix for this was to set the LD_ASSUME_KERNEL environmental variable before starting
ispconfig_tcpserver. ultimately, i added the following to line 61 of /etc/init.d/ispconfig_tcpserver

 LD_ASSUME_KERNEL=2.4.1

Error: can't find libjava.so when running adcfgclone.pl appsTier

Hi All,

Description
Recently I met the above issue while performing Oracle Applications Cloning for Release 11i environment on Red Hat Enterprise 5.4 64-bit O.S.

Running,
perl adcfgclone.pl appsTier
Enter the APPS password [APPS]: <Password>

First Creating a new context file for the cloned system.

The program is going to ask you for information about the new system:

Error: can't find libjava.so.

ERROR: context creation not completed successfully.

Please check /tmp/adcfgclone_28635.err file for errors

In  /tmp/adcfgclone_28635.err file

/app/oracle/testcomn/clone/bin/../jre/bin/java[18]: /usr/bin/basename: not found [No such file or directory]
/app/oracle/testcomn/clone/bin/../jre/bin/java[19]: /usr/bin/uname: not found [No such file or directory]
 

Workaround:

1. As applmgr user, run which java

[applmgr@tfnvlskp01 ]$ which java

/usr/bin/java

2. Go to java directory where it is installed on applications node

[applmgr@tfnvlskp01 ]$ cd $COMMON_TOP/clone/jre/bin

 

[applmgr@tfnvlskp01 bin]$ ls

awt_robot  ControlPanel  java  keytool  Policytool  rmid  rmiregistry  sparc  tnameserv

3. Rename java folder.

[applmgr@tfnvlskp01 bin]$ mv java jav_old

 4. Create a soft link with the location of which java from Step 1

[applmgr@tfnvlskp01 bin]$ ln -s /usr/bin/java java

[applmgr@tfnvlskp01 bin]$ ls -l

total 68

-rwxr-xr-x 1 applmgr dba 34456 Sep  2  2009 awt_robot

-rwxr-xr-x 1 applmgr dba  1304 Sep  2  2009 ControlPanel

lrwxrwxrwx 1 applmgr dba    13 Oct 14 05:09 java -> /usr/bin/java

-rwxr-xr-x 1 applmgr dba  2505 Sep  2  2009 jav_old

-rwxr-xr-x 1 applmgr dba  2505 Sep  2  2009 keytool

-rwxr-xr-x 1 applmgr dba  2505 Sep  2  2009 Policytool

 
5. Run perl adcfgclone.pl appsTier again

ERROR : Unable to set CLASSPATH ../jlib/classes111.zip: is missing

Hi All,

Description
Recently I met the above issue while performing Oracle Applications Cloning for Release 11i environment on Red Hat Enterprise 5.4 64-bit O.S.

Running,

perl adcfgclone.pl appsTier
Enter the APPS password [APPS]: <Password>

ERROR : Unable to set CLASSPATH
<Path to $COMMON_TOP>/clone/bin/../jlib/classes111.zip: is missing

First Creating a new context file for the cloned system.
The program is going to ask you for information about the new system :

ERROR: context creation not completed successfully.
Please check /tmp/adcfgclone.err file for erros

...

Cause

The first error indicates, that the file 'Classes111.zip' is missed.

Solution

To implement the solution, please execute the following steps :

1. Copy from $iAS_TOP/portal30/admin/plsql/lib/classes111.zip to $COMMON_TOP/clone/jlib/classes111.zip :

Workaround:-

[applmgr@tfnvlskp01 8.0.6]$ cd /app/oracle/testora/iAS/portal30/admin/plsql/lib/

[applmgr@tfnvlskp01 lib]$ ls classes111.zip

classes111.zip

[applmgr@tfnvlskp01 lib]$ cd /app/oracle/testcomn/clone/jlib/

[applmgr@tfnvlskp01 jlib]$ ls classes111.zip

ls: classes111.zip: No such file or directory

[applmgr@tfnvlskp01 jlib]$ cp /app/oracle/testora/iAS/portal30/admin/plsql/lib/classes111.zip /app/oracle/testcomn/clone/jlib/

 

Startup Fails With ORA-01012: Not Logged On

Problem Description
Users cant able to login to database server. Though it allow sysdba to login, it does not allow to run any query. Sometimes it will show database is connected to an idle instance. But when we startup database it shall throw error ORA-01081: cannot start already-running ORACLE - shut it down first.

 $ sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.3.0 Production on Sat Oct 12 07:53:11 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select instance_name,status from v$instance;
ERROR at line 1:
ORA-01012: not logged on

SQL> desc v$instance
ERROR:
ORA-01012: not logged on

SQL> startup
ORA-01012: not logged on


Changes
Oracle has been forcefully shutdown at OS level or crashed.

 CAUSE
An orphaned shared memory segment belonging to the ORACLE_SID still exists from a previous instance startup.

The command
ps -ef | grep $ORACLE_SID

shows no processes but with ORACLE_SID set the Oracle 'sysresv' utility shows a shared memory segment for a non-existing instance, e.g.

 $ sysresv

IPC Resources for ORACLE_SID "TEST" :

Shared Memory:
ID              KEY
5963794         0x00000000
5996563         0x00000000
6029332         0xb2e3c9ac

Semaphores:
ID              KEY
No semaphore resources used
Oracle Instance not alive for sid "TEST"


Solution
On OS level, remove the orphaned shared memory segment using:

ipcrm -m <problem shared memory id>

$ ipcrm -m 5963794
$ ipcrm -m 5996563
$ ipcrm -m 6029332

$sqlplus '/as sysdba'

Connected to an idle instance.

SQL> startup Oracle instance started
Total System Global Area   10689474560 bytes
Fixed Size                     2237776 bytes
Variable Size               6375344816 bytes
Database Buffers            4294967296 bytes
Redo Buffers                  16924672 bytes
Oracle Instance Started.
Oracle Database Opened.

List of few Apps related tables

List of few Apps related tables

CONCURRENT REQUEST/PROGRAM/MANAGERS
-------------------
FND_CONCURRENT_QUEUES
FND_CONCURRENT_PROGRAMS
FND_CONCURRENT_REQUESTS
FND_CONCURRENT_PROCESSES
FND_CONCURRENT_QUEUE_SIZE

FND/AOL Tables
--------------
FND_APPL_TOPS
FND_LOGINS
FND_USER
FND_DM_NODES
FND_TNS_ALIASES
FND_NODES
FND_RESPONSIBILITY
FND_DATABASES
FND_UNSUCCESSFUL_LOGINS
FND_LANGUAGES
FND_APPLICATION
FND_PROFILE_OPTION_VALUES

AD/Patches
-------------
AD_APPLIED_PATCHES
AD_PATCH_DRIVERS
AD_BUGS
AD_INSTALL_PROCESSES
AD_SESSIONS
AD_APPL_TOPS 

Cloning fails at 50% with RC-00118 or RC-50004 after creating control files

-------------------ADX Database Utility Finished---------------
RC-00118: Error occurred during creation of database
Raised by oracle.apps.ad.clone.ApplyDatabase

StackTrace:
        java.lang.Exception: Control file creation failed
        at oracle.apps.ad.clone.ApplyDatabase.doConf(ApplyDatabase.java:635)
        at oracle.apps.ad.clone.ApplyDatabase.doApply(ApplyDatabase.java:473)
        at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:366)
        at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:110)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:67)
        at java.lang.Thread.run(Unknown Source)
====================================================================




Cause:

 The listener.ora contains the source listener name

This was originally resolved in CloneContext.java (12.1 - 120.92.12010000.16) but is present again in version: 120.92.12010000.24

This is reported in Bug :12598630 - R12 CLONING FAILS AT 50% DUE TO LISTENER.ORA CONTAINING SOURCE NAME


Workaround:

The Workaround is to make the change on the temporary stage context file prior to the file copy:

1. edit CTXORIG.xml either after adpreclone.pl or before adcfgclone.pl
2. change the s_db_listener value from Source to Target
3. copy files to target
4. run perl adcfgclone.pl dbTier

If the Clone has already failed, the workaround/solution would be:

1. correct the s_db_listener value in the Target context file
2. shutdown the target Database
3. run: perl adcfgclone.pl dbtier /path/to/contextfile.xml

ORA-07445: exception encountered: core dump [qkxrPXformUnm()+46] [SIGSEGV] [ADDR:0x20] [PC:0x1A3E55E] [Address not mapped to object] []

Getting ORA-01041 error in ARXCWMAI after upgrade to 11.2.0.3.0.
 
Also from alert log
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x20] [PC:0x1A3E55E, qkxrPXformUnm()+46] [flags: 0x0, count: 1]
Errors in file /mnt/PRDapps/oracle/trcprddb/11.2.0/dbhome_1/log/diag/rdbms/trcprd/TRCPRD/trace/TRCPRD_ora_9840.trc  (incident=963153):
ORA-07445: exception encountered: core dump [qkxrPXformUnm()+46] [SIGSEGV] [ADDR:0x20] [PC:0x1A3E55E] [Address not mapped to object] []

Customer having the same error as shown in the alert log.
 

Cause

Bug 13722843: AFTER UPGRADE TO RDBMS 11.2.0.3.0, CUSTOMER ACCOUNTS FORM GETTING MANY ERRORS.

Solution

This is a known issue you are running into. Below are the fixes provided by the RDBMS team.

1. Patch fix:
Patch 12834800, followed by the below steps,

· Log onto My Oracle Support
· Click the ‘Patches and Downloads’ tab
· Click ‘Simple Search’
· In the blank text box type in your patch number: 12834800
· In the Platform and Language pull down box select your OS
· Click the ‘Go’ button.
· Check to see if your one-off exists and if so, then click the Download button.
· Note: Please review the Readme file for instructions on how to install the patch.
Workarounds:
2. Change the following RDBMS setting:
"_replace_virtual_columns"=false

We do however have a simple workaround that you can have your DBA implement and it will resolve the errors.  Please note that this change is supported by Oracle. It's just a simple fix so you can use the form:

3. Make changes in the view AR_CUSTOMER_ACCOUNTS_CA:
Instead of SUBSTRB(PARTY.PARTY_NAME",1,50) use
UPPER(SUBSTRB(PARTY.PARTY_NAME,1,50) )