ORA-00235: controlfile fixed table inconsistent due to concurrent update

Problem Description

The following error maybe displayed:

INFO> Trying to create support package (base error:
FATAL-1154: Fetch failed on SQL '
select status from (
select 'ARCHIVE' status
from v$archived_log
where sequence# = ? and thread# = ?
union
select case
when max(sequence#) = ? then 'CURRENT'
when max(sequence#) > ? then 'ONLINE'
when max(sequence#) < ? then 'IDLE_OR_DISABLED_THREAD'
end
from v$log
where thread# = ?)
where rownum=1 ' with error ORA-00235: controlfile fixed table
inconsistent due to concurrent update (DBD ERROR: OCIStmtFetch)
)
2013/06/13 10:49:36 INFO> Messages dumped to trace file.
2013/06/13 10:49:37 INFO> Memory accounting dumped to trace file.
2013/06/13 10:50:40 FATAL> FATAL-1154: Fetch failed on SQL '
select status from (
select 'ARCHIVE' status
from v$archived_log
where sequence# = ? and thread# = ?
union
select case
when max(sequence#) = ? then 'CURRENT'
when max(sequence#) > ? then 'ONLINE'
when max(sequence#) < ? then 'IDLE_OR_DISABLED_THREAD'
end
from v$log
where thread# = ?)
where rownum=1 ' with error ORA-00235: controlfile fixed table
inconsistent due to concurrent update (DBD ERROR: OCIStmtFetch)

This is due to high activity on the source database and the underlying error is an Oracle error:

Error: ORA 235
Text: controlfile fixed table inconsistent due to concurrent update

Cause: Concurrent update activity on a controlfile caused a query on a controlfile fixed table to read inconsistent information.

Action: Retry the operation.

Solution

Restart the Mine process.

Arjen Visser June 14, 2013 10:52