Oracle GoldenGate 11gの自動化

rlwrap v 0.35  January 8 2010

* WHAT IT IS: 

rlwrap is a 'readline wrapper', a small utility that uses the GNU
readline library to allow the editing of keyboard input for any
command. I couldn't find anything like it when I needed it, so I wrote
this one back in 1999.  By now, there are (and, in hindsight, even
then there were) a number of good readline wrappers around, like rlfe,
distributed as part of the GNU readline library, and cle
(http://kaolin.unice.fr/Cle/).  rlwrap should be especially useful
when you need user-defined completion (by way of completion word
lists) and persistent history, or if you want to program 'special
effects' using the filter mechanism. rlwrap compiles and runs on a 
fairly wide range of Unix-like systems.
                                                                                

...(other lines not shown)...
alias sqlplus='rlwrap sqlplus'
alias ggsci='rlwrap ./ggsci'
                                                                                

GGSCI (myhost) >  Stop mgr 
Manager process is required by other GGS processes.
Are you sure you want to stop it (y/n)? y

Sending STOP request to MANAGER ...
Request processed.
Manager stopped.

GGSCI (myhost) >  Start mgr 
Manager started.

GGSCI (myhost) >  Stop mgr !
Sending STOP request to MANAGER ...
Request processed.
Manager stopped.

GGSCI (myhost) > 
                                                                                

GGSCI (myhost) >  Delete ER west* 
Are you sure you want to delete all groups? y
Deleted EXTRACT WEST_EAB.
Deleted EXTRACT WEST_PAB.
Deleted REPLICAT WEST_RBA.

GGSCI (myhost) >  Delete ER east* ! 
Deleted EXTRACT EAST_EBA.
Deleted EXTRACT EAST_PBA.
Deleted REPLICAT EAST_RAB.

GGSCI (myhost) > 
                                                                                

ORACLE_HOME=/u01/app/oracle/product
JAVA_HOME=/usr/java/jdk1.7.0_09
export ORACLE_HOME JAVA_HOME 
OGG_SRC=$ORACLE_HOME/ogg/source
OGG_TRG=$ORACLE_HOME/ogg/target
export OGG_SRC OGG_TRG 
PATH=$JAVA_HOME/bin:$PATH
LD_LIBRARY_PATH=$ORACLE_HOME/11.2.0/dbhome_1/lib:$JAVA_HOME/jre/lib/amd
   64:$OGG_TRG:$JAVA_HOME/jre/lib/amd64/server
export PATH LD_LIBRARY_PATH
                                                                                

[OS prompt]$  ls $OGG_SRC/dirprm 
west_rba.prm   west_eab.prm   west_pab.prm

[OS prompt]$
                                                                                

--------------------------------------------------------------------------
-- DISCLAIMER:                                                          --
--    This script is provided for educational purposes only. It is NOT  --
--    supported by Oracle World Wide Technical Support.                 --
--    The script has been tested and appears to work as intended.       --
--    You should always run new scripts on a test instance initially.   --
--    Copyright (c) Oracle Corp. 2012. All Rights Reserved.             --
--------------------------------------------------------------------------

-- Useful as first thing when (re)starting ./ggsci, esp after shutdown_ogg.sh

DBLogin UserID myogguser, Password mypassword
Start mgr
Set Editor gedit
Add  CheckpointTable
Info CheckpointTable
Info All
                                                                                

#--------------------------------------------------------------------------#
#-- DISCLAIMER:                                                          --#
#--    This script is provided for educational purposes only. It is NOT  --#
#--    supported by Oracle World Wide Technical Support.                 --#
#--    The script has been tested and appears to work as intended.       --#
#--    You should always run new scripts on a test instance initially.   --#
#--    Copyright (c) Oracle Corp. 2012. All Rights Reserved.             --#
#--------------------------------------------------------------------------#

# Use to reset OGG environment to a stopped state. Run as OS user=oracle.

#kill west (source) OGG
export ORACLE_SID=sorcl
cd $OGG_SRC
./ggsci <<EOF
Start Manager
DBLogin UserID myogguser, Password mypassword
Delete Extract eini
Stop ER *
Delete ER * !
Delete CheckpointTable !
Stop Manager !
Exit
EOF

rm ./dirdat/*
rm ./dirrpt/*

#kill east (target) OGG
export ORACLE_SID=torcl
cd $OGG_TRG
./ggsci <<EOF
Start Manager
DBLogin UserID myogguser, Password mypassword
Delete Replicat rini
Stop ER *
Delete ER * !
Delete CheckpointTable !
Stop Manager !
Exit
EOF

rm ./dirdat/*
rm ./dirrpt/*
                                                                                

-- Always have a comment at the top.
-- Created by Joe Admin on 12/12/12
sh rm /u01/ogg_src/dirrpt/*
sh rm /u01/ogg_trg/dirrpt/*
sh cp /home/myuserid/targets/*.prm  /u01/ogg_src/dirprm
sh cp /home/myuserid/targets/*.def  /u01/ogg_trg/dirdef
DBLogin UserID myuserid, Password mypassword
List Tables *
                                                                                

-- Created by Joe Admin on 12/12/12
-- Connect to DB and list schema
DBLogin UserID myuserid, Password mypassword
sh sleep 5
List Tables *
-- Bounce the Manager
Stop mgr !
sh sleep 3
Start mgr
sh sleep 3
Info mgr
                                                                                

-- Created by Joe Admin and Dee Beeay on 12/12/12
sh sqlplus myuserid@sorcl/mypassword @mysourcescript.sql
sh sqlplus myuserid@sorcl/mypassword @./dirsql/mysourcescript.sql
sh sqlplus myuserid/mypassword @mytargetscript.sql 
sh sqlplus myuserid@torcl/mypassword @/mypath1/mypath2/mytargetscript.sql 
                                                                                

SQL>  set echo on  
SQL>  set echo off  
                                                                                

-- Created by Joe Admin on 12/12/12
Add Extract extwest, TranLog, Begin Now
Add ExtTrail ./dirdat/ew, Extract extwest, Megabytes 50
Add Extract pwest, ExtTrailSource ./dirdat/ew
Add RmtTrail ./dirdat/pe, Extract pwest, Megabytes 50
Shell sleep 3
Info ER *
Start ER *
Shell sleep 3
Info ER *
                                                                                

-- Created by Joe Admin on 12/12/12
Obey startup.oby
Add Extract morning, TranLog, Begin Now
Add ExtTrail ./dirdat/xy, Extract morning
Start Extract  morning
Start Replicat morning
sh sleep 300
Obey shutdown.oby
                                                                                

GGSCI (myhost) 1> test 

Usage: TEST genericTestFileName

Note: TEST is undocumented GGSCI command and is not supported.

Purpose of TEST is to provide generic cross-platform utility of testing with Go
ldenGate software.

What does TEST do for you? 
1. lets you write many files in one and then unpack them. Each file can reside 
   in different directory.
2. provides string substitution across many files in consistent way.
3. gives you centralized repository of substitution values in file 'ggtest'.

TEST may make many tests situations (not all) easier to replicate on different 
systems.
                                                                                

~~readme
  This is readme file
~~dirsql/mySQLFile.sql
  INSERT INTO myTable VALUES (3);
~~dirprm/ext99.prm
  EXTRACT ext99
  USERID ~suser~~db~, PASSWORD ~spass~
  RMTHOST ~host~, mgrport ~mgr~
  RMTTRAIL ./dirdat/b1
  TABLE ~suser~.DDL_COL;
~~dirprm/rep99.prm
  REPLICAT rep99
  USERID ~tuser~ PASSWORD ~tpass~
  MAP ~suser~.TAB* TARGET ~tuser~.*
~~test_obey.ob
  SQLPLUS ~suser~/~spass~ < ./dirsql/mySQLFile.sql
  DELFILE ./dirdat/k3
  DELETE REPLICAT rep99
  ADD REPLICAT rep99, EXTTRAIL ./dirdat/e2, NODBCHECKPOINT
                                                                                

# /etc/profile

# System wide environment and startup programs, for login setup
# Functions and aliases go in /etc/bashrc

# It's NOT a good idea to change this file unless you know what you
# are doing. It's much better to create a custom.sh shell script in
# /etc/profile.d/ to make custom changes to your environment, as this
# will prevent the need for merging in future updates.

pathmunge () {
    case ":${PATH}:" in
        *:"$1":*)
            ;;
        *)
            if [ "$2" = "after" ] ; then
                PATH=$PATH:$1
            else
                PATH=$1:$PATH
            fi
    esac
}


if [ -x /usr/bin/id ]; then
    if [ -z "$EUID" ]; then
        # ksh workaround
        EUID=`id -u`
        UID=`id -ru`
    fi
    USER="`id -un`"
    LOGNAME=$USER
    MAIL="/var/spool/mail/$USER"
fi
 (...more lines not shown for clarity...) 
                                                                                

# Created by Joe Admin on 12/12/12

cd ~/labs/Section14/Practice14-1/sqlscripts
export ORACLE_SID=sorcl
sqlplus myuserid/mypassword <<EOF
CREATE TABLE mytable (mycol1 VARCHAR2(20), mycol2 NUMBER(8,2), mycol3 CHAR(5));
SELECT COUNT(*) FROM mytable;
INSERT INTO mytable VALUES ('ABC123', 100.75, 'WEST');
COMMIT;
EXIT;
EOF
echo '**Created, truncated, seeded WEST/Source tables.'
sleep 3

cd ~/labs/Section14/Practice14-2/sqlscripts
export ORACLE_SID=torcl
sqlplus myuserid/mypassword <<EOF
@database.sql
@seed_database.sql
EOF
echo '**Created, truncated, seeded EAST/Target tables.'
sleep 3

cd ~/labs/Section14/Practice14-3/sqlscripts
export ORACLE_SID=torcl
sqlplus myuserid/mypassword @database.sql
echo '**Created, truncated, seeded NORTH/Target tables.'
sleep 3
                                                                                

#--------------------------------------------------------------------------#
#-- DISCLAIMER:                                                          --#
#--    This script is provided for educational purposes only. It is NOT  --#
#--    supported by Oracle World Wide Technical Support.                 --#
#--    The script has been tested and appears to work as intended.       --#
#--    You should always run new scripts on a test instance initially.   --#
#--    Copyright (c) Oracle Corp. 2012. All Rights Reserved.             --#
#--------------------------------------------------------------------------#

# Use this script to complete Lab 5. Run as OS user=oracle.
# WARNING! This overlays whatever you may have had in your own config files!

cd ~/labs/Section5/sqlscripts/
export ORACLE_SID=amer
sqlplus west/oracle_4U @source_database.sql
sqlplus west/oracle_4U @seed_database.sql
sqlplus / as sysdba <<EOF
GRANT dba TO gguser IDENTIFIED BY oracle_4U;
CONN gguser/oracle_4U
SHOW USER
SHOW PARAMETER NAME
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER SYSTEM SWITCH LOGFILE;
SELECT supplemental_log_data_min FROM v\$database;
exit
EOF

export ORACLE_SID=euro
sqlplus east/oracle_4U @target_database.sql
sqlplus / as sysdba <<EOF
GRANT dba TO gguser IDENTIFIED BY oracle_4U;
CONN gguser/oracle_4U
SHOW USER
SHOW PARAMETER NAME
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER SYSTEM SWITCH LOGFILE;
SELECT supplemental_log_data_min FROM v\$database;
exit
EOF
                                                                                

# Always include a comment at the top
# Created by Joe Admin on 12/12/12
# kill west (amer) OGG
export ORACLE_SID=torcl
cd $OGG_TRG_HOME
./ggsci <<EOF
Start Manager
DBLogin UserID myogguser, Password mypswd
Delete Extract myini
Stop ER *
Delete ER * !
Delete CheckpointTable !
Stop Manager !
Exit
EOF

rm ./dirdat/*
rm ./dirrpt/*
                                                                                

#--------------------------------------------------------------------------#
#-- DISCLAIMER:                                                          --#
#--    This script is provided for educational purposes only. It is NOT  --#
#--    supported by Oracle World Wide Technical Support.                 --#
#--    The script has been tested and appears to work as intended.       --#
#--    You should always run new scripts on a test instance initially.   --#
#--    Copyright (c) Oracle Corp. 2012. All Rights Reserved.             --#
#--------------------------------------------------------------------------#

# Use this script to complete Lab 13. Run as OS user=oracle.
# WARNING! This overlays whatever you may have had in your own config files!

~/labs/setup/kill-all-ogg.sh
echo '**Killed all old processes.'
sleep 3

cp ~/labs/Section13/solutions/def* $GG_AMER_HOME/dirprm
cp ~/labs/Section13/solutions/def* $GG_EURO_HOME/dirprm
cp ~/labs/Section13/solutions/efu* $GG_AMER_HOME/dirprm
cp ~/labs/Section13/solutions/ENC* $GG_AMER_HOME
cp ~/labs/Section13/solutions/ENC* $GG_EURO_HOME
cp ~/labs/Section13/solutions/mac* $GG_AMER_HOME/dirmac
cp ~/labs/Section13/solutions/mac* $GG_EURO_HOME/dirmac
cp ~/labs/Section13/solutions/pfu* $GG_AMER_HOME/dirprm
cp ~/labs/Section13/solutions/rfu* $GG_EURO_HOME/dirprm
cp ~/labs/Section13/solutions/sec* $GG_AMER_HOME/dirdef
cp ~/labs/Section13/solutions/sec* $GG_EURO_HOME/dirdef
echo '**Copied solutions to running OGG folders.'
sleep 3

cd ~/labs/Section13/sqlscripts
export ORACLE_SID=amer
sqlplus west/oracle_4U  @source_database.sql
echo '**Created, truncated, seeded WEST/amer tables.'
sleep 3

cd ~/labs/Section13/sqlscripts
export ORACLE_SID=euro
sqlplus east/oracle_4U  @target_database.sql
echo '**Created, truncated, seeded EAST/euro tables.'
sleep 3

cd $GG_AMER_HOME
export ORACLE_SID=amer
./ggsci <<EOF
Obey /home/oracle/labs/setup/startup.oby
Shell sleep 5
Add TranData WEST.*
EOF
echo '**Created WEST checkpoint tables.'
sleep 3

cd $GG_EURO_HOME
export ORACLE_SID=euro
./ggsci <<EOF
Obey /home/oracle/labs/setup/startup.oby
Shell sleep 5
EOF
echo '**Created EAST checkpoint tables.'
sleep 3

cd $GG_AMER_HOME
export ORACLE_SID=amer
./ggsci <<EOF
Obey /home/oracle/labs/setup/startup.oby
Shell sleep 5
Add Extract efuncs, TranLog, Begin Now
Add ExtTrail ./dirdat/ex, Extract efuncs, Megabytes 1
Add ExtTrail ./dirdat/ec, Extract efuncs, Megabytes 1
Add Extract pfuncs, ExtTrailsource ./dirdat/ex
Add RmtTrail ./dirdat/px, Extract pfuncs, Megabytes 1
Add Extract pfunca, ExtTrailsource ./dirdat/ec
Add RmtTrail ./dirdat/pc, Extract pfunca, Megabytes 1
Shell sleep 5
Info ER *
Exit
EOF
echo '**WEST created, but not started.'
sleep 3

cd $GG_EURO_HOME
export ORACLE_SID=euro
./ggsci <<EOF
Obey /home/oracle/labs/setup/startup.oby
Shell sleep 5
Add Replicat rfunc, ExtTrail ./dirdat/px
Add Replicat rfunca, ExtTrail ./dirdat/pc
Shell sleep 5
Info ER *
Exit
EOF
echo '**EAST created, but not started.'
sleep 3

cd $GG_AMER_HOME
export ORACLE_SID=amer
./ggsci <<EOF
Obey /home/oracle/labs/setup/startup.oby
Shell sleep 3
Start ER *
Shell sleep 12
Info ER *
Exit
EOF
echo '**WEST started.'
sleep 3

cd $GG_EURO_HOME
export ORACLE_SID=euro
./ggsci <<EOF
Obey /home/oracle/labs/setup/startup.oby
Shell sleep 3
Start ER *
Shell sleep 12
Info ER *
Exit
EOF
echo '**EAST started.'
sleep 3

cd ~/labs/Section13/sqlscripts
export ORACLE_SID=amer
sqlplus west/oracle_4U <<EOF
@trans_generator.sql
exit
EOF
echo '**Target WEST tables should now have more data. '
echo 'Run (SELECT * FROM wshop_encrypt;) to see.'