Scenario# we are testing new Goldengate process
Extract got Abended with following error and report says as follows
GoldenGate Abended with Error # error-00446 #
2016-07-15 09:51:49 ERROR OGG-00446 error 13 (Permission denied) opening red
o log /opt/db11g/redo_2a.log for sequence 090
Not able to establish initial position for sequence 090, rba 93273104.
2016-07-15 09:51:49 ERROR OGG-01668 PROCESS ABENDING.
we have 3 online redo log groups for all new databases # and each group have 2 members
----------------------------
/opt/db11g/oraredo01
/opt/db11g/oraredo02
permissions on directory as follows
ggsuser@(24) db11g /opt/db11g/oraredo01
$ ls -ltr
total 20
drwx------ 2 oracle oinstall 4096 Oct 29 2015 db11g
user # oracle has read, write and execute permission on directory
group # oinstall has no permissions #
Potential fix #
As we are using Classic Extract, Goldengate extract will collect the changes from online redo logs and writes to local trails. After investigating, I found root cause as follows
ggsuser is in oinstall group atleast have read access to fix this issue,
worked with SA and resolved issue by changing read access on directory #
# chmod -R 750 db11g
--Nikhil Tatineni--
--Oracle In Memory--
Extract got Abended with following error and report says as follows
GoldenGate Abended with Error # error-00446 #
2016-07-15 09:51:49 ERROR OGG-00446 error 13 (Permission denied) opening red
o log /opt/db11g/redo_2a.log for sequence 090
Not able to establish initial position for sequence 090, rba 93273104.
2016-07-15 09:51:49 ERROR OGG-01668 PROCESS ABENDING.
we have 3 online redo log groups for all new databases # and each group have 2 members
----------------------------
/opt/db11g/oraredo01
/opt/db11g/oraredo02
permissions on directory as follows
ggsuser@(24) db11g /opt/db11g/oraredo01
$ ls -ltr
total 20
drwx------ 2 oracle oinstall 4096 Oct 29 2015 db11g
user # oracle has read, write and execute permission on directory
group # oinstall has no permissions #
Potential fix #
As we are using Classic Extract, Goldengate extract will collect the changes from online redo logs and writes to local trails. After investigating, I found root cause as follows
ggsuser is in oinstall group atleast have read access to fix this issue,
worked with SA and resolved issue by changing read access on directory #
# chmod -R 750 db11g
--Nikhil Tatineni--
--Oracle In Memory--
