Search Blog Post

Monday, October 7, 2013

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) )
 

No comments:

Post a Comment