Get Oracle Home directory
Oracle on the Sun Solaris OS Scripts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
C-36
Remote Mirroring of an Oracle Database Using Data Replicator Software
STATUS=$?
done
# Get Oracle Home directory
TMP_HOME=$(rsh $PRI_HOST -l $PRI_DB_ID grep -v '\#'
$ORA_ORATAB/oratab | grep "$ORA_SID:" | head -1 | awk -F':'
'{print $2}')
STATUS=1
while (( STATUS != 0 )); do
echo "\nEnter the Oracle HOME directory
(ORACLE_HOME) on $PRI_HOST:\n [`tput sc`$TMP_HOME]`tput rc`\c"
read ORA_HOME
if [[ ! -n $ORA_HOME ]]; then
ORA_HOME=$TMP_HOME
fi
echo "Oracle HOME directory on $PRI_HOST =
${B2}$ORA_HOME${EB}"
prompt_usr
STATUS=$?
done
# Get Oracle Base directory
TMP_BASE=$(rsh $PRI_HOST -l $PRI_DB_ID grep
'inventory_loc' $ORA_ORATAB/oraInst.loc | \
awk -F'=' '{print $2}' | sed 's/\/oraInventory//')
STATUS=1
while (( STATUS != 0 )); do
echo "\nEnter the Oracle BASE directory
(ORACLE_BASE) on $PRI_HOST: [`tput sc`$TMP_BASE]`tput rc`\c"
read ORA_BASE
if [[ ! -n $ORA_BASE ]]; then
ORA_BASE=$TMP_BASE
fi
echo "Oracle BASE directory on $PRI_HOST =
${B2}$ORA_BASE${EB}"
prompt_usr
STATUS=$?
done
# Get Oracle Dump area
rcp $PWD/.primary/oracle/db_get_user_dump_dest
$PRI_HOST:$PRI_SCRIPT_DIR/. > /dev/null 2>&1
rsh $PRI_HOST chown $PRI_DB_ID $PRI_SCRIPT_DIR/
db_get_user_dump_dest
TMP_DUMP=$(rsh $PRI_HOST -l $PRI_DB_ID $PRI_SCRIPT_DIR/
db_get_user_dump_dest $ORA_SID $ORA_HOME)
STATUS=1
