Capture: 16115 OCIStmtFetch failed with ORA 1403 (4302496)

Capture errors out and the event log shows the following error entries:

Error    2015-07-14 10:37:42.544770 10040 1 Capture: 16115 - OCIStmtFetch failed with ORA-1403.  (capturing from SID1) [module osp]

TROUBLESHOOTING:

Set the following debug on source sp_ctrl:

sp_ctrl> set param SP_OSP_DEBUG 0xffffffff

sp_ctrl> start capture

Once it errors out again, unset the debug as below:

sp_ctrl> reset param SP_OSP_DEBUG

 Then collect the trace_log (located in /vardir/log directory)

In our example, the trace_log shows that the following schema named SCHEMA1 does not exist:

Info     2015-07-14 10:37:42.544459 10040 1 Debug: olib_GetSchemaUID: owner - SCHEMA1 (capturing from Q03) [module osp]

Error    2015-07-14 10:37:42.544770 10040 1 Capture: 16115 - OCIStmtFetch failed with ORA-1403.  (capturing from Q03) [module osp]

RESOLUTION:

1.  Check the active config file to see if that user SCHEMA1 exists in it

2.  If it does, check the database to see if it exists in the database. Use the following queries to check it:

Spool sysuser.out

select user#, name from sys.user$;

spool off

spool dbauser.out

select userid, user_name from dba_users; spool off

1. If the user exists in the config file but not in the database, remove the entry (or entries) from the config file by making a copy of the config file, commenting out the entry (or entries) for that user named SCHEMA1, and then activate the copy. This will remove the user from the config file and the Capture will not show ORA-01403 anymore.