About Me

My photo
Bangalore, India
I am an Oracle Certified Professional working in SAP Labs. Everything written on my blog has been tested on my local environment, Please test before implementing or running in production. You can contact me at amit.rath0708@gmail.com.

Tuesday, July 1, 2014

ORA-07445: exception encountered: core dump [ph2csql_analyze()+2400] [SIGSEGV] [ADDR:0x0] [PC:0x1085403E0] [Address not mapped to object] []

Today I faced below mentioned error in my Prod Standby database. My standby database version is 11.2.0.2 .

Problem :-

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x1085403E0, ph2csql_analyze()+2400] [flags: 0x0, count: 1]
ORA-07445: exception encountered: core dump [ph2csql_analyze()+2400] [SIGSEGV] [ADDR:0x0] [PC:0x1085403E0] [Address not mapped to object] []
Use ADRCI or Support Workbench to package the incident.

Cause and Solution :-

This is a bug in 11.2.0.2 version . I searched in Metalink and got below DOC ID for it :-

Bug 11854279 - ora-7445 [ph2csql_analyze] in active data guard instance (Doc ID 11854279.8)

This bug is fixed in 11.2.0.3. It's because a synonym's object translation table being stale.

Temporary fix for this is :-

1. Flush the shared pool.

2. Bounce the DR databases.

I hope this article helped you.

Regards,
Amit Rath

No comments:

Post a Comment