Here is a sample GoldenGate environment file, feel free to comment about changes or additions
# This should be a .ggora12_env file # This variable could be used to identify a site export GG_SITE=01 # This could be used to identify a location export GG_LOC=CO # if there is only one DB related to this GG home, # set NEW_ORACLE_SID to avoid constant switch between a DB env and its GG env export NEW_ORACLE_SID=MRC01D011; . ~/.std_profile # otherwise, set NEW_ORACLE_SID to dummy if there are multiple replicated databases related to same GG home #export NEW_ORACLE_SID=dummy; . ~/.std_profile # uncomment next three lines if ORACLE_SID is dummy # export ORACLE_HOME=/oracle/product/11.2.0/db_1 export LD_LIBRARY_PATH=$ORACLE_HOME/lib/$JAVA_HOME/lib/amd64/server:$LD_LIBRARY_PATH export PATH=$ORACLE_HOME/bin:$PATH export GGS_HOME=/oracle/product/gg12.1 export PATH=$GGS_HOME:$PATH # For OEM12c GG monitoring export JAVA_HOME=/oracle/product/12.1.0/oem_1/agent/core/12.1.0.2.0/jdk/jre export PATH=$JAVA_HOME/bin:$PATH # export LD_LIBRARY_PATH=$JAVA_HOME/lib/amd64/server:$LD_LIBRARY_PATH ############################################# ## For GI Agent (XAG) ############################################## export XAG_HOME=/oracle/product/xag71 export PATH=$XAG_HOME/bin:$PATH PS1="\\ \${PWD} \\ \${SNAME} [\${ORACLE_SID}] [GG12_site$GG_SITE"_"$GG_LOC]-> " export PS1 alias ggsora12='. $HOME/.ggsora12_env;cd $GGS_HOME' alias xag='. $HOME/.ggsora12_env;cd $XAG_HOME' alias ggstatus='$XAG_HOME/bin/agctl status goldengate testdb01_oggapp'