event_log shows "error getting obj# for SHAREPLEX_CONFIG table due to ORA-00942" (4246378)

event_log shows "error getting obj# for SHAREPLEX_CONFIG table due to ORA-00942"

Shareplex for Oracle
event_log shows the following error.
01/01/01 11:11 Error: sp_ocap(osp) (for o.<SID>S queue o.<SID>) 12010 - error getting obj# for SHAREPLEX_CONFIG table due to ORA-00942: table or view does not exist.
01/01/01 11:11 Process exited sp_ocap (for o.<SID> queue o.<SID) [pid = 9212] - exit(1)

This is caused by the Oracle init.ora parameter O7_DICTIONARY_ACCESSIBILITY that was introduced in oracle 8. This parameter adds a level of security to oracle by not allowing users other than SYS access to SYSs objects. Since the meaning of this parameter has changed in different versions of oracle, it cant be stated whether the parameter needs to be "TRUE" or "FALSE" for your version of Oracle. A quick simple test is to try to access a SYS object with the shareplex "splex" user.

sqlplus splex/splex
desc sys.type$ if this query comes back with a description of the table this parameter is not blocking assess to the SYS schema. If an error is returned and you get an ORA-00942 error when trying to select out of this table then the parameter is blocking access to the SYS objects.