Category Archives: functions

DDL_Common.ksh listing of functions

lst_objs_all

lst_obj_schm

lst_objs_schm_tbls

chg_profile

qry_template_function

lst_users

lst_all_users – uses the function sho_users

drp_app_users

sho_users

sho_users_locked

sho_users_prf_default

sho_quotas

sho_sessions

sho_session_02

sho_session_03

chg_quota_PIPER_D11_OWNER – This should take a parameter for owner schema and tablespace

chg_pword_PIPER_D11_STAGING

 

Change Password function

chg_pword()
{

USR=$1
PWRD=$2

##############################################
# This should replace the functions:
#     chg_pword_all_SCHEMA_T11()
#
# Change SCHEMA_C21_* schema/users passwords
# After schema creation we will run this
# function could accept parameters for schema
##############################################

echo
echo “Change passwords for user/schema ${USR} ”
echo

sqlplus -s “/ as sysdba” <<EOF
set lines 150
set pages 150

alter user ${USR} identified by ${PWRD};

alter user ${USR} account unlock;

EOF

}

GoldenGate Functions


gg_zipfile_chk()
#######################################################
# If the directory exists see if the files is there
#######################################################
{
clear
echo
echo
echo "Checking for the V46695-01.zip file"
echo
echo
echo "Checking /ora01/Oracle_SW/gg121 for zip file ......."
echo

if [ -f /ora01/Oracle_SW/gg121/V46695-01.zip ]; then
   echo "..../ora01/Oracle_SW/gg121/V46695-01.zip file found....."
else
   echo "..../ora01/Oracle_SW/gg121/V46695-01.zip file not found."
fi

echo
echo "Checking /ora01/Oracle_SW/1212111/gg121 for zip file ......."
echo

if [ -f /ora01/Oracle_SW/gg121/1212111/V46695-01.zip ]; then
   echo "..../ora01/Oracle_SW/gg121/1212111/V46695-01.zip file found....."
else
   echo "..../ora01/Oracle_SW/gg121/1212111/V46695-01.zip file not found."
fi

echo
echo "Checking for the xagpack_7b.zip file"
echo

echo
echo "Checking /ora01/Oracle_SW/xag71 for zip file ......."
echo

if [ -f /ora01/Oracle_SW/xag71/xagpack_7b.zip ]; then
echo "..../ora01/Oracle_SW/xag71/xagpack_7b.zip file found....."
else
echo "..../ora01/Oracle_SW/xag71/xagpack_7b.zip file not found."
fi

echo
}

&nbsp;

gg_unzip()
{

echo
echo "Unzip the Oracle GG binaries......."
echo

cd /ora01/Oracle_SW/gg121/1212111
unzip V46695-01.zip

}

xag_unzip()
{

####################################################
# Once the software is copied to the location
# Unzip the software
# This function assumes the XAG software has been
# copied to the correct directory on the /ora01
####################################################

cd /ora01/Oracle_SW/xag71
unzip xagpack_7b.zip

}