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:

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"

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.

  • oracle_golden_gate_cleanup.txt
  • Last modified: 2020/11/06 17:08
  • by andonovj