OGG-00446 and redo logs (Golden Gate 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

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Julian Dontcheff's Database Blog

The good DBA is one who learns from his mistakes, the best DBA is one who learns from other DBA's mistakes

Martins Blog

Trying to explain complex things in simple terms

Oracle Data Warrior

Changing the world, one data model at a time. How can I help you?

Maaz Anjum's Blog

A life yet to be lived...

PeteWhoDidNotTweet

Stuff that interests me, if not you!

The Oracle Instructor

Explain, Exemplify, Empower

Frits Hoogland Weblog

IT Technology; Oracle, linux, TCP/IP and other stuff I find interesting

Oracle Spin - Flimatech Blog

Sharing Our Database Experience

Oracle Scratchpad

Just another Oracle weblog

Follow

Get every new post delivered to your Inbox.

Join 1,556 other followers

%d bloggers like this: