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:46Copyright (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
Current Oracle Certs
Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.