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
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
}
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
}
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
}