Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
event_log shows "error getting obj# for SHAREPLEX_CONFIG table due to ORA-00942"
Description
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.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.