OGG-00446 and redo logs (GoldenGate Issue)

Ever since I have been working with Golden Gate, I have always installed and configured Oracle Golden Gate under a separate OS users.  In most installations, I use a user named “ggate” (makes it easier to identify).  As I’ve been setting up a new environment to do some testing, I ran into this error when trying to start my extract:

2013-10-14 10:48:21  ERROR   OGG-00446  Oracle GoldenGate Capture for Oracle, e_###.prm:  error 13 (Permission denied) opening redo log /oracle/app/oradata/bc11g/redo01.log for sequence 76Not able to establish initial position for begin time 2013-10-14 10:11:38.
2013-10-14 10:48:21  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, e_###.prm:  PROCESS ABENDING.

When I found this error in the ggserr.log, I was trying to figure out what was causing the issue. At first I thought it was permissions on the redo log files.  Then I started to think about this.  I’ve never had this problem before.  Then it dawned on me.  In having a separate user to run the Golden Gate binaries, is the user in the correct group? 

In this train of thought, I took a look at the groups associated with the Oracle and GGate users (below).  I found that the GGate user needed to be added to the same group as Oracle. 

Groups before:

[oracle@oel bc11g]$ id ggate
uid=504(ggate) gid=504(ggate) groups=504(ggate)
[oracle@oel bc11g]$ id ggate
uid=504(ggate) gid=500(oracle) groups=500(oracle),501(oinstall),504(ggate)

Revised groups settings:

[oracle@oel bc11g]$ id ggate
uid=504(ggate) gid=504(ggate) groups=504(ggate),500(oracle),501(oinstall)
[oracle@oel bc11g]$ id ggate
uid=504(ggate) gid=500(oracle) groups=500(oracle),501(oinstall),504(ggate)

Now that the groups are correct, I thought this would have corrected the problem with the extract.  It didn’t!  So what was the hang up?  Once the group settings were corrected, the issue rested with the manager process.  Once the manager process was restarted, the extract came up with no issues.

2013-10-14 11:47:13  INFO    OGG-01515  Positioning to begin time Oct 14, 2013 11:46:54 AM.

2013-10-14 11:47:13  INFO    OGG-01516  Positioned to Sequence 76, RBA 7356432, SCN 0.0, Oct 14, 2013 11:46:54 AM.

2013-10-14 11:47:13  INFO    OGG-01052  No recovery is required for target file ./dirdat/lt000000, at RBA 0 (file not opened).

2013-10-14 11:47:13  INFO    OGG-01478  Output file ./dirdat/lt is using format RELEASE 11.2.

***********************************************************************
**                     Run Time Messages                             **
***********************************************************************

2013-10-14 11:47:13  INFO    OGG-01517  Position of first record processed Sequence 76, RBA 7356432, SCN 0.2266673, Oct 14, 2013
11:47:13 AM.

I hope this helps anyone else that runs into this issue.

Enjoy!

twitter: @dbasolved

blog: http//dbasolved.com

Please follow and like: