Wednesday, October 29, 2014

Cursor sharing and RMAN errors on 11.2.0.2

Tonight I learned that if you have the gv$parameter cursor_sharing set to FORCE or SIMILAR on an 11.2.0.2 platform RMAN may spit out some odd ORA-01008 or ORA-07445 error messages.  My Oracle Support article "ORA-01008: RMAN backup fails with Assorted Errors on 11.2.0.2 if cursor sharing is enabled" via note ID 1472116.1 has all the details including the patch you need to apply in order to avoid "resolving" this by flushing the shared pool all the time.

No comments:

Post a Comment