Cannot Start Redo Collector After Upgrading The Source Database From 10g To 11g

(Doc ID 1276053.1)

Last updated on OCTOBER 24, 2017

Applies to:

Oracle Audit Vault - Version 10.2.3.2 and later
Information in this document applies to any platform.
Checked for relevance on 04-Jun-2013

Symptoms

After upgrading a source database from 10g to 11g the REDO collector cannot be started anymore:

avctl start_collector -collname REDO_white_1 -srcname white_1
Starting collector...
Failed to start collector srcwhite:REDO1_coll_white



The REDO Collector's log file contains the following messages:


Dec 22, 2010 10:18:20 AM Thread-14 SEVERE: Failed to start REDO collector
java.sql.SQLException: ORA-25338: operation 'start_capture' is not allowed for sync_capture 'AV$CAPTURE_1'
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 179
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 222
ORA-06512: at "SYS.DBMS_CAPTURE_ADM", line 33
ORA-06512: at "SRCWHITE.DBMS_SRC_STREAMS_COLLECTOR", line 2082
ORA-06512: at line 1

at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at
oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:675)
at
oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:601)
at
oracle.jdbc.driver.T2CCallableStatement.executeForDescribe(T2CCallableStatemen
t.java:571)
...

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms