ggMessage.dat error when running GGSCI

In configuring Golden Gate environments, I always use a separate operating system user.  This user tends to be named something along the lines of “ggate” or “gg”.  This makes it simple to identify the purpose of the user.  However, when installing Golden Gate under a different OS user, there are a few things that need to be taken care of to ensure that everything works as expected.  One such thing is the profile for the user.  I tend to use bash shell a good bit; this means I need to make all the environment changes for the user in the .bash_profile.  Not a big deal and simple to do.

One of the environment variables that I set in the .bash_profile is for Golden Gate Home, typically set to something like GG_HOME.  Then I place this into the path variable.  Allowing me access to the GGSCI command from anywhere as long as it is sourced.

GG_HOME=$ORACLE_BASE/ggate

PATH=$GG_HOME:$PATH:$HOME/bin

export PATH

Doing a which ggsci will show me where the GGSCI command is

ggate@<host_name>:~ >which ggsci
/u01/app/oracle/ggate/ggsci

Now that I have access to the GGSCI command from anywhere, I want to start using it and interacting with Golden Gate.

ggate@<host_name>:~ >ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.13 17435036 OGGCORE_11.2.1.0.0OGGBP_PLATFORMS_131002.1206_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Oct  3 2013 02:39:46

Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved.

 

GGSCI (<host_name>) 1>

Great, GGSCI started.  Now I’ll issue an INFO ALL command to see what is running in this environment.

GGSCI (<host_name>) 1> info all
Cannot load ICU resource bundle ‘ggMessage’, error code 2 – No such file or directory
Cannot load ICU resource bundle ‘ggMessage’, error code 2 – No such file or directory
Aborted
ggate@<host_name>:~ >

Notice, I was given an error message referencing the “ggMessage”.  What is this about?  In short, the Golden Gate command is looking for the “ggMessage.dat” file which is not in the current directory where we are started GGSCI.  This file is actually located in the Golden Gate home directory.  We can verify this by doing an ls –ltr $GG_HOME/*.dat.

ggate@<host_name>:~ >ls -ltr $GG_HOME/*.dat
-rw-r—– 1 ggate ggate 1317248 Oct  3 01:49 /u01/app/oracle/ggate/ggMessage.dat

Does this mean that we can only start the GGSCI command tool from the Golden Gate Home?  Sadly, the answer is yes.  The reason, I say this is because GGSCI is looking specifically for the ggMessage.dat file.  The workaround is to create a soft link to the ggMessage.dat from the directory where you want to run GGSCI from (don’t think you want soft links all over the server though).

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

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

Carlos Sierra's Tools and Tips

Tools and Tips for Oracle Performance and SQL Tuning

Follow

Get every new post delivered to your Inbox.

Join 1,501 other followers

%d bloggers like this: