-
Title
SharePlex child processes stopped due to ORA-00376 or "ORA-01110: file cannot be read at this time. -
Description
Capture and Read on the Source and Post on Target stopped. SharePlex logs the following in event_log:
"ORA-01110: data file 39: '/ f'. [sp_ocap(osp)/<[pid]
Error: Unexpected Oracle error: ORA-00376: file 39 cannot be read at this time.ORA-01110: data file:
to Error: Unexpected Oracle error: ORA-00376: file 39 cannot be read at this time.ORA-01110: data file: ' / '" -
Cause
If some of the files in a tablespace have been offlined, some operations are never guaranteed to complete successfully. One of these is space allocation operation to a table. The algorithm to allocate space to a table looks for the extent (best fit chunk).
-
Resolution
WORKAROUND
1. Bring the data files online.
or
2. Use a locally managed tablespace instead of a dictionary managed tablespace.
3. Restart capture, read and post to resume. If Capture is behind Oracle's redolog, contact SharePlex Technical Support for assistance and advice on the best plan of action.