Capture stopped due to error "ORA-00942" (4248764)

Shareplex for Oracle
event_log shows an error similar to

01/01/01 12:00 Error: sp_ocap(osp) (for o.queue queue o.queue) 12010 - error getting obj# for SHAREPLEX_CONFIG table due to ORA-00942: table or view does not exist.
01/01/01 12:00 Process exited sp_ocap (for o.queue queue o.queue [pid = 1782] - exit(1)

Shareplex uses SYS views to query the database, a new oracle feature called O7_DICTIONARY_ACCESSIBILITY adds a layer of security by disallowing access to the SYS views unless access is granted directly.  This can be verified by logging into oracle as the splex user and executing the following query.

sqlplus splex/splex
select (*) from sys.type$;

If this query comes back with "Table or View does not exist ORA-00942" one of two things needs to be done.

Option 1: change the O7_DICTIONARY_ACCESSIBILITY in the init.ora and bounce that instance

Option 2:
connect sys
spool foo.sql
select grant select on ||table_name|| to splex; from dba_tables where owner=SYS;
spool off
@ foo.sql

verify that the splex user can see the SYS tables "select (*) from sys.type$;"

restart the shareplex processes.

Option 3:

Grant the following system privileges to Shareplex user in source database:

1. sql> grant select any dictionary to <splex database user>;

2. sql> grant select any table to <splex database user> with admin option;

3. sql> grant create any view to <splex database user> with admin option;