oracle_golden_gate_cleanup [My wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
=====Overview=====
To cleanup the environment, you have to manually stop/unregister all the exctract and delete them.
Also, don't forget the trail files as they might be confused.

Furtunetely, there is a quick script for that:


<Code:bash|Cleanup Script>
#!/bin/bash
#----------------------------------------------------------------------
# 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.
#
#----------------------------------------------------------------------
# SHELL clean-up.sh
#       Executes the steps necessary to clean up the environment after lab 8
cd /u03/ogg/ogg_src
./ggsci <<EOF
dblogin useridalias ogg_admin 
stop er * !
sh sleep 2
delete er * !
sh sleep 2
delete trandata ogg1.simulapp.*
sh sleep 2
unregister extract ezdta database
sh sleep 2
exit
EOF
cd /u03/ogg/ogg_trg
./ggsci <<EOF
dblogin useridalias ogg_dwnadm 
stop er * !
sh sleep 2
delete er * !
sh sleep 2
delete trandata oggdwn1.simulapp.*
sh sleep 2
UNREGISTER EXTRACT EFBM DATABASE
sh sleep 2
exit
EOF

export ORACLE_SID="CDB12c"
sqlplus sys/oracle as sysdba   <<ENDOFSQL
set echo on
set feedb on
alter session set container = ogg1;
drop user simulapp cascade;
exit
ENDOFSQL
sleep 5
export ORACLE_SID="DWNSTR"
sqlplus sys/oracle as sysdba   <<ENDOFSQL2
set echo on
set feedb on
alter session set container = oggdwn1;
drop user simulapp cascade;
exit
ENDOFSQL2
sleep 5
export ORACLE_SID=""
rm -f /u03/ogg/ogg_src/dirdat/*
rm -f /u03/ogg/ogg_trg/dirdat/*
rm -f /u03/ogg/ogg_src/dirprm/ezdta.prm
rm -f /u03/ogg/ogg_src/dirprm/pzdta.prm
rm -f /u03/ogg/ogg_src/dirprm/rfbm.prm 
rm -f /u03/ogg/ogg_trg/dirprm/efbm.prm
rm -f /u03/ogg/ogg_trg/dirprm/pfbm.prm
rm -f /u03/ogg/ogg_trg/dirprm/rzdta.prm
cd ~
rm -rf dpump

cd /home/oracle/labs/Practice08/configs
echo "Clean-up script completed"
</Code>

Please replace my variables with your variables. The script is in-progress after all.
Will add the feature to automatically detect the directories and the SIDs on later stage.