Capture stopped due to "Can't open oracle log for reading - Permission denied" (4339908)

Although capture was able to process archive log, it would stop due to Cant open [oracle redo name] for reading - Permission denied

Even though the splex user looks like it already has the right permissions, it does not have all the permissions required.

oracle redo log owned by oracle: 640 oracle dba

shareplex user from id: splexadmin groups: staff, dba

Since shareplex user belongs to dba group, it should be able to read the redo log files. However, capture log recorded the following message: LogParallelismMasterThread: OlogReadRec failed: rc=1, and Capture log also indicated capture was stopped because of unix_err=13 which is permission denied.

oracle redo log resides on raw device which is owned by root.

Since shareplex versions 5.3 and older are running as root, they have no issue to read these files. However, version 6.0 and later are not running as root, so they will have the permission issue if shareplex user has not been granted the permission to access the raw device.

Grant shareplex user permission to access raw device, or change the owner of raw device from root to oracle:dba.