Monday, September 15, 2014

Oracle 11.2.0.3 -- ORA-07445: exception encountered: core dump [qksopGetLBIdOpts()+?]

Problem

You encounter the following errors on your Oracle 11.2.0.3 database on the Windows system:
  • ORA-07445: exception encountered: core dump [qksopGetLBIdOpts()+39] [ACCESS_VIOLATION] [ADDR:0x0] [PC:0x1439F5A63] [UNABLE_TO_READ] []
or on Solaris:
  • ORA-07445: exception encountered: core dump [qksopGetLBIdOpts()+8] [SIGSEGV] [ADDR:0x0] [PC:0x103B55B68] [Address not mapped to object] []

Solution

Investigate the trace files generated and identify the statement which caused the error. Check if any fine-grained auditing policies are enabled for the objects used the statement. If any FGA policies are enabled, disable them and retry your operation

No comments: