Wednesday, October 29, 2014

Cursor sharing and RMAN errors on

Tonight I learned that if you have the gv$parameter cursor_sharing set to FORCE or SIMILAR on an 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 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