Failed To Open Redo Log ORA-22288

[rendyajisoko]

Dear Tech Support or anybody use this great tools Qlik Replicate on daily activity.

I've got a problem while try to run a task . both using Oracle.

here some log:

00040784: 2020-08-13T15:11:32:222402 [SOURCE_CAPTURE ]V: OCI call returned OCI_NO_DATA (BinaryReader\oradcdc_thread.c - 633) (oradcdc_redoutil.c:300)
00040784: 2020-08-13T15:11:32:222402 [SOURCE_CAPTURE ]V: Failed to fetch from thread '1' (oracdc_merger.c:1152)
00040784: 2020-08-13T15:11:32:222402 [SOURCE_CAPTURE ]V: Waiting 1 seconds before retry (oracdc_merger.c:960)
00040784: 2020-08-13T15:11:33:223483 [SOURCE_CAPTURE ]V: Get next log event from thread 1 (oradcdc_oralog.c:543)
00040784: 2020-08-13T15:11:33:230458 [SOURCE_CAPTURE ]V: Going to retrieve archived REDO log that contains scn 00000573.125eac75(5991787572341), thread 1 (oradcdc_thread.c:1047)
00040784: 2020-08-13T15:11:33:231460 [SOURCE_CAPTURE ]T: Going to execute select NVL(name, ' '), sequence#, next_change#, status from v$archived_log where first_time IS NOT NULL and resetlogs_change# = (select resetlogs_change# from v$database) and resetlogs_time = (select resetlogs_time from v$database) and dest_id in (1) and thread# = 1 and first_change# <= 5991787572341 order by sequence# desc, status (oradcdc_thread.c:1130)
00040784: 2020-08-13T15:11:33:234472 [SOURCE_CAPTURE ]V: Going to retrieve online REDO log with sequence 844, thread 1 (oradcdc_thread.c:476)
00040784: 2020-08-13T15:11:33:234472 [SOURCE_CAPTURE ]V: Use a prepared statement to access v$log, thread 1 (oradcdc_thread.c:558)
00040784: 2020-08-13T15:11:33:239471 [SOURCE_CAPTURE ]T: Going to execute statement 'select directory_name from all_directories where directory_path = '/pamastb/oradata/ellres/redo' and (directory_name = 'ATTUREP_0A21D232ELLRES_ELLTST9' or 'ATTUREP_' != substr(directory_name,1,8) )' (oradcdc_bfilectx.c:116)
00040784: 2020-08-13T15:11:33:243455 [SOURCE_CAPTURE ]T: OCI error 'ORA-22288: file or LOB operation FILEOPEN failed
Invalid argument' [1022307] (oradcdc_bfileapi.c:231)
00040784: 2020-08-13T15:11:33:243455 [SOURCE_CAPTURE ]V: Failed to open Redo log '/pamastb/oradata/ellres/redo/redo01a.dbf', retry till Redo log with this sequence could be opened successfully (oradcdc_redo.c:573)
00040784: 2020-08-13T15:11:33:243455 [SOURCE_CAPTURE ]V: OCI call returned OCI_NO_DATA (BinaryReader\oradcdc_thread.c - 633) (oradcdc_redoutil.c:300)
00040784: 2020-08-13T15:11:33:243455 [SOURCE_CAPTURE ]V: Failed to fetch from thread '1' (oracdc_merger.c:1152)
00040784: 2020-08-13T15:11:33:243455 [SOURCE_CAPTURE ]V: Waiting 1 seconds before retry (oracdc_merger.c:960)
00040784: 2020-08-13T15:11:34:244545 [SOURCE_CAPTURE ]V: Get next log event from thread 1 (oradcdc_oralog.c:543)
00040784: 2020-08-13T15:11:34:250511 [SOURCE_CAPTURE ]V: Going to retrieve archived REDO log that contains scn 00000573.125eac75(5991787572341), thread 1 (oradcdc_thread.c:1047)
00040784: 2020-08-13T15:11:34:250511 [SOURCE_CAPTURE ]T: Going to execute select NVL(name, ' '), sequence#, next_change#, status from v$archived_log where first_time IS NOT NULL and resetlogs_change# = (select resetlogs_change# from v$database) and resetlogs_time = (select resetlogs_time from v$database) and dest_id in (1) and thread# = 1 and first_change# <= 5991787572341 order by sequence# desc, status (oradcdc_thread.c:1130)
00040784: 2020-08-13T15:11:34:254512 [SOURCE_CAPTURE ]V: Going to retrieve online REDO log with sequence 844, thread 1 (oradcdc_thread.c:476)
00040784: 2020-08-13T15:11:34:254512 [SOURCE_CAPTURE ]V: Use a prepared statement to access v$log, thread 1 (oradcdc_thread.c:558)
00040784: 2020-08-13T15:11:34:258552 [SOURCE_CAPTURE ]T: Going to execute statement 'select directory_name from all_directories where directory_path = '/pamastb/oradata/ellres/redo' and (directory_name = 'ATTUREP_0A21D232ELLRES_ELLTST9' or 'ATTUREP_' != substr(directory_name,1,8) )' (oradcdc_bfilectx.c:116)
00040784: 2020-08-13T15:11:34:259533 [SOURCE_CAPTURE ]T: OCI error 'ORA-22288: file or LOB operation FILEOPEN failed
Invalid argument' [1022307] (oradcdc_bfileapi.c:231)

even when the task is running, its keep showed up.  when I tried to make some update in source database, it won't change on Target database. on Attunity GUI , apply latency keep grow.

please help 

[Steve_Nguyen]

from this error : OCI error 'ORA-22288: file or LOB operation FILEOPEN failed

we have other user having same issue and it was resolve from the DBA side :

It appears the symbolic link in the directory structure was causing the error. 

[john_wang]

Besides @Steve_Nguyen suggestion, there is another possible reason that, just like what we answered in SF case: It seems like the task could not access the online REDO logs of the Oracle source

- As a quick fix or confirmation, you could modify the Oracle source endpoint and enable the setting "Use archived redo logs only", this way the task would not attempt to read any online REDO logs and so would not hit the problem, however it also means the task will have some inherent latency, depending on how quickly the archived REDO logs are generated from the online logs.

- The proper solution is to set privileges correctly in Oracle so the task could access the online REDO logs as well. The Oracle endpoint is using the account "aruser" to access Oracle, please ensure this user has all the privileges granted in Oracle, as described in the User Guide Chapter 8 "Adding and Managing Source Endpoint", under the section "Using Oracle as a Source" .. "Required Permissions".

[rendyajisoko]

thanks for the reply,  already read same suggestion from oracle community forums

but i think this not my issue. because i'm not use symlink on my directory. 

also, i suspect my initialization parameter on my oracle instance, still finding out whats the problem. because my another oralce instance (in same server) is work like a charm. 

[rendyajisoko]

thanks john wang, 

your 1st suggestion is make my task work.. however as you said there was latency on replication to be applied on target database.

double check on your 2nd suggestion, pretty sure all required permission and privilleges are already granted on aruser creation.  

rightnow , while using your 1st suggestion, i still find what is the root cause for my issue. 

thanks again john.