05.15. Preparing Replication Servers 'OGG for Oracle' #1,2

                                                    <<< Back   Next >>>

!!! You need to execute them on each Oracle GoldenGate server !!!

OGG server #1
***************************

- ogg-srv01.oracak.ru

OGG server #1
***************************

- ogg-srv02.oracak.ru

1. Creating a directory for datapump trails
[oracle] $>
mkdir -p /ggtrail/dbrep1
rm -fr /ggtrail/dbrep1/*

2. Creating a profile with environment variables for "OGG for Oracle"
[oracle] $> vi ./.profile.oracle.gg19

export EDITOR=vi
export ORACLE_HOME=/u01/app/oracle/19.0/dbhome_1
export ORACLE_BASE=/u01/app/oracle/
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/suptools/oratop:/usr/sbin:$PATH
export NLS_LANG=AMERICAN_AMERICA.CL8ISO8859P5
export ORACLE_SID=empty
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PS1="`uname -n`@$ORACLE_SID$ "
export GG=/gg/gg19
alias gg='./ggsci'
umask 022
ulimit -S -n 65536
ulimit -H -n 65536
cd $GG

3. Installing the "Oracle Database 19c" distribution
[oracle] $>
mkdir -p /gg/gg19
. ~/.profile.oracle.gg19
-- Proceed with the installation of Oracle Database in the directory $ORACLE_HOME


4. Create a directory and unpack OGG for Oracle into it
[oracle] $>
. ~/.profile.oracle.gg19
-- Install Oracle GoldenGate into the $GG directory.


5. Add an alias for the Oracle database to the file $ORACLE_HOME/network/admin/tnsnames.ora
[oracle] $>
. ~/.profile.oracle.gg19
vi $ORACLE_HOME/network/admin/tnsnames.ora
dbrep1=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=db-ora01.oracak.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=dbrep1)))


6. 6. The schema name for GoldenGate objects is set in the GLOBALS file;
enable trail acceptance
[oracle] $>
. ~/.profile.oracle.gg19

vi $GG/GLOBALS
GGSCHEMA ggadmin
ALLOWOUTPUTDIR /ggtrail/dbrep1
-- End of parameter file

7. Create a credential store on the OGG server
./ggsci
create subdirs
ADD CREDENTIALSTORE
ALTER CREDENTIALSTORE ADD USER ggadmin@dbrep1 PASSWORD <***>ALIAS ggadmin_dbrep1
INFO CREDENTIALSTORE
dblogin useridalias ggadmin_dbrep1

-- Get the list of existing aliases
INFO CREDENTIALSTORE
Alias: ggadmin_dbrep1
Userid: ggadmin@dbrep1


8. Create a parameter file for GG Manager (OGG for Oracle)
[oracle] $>
. ~/.profile.oracle.gg19
./ggsci
edit param mgr

Port 7809
AUTORESTART ER *, RETRIES 120, WAITMINUTES 10, RESETMINUTES 1200
PURGEOLDEXTRACTS /ggtrail/dbrep1/*, USECHECKPOINTS, MINKEEPHOURS 96
-- End of parameter file

start mgr
                                                    <<< Back   Next >>>