Post is very slow and or is stopping with an error message that looks something like.
Error 2011-10-04 13:52:42. 1 Poster: 12620a - OCIStmtExecute failed with ORA-942. (posting from irbp2, queue Q2, to target) [module osp]
Warning 2011-10-04 13:52:42. 1 Poster: Main thread waiting for syncop.done for 1319 seconds (posting from target, queue Q2, to target) [module opo]
Notice 2011-10-04 13:52:39.020397 20231 7 Poster: Operation is not blocked -- just taking longer than expected on "OWNER"."TABLENAME". Make sure proper index is being used. (posting from target, queue Q2, to target) [module opo]
This is caused by a query that post does in order to determine if it is blocking itself. This query is failing due to to inability of the session to query the dba_locks table. The query is as follows.
select h.session_id, h.lock_type, h.mode_held,
h.lock_id1, h.lock_id2 from dba_locks h
where h.blocking_others = 'Blocking'
and h.mode_held != 'None'
and h.mode_held != 'Null';
1 check that the owner of the table SYS can query the table dba_locks yes "Grant select any dictionary to splex user;" try accessing the table as the splex user
no e.g. the table doesn't exist, you will need to run the script in $ORACLE_HOME/rdbms/admin/catblock.sql to create the tables. After script is run check that the splex user is able to query the table. Note. this error is popped not because a replicated table doesn't exist it is because the splex user can't access an Oracle table.
Please see Solution SOL57238 for additional information
