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] []
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