Tuesday, May 18, 2010

ORA-07445 [kopxccc()+124] error trying to submit a concurrent request

I am writing this blog entry to share an interesting error with you. There is a parameter ORA_NLS10 without setting which, the database was throwing a lot of ORA-07445 errors. I spoke about the ORA_NLS10 parameter in a previous post. A related issue was occuring here too.

Issue

Unable to submit concurrent requests. Receiving the below error:

APP-FND-01564: ORACLE error 3113 in FDFDDS_RAISE_DFF_COMPILED


Also, receiving ORA-07445 errors in the alert log.

Mon May 17 05:54:00 2010
Completed: ALTER DATABASE OPEN
Mon May 17 05:57:12 2010
Errors in file /u005/app/oracle/cpe2eprd/cpe2eprddb/10.2.0/admin/cpe2eprd_cpeidb/udump/cpe2eprd_ora_1094.trc:
ORA-07445: exception encountered: core dump [lfilic()+328] [SIGSEGV] [Address not mapped to object] [0x000000040] [] []
Mon May 17 06:03:18 2010
Errors in file /u005/app/oracle/cpe2eprd/cpe2eprddb/10.2.0/admin/cpe2eprd_cpeidb/udump/cpe2eprd_ora_2966.trc:
ORA-07445: exception encountered: core dump [kopxccc()+124] [SIGSEGV] [Address not mapped to object] [0x000000062] [] []
Mon May 17 06:06:40 2010
Errors in file /u005/app/oracle/cpe2eprd/cpe2eprddb/10.2.0/admin/cpe2eprd_cpeidb/udump/cpe2eprd_ora_3956.trc:
ORA-07445: exception encountered: core dump [kopxccc()+124] [SIGSEGV] [Address not mapped to object] [0x000000062] [] []


Cause

Database was started with incorrect ORA_NLS10 parameter.

Analysis

As per MOS Note ID: 553264.1, ORA_NLS10 parameter should be set to $ORACLE_HOME/nls/data/9idata.

Solution

1. Shutdown the database.

2. Set the parameter ORA_NLS10 to the correct value as per MOS Note ID: 553264.1

export ORA_NLS10=$ORACLE_HOME/nls/data/9idata

3. Startup the database.


References

1. MOS Note ID: 553264.1

No comments: