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