#!/bin/ksh                      
#########################################
# Developer  : H.TONGUC YILMAZ 
# Created    : 22.11.2007 
#
# Purpose : CIGDEM knows :)
#           Initial Version
#
# Updated :
# Update Purpose :
#
# Run example : nohup ./clone_user.ksh target-dba-usernm target-dba-passwd source-usernm source-passwd target-usernm target-passwd date &
#
#########################################
# Local DROP USER, CREATE DIRECTORY privileged user
export CIGDEM_USERNAME1=$1
export CIGDEM_PASSWORD1=$2
# Remote source user
export CIGDEM_USERNAME2=$3
export CIGDEM_PASSWORD2=$4
# Local target user
export CIGDEM_USERNAME3=$5
export CIGDEM_PASSWORD3=$6
export CIGDEM_DATE=$7
# Other stuff needed 
export OH10=/u01/app/oracle/product/10_2
export OH9=/u01/app/oracle/product/9206.64
export OSID10=SP2D
export OSID9=QDBD
export OTNS10=SP2D
export OTNS9=QDBD
export CIGDEM_DIR=/export/home/test/cido
export CIGDEM_LOG_DIR=/export/home/test/cido/log
export CIGDEM_EXP_DIR=/export/home/test/cido/exp
export PERMANANT_TABLESPACE=TS_DATA 
export TEMPORARY_TABLESPACE=TS_TEMP
#########################################
if [ $# != 7 ]
then
echo " "
echo "Wrong argument count "
echo "Usage: nohup ./clone_user.ksh target-dba-usernm target-dba-passwd source-usernm source-passwd target-usernm target-passwd date &"
echo " "
exit 10
fi
# Lets go
cd ${CIGDEM_DIR}
retc=0

ORACLE_SID=$OSID10; export ORACLE_SID;
ORACLE_HOME=$OH10; export ORACLE_HOME;
$OH10/bin/sqlplus -s > $CIGDEM_LOG_DIR/step1_$CIGDEM_DATE.log 2> $CIGDEM_LOG_DIR/step1_$CIGDEM_DATE.err <<EOF
$CIGDEM_USERNAME1/$CIGDEM_PASSWORD1@$OTNS10
@$CIGDEM_DIR/step1.sql $CIGDEM_EXP_DIR $CIGDEM_USERNAME3 $CIGDEM_PASSWORD3 $PERMANANT_TABLESPACE $TEMPORARY_TABLESPACE 
exit ;
EOF

retc=$?
if [[ $retc = 0 ]] 
then
   echo "** User Drop OK ..."
   echo '** '` date '+%m/%d/%y %H:%M:%S'` 
   echo
else
   echo "** ERROR, User Drop return code : $retc ..."
   echo '** '` date '+%m/%d/%y %H:%M:%S'` 
   echo
   exit 20
fi

ORACLE_SID=$OSID9; export ORACLE_SID;
ORACLE_HOME=$OH9; export ORACLE_HOME;
$OH9/bin/exp $CIGDEM_USERNAME2/$CIGDEM_PASSWORD2@$OTNS9 FILE=$CIGDEM_EXP_DIR/$CIGDEM_DATE.dmp LOG=$CIGDEM_EXP_DIR/EXP_$CIGDEM_DATE.log OWNER=$CIGDEM_USERNAME2 direct=y buffer=10485760 > $CIGDEM_LOG_DIR/step2_$CIGDEM_DATE.log 2> $CIGDEM_LOG_DIR/step2_$CIGDEM_DATE.err

retc=$?
if [[ $retc = 0 ]] 
then
   echo "** Export OK ..."
   echo '** '` date '+%m/%d/%y %H:%M:%S'` 
   echo
else
   echo "** ERROR, Export return code : $retc ..."
   echo '** '` date '+%m/%d/%y %H:%M:%S'` 
   echo
   exit 30
fi

ORACLE_SID=$OSID10; export ORACLE_SID;
ORACLE_HOME=$OH10; export ORACLE_HOME;
$OH10/bin/imp $CIGDEM_USERNAME3/$CIGDEM_PASSWORD3@$OTNS10 FILE=$CIGDEM_EXP_DIR/$CIGDEM_DATE.dmp LOG=$CIGDEM_EXP_DIR/IMP_$CIGDEM_DATE.log  buffer=10485760 FROMUSER=$CIGDEM_USERNAME2 TOUSER=$CIGDEM_USERNAME3 > $CIGDEM_LOG_DIR/step3_$CIGDEM_DATE.log 2> $CIGDEM_LOG_DIR/step3_$CIGDEM_DATE.err

retc=$?
if [[ $retc = 0 ]] 
then
   echo "** Import OK ..."
   echo '** '` date '+%m/%d/%y %H:%M:%S'` 
   echo
else
   echo "** ERROR, Import return code : $retc ..."
   echo '** '` date '+%m/%d/%y %H:%M:%S'` 
   echo
   exit 40
fi

ORACLE_SID=$OSID10; export ORACLE_SID;
ORACLE_HOME=$OH10; export ORACLE_HOME;
$OH10/bin/sqlplus -s > $CIGDEM_LOG_DIR/step4_$CIGDEM_DATE.log 2> $CIGDEM_LOG_DIR/step4_$CIGDEM_DATE.err <<EOF
$CIGDEM_USERNAME3/$CIGDEM_PASSWORD3@$OTNS10
@$CIGDEM_DIR/step4.sql $CIGDEM_LOG_DIR $CIGDEM_DATE $CIGDEM_USERNAME3 
exit ;
EOF

retc=$?
if [[ $retc = 0 ]] 
then
   echo "** Revoke Script OK ..."
   echo '** '` date '+%m/%d/%y %H:%M:%S'` 
   echo
else
   echo "** ERROR, Revoke script return code : $retc ..."
   echo '** '` date '+%m/%d/%y %H:%M:%S'` 
   echo
   exit 50
fi

ORACLE_SID=$OSID10; export ORACLE_SID;
ORACLE_HOME=$OH10; export ORACLE_HOME;
$OH10/bin/sqlplus -s > $CIGDEM_LOG_DIR/step5_$CIGDEM_DATE.log 2> $CIGDEM_LOG_DIR/step5_$CIGDEM_DATE.err <<EOF
$CIGDEM_USERNAME3/$CIGDEM_PASSWORD3@$OTNS10
@$CIGDEM_LOG_DIR/step4_$CIGDEM_DATE.lst
exit ;
EOF

retc=$?
if [[ $retc = 0 ]] 
then
   echo "** Revoke OK ..."
   echo '** '` date '+%m/%d/%y %H:%M:%S'` 
   echo
   exit 0
else
   echo "** ERROR, Revoke return code : $retc ..."
   echo '** '` date '+%m/%d/%y %H:%M:%S'` 
   echo
   exit 60
fi