Oracle User Dump Area
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . The
sun_erm_setup.ksh
Script
Remote Mirroring of an Oracle Database Using Data Replicator Software
C-37
while (( STATUS != 0 )); do
echo "\nEnter the Oracle User Dump Area
(user_dump_dest) on $PRI_HOST:\n [`tput sc`$TMP_DUMP]`tput
rc`\c"
read ORA_DUMP
if [[ ! -n $ORA_DUMP ]]; then
ORA_DUMP=$TMP_DUMP
fi
echo "Oracle User Dump Area on $PRI_HOST =
${B2}$ORA_DUMP${EB}"
prompt_usr
STATUS=$?
done
elif [[ $DB_TYPE == 'db2' ]]; then
# Get DB2 Instance owner ID
TMP_ID=db2inst1
STATUS=1
while (( STATUS != 0 )); do
echo "\nEnter the DB2 Instance owner ID on
$PRI_HOST: [`tput sc`$TMP_ID]`tput rc`\c"
read PRI_DB_ID
if [[ ! -n $PRI_DB_ID ]]; then
PRI_DB_ID=$TMP_ID
fi
echo "Instance owner ID = ${B2}$PRI_DB_ID${EB}"
prompt_usr
STATUS=$?
done
STATUS=1
while (( STATUS != 0 )); do
echo "\nEnter the name of the DB2 database to
use: [`tput sc` ]`tput rc`\c"
read DB_NAME
echo "The database name = ${B2}$DB_NAME${EB}"
prompt_usr
STATUS=$?
done
fi
###############################
# REMOTE HOST INFORMATION #
###############################
echo "\n\n${B1}REMOTE HOST INFORMATION:${EB}\n"
