db_switch func

function db_switch
{
###############################################################################
# function switches the database environments for any databases on the cluster
#
###############################################################################

#cd /var/opt/oracle/admin/scripts
#. ./env_generic

# export NEW_ORACLE_SID=ASM1+; . ~/.profile > /dev/null

echo
echo “Check database(s) in OCR”
echo —————————————
echo

gen_db_lst

#srvctl config > dblst
#echo
#echo “Databases listed in clusterware”
#cat dblst
#echo

export NEW_ORACLE_SID=FYTEST1; . ~/.profile > /dev/null

sqlplus -s “/ as sysdba” < /dev/null

sqlplus -s “/ as sysdba” < /dev/null

sqlplus -s “/ as sysdba” < /dev/null
dashboard

# end of function
}

Leave a Reply

Your email address will not be published. Required fields are marked *