DB PROFILE/BASH_PROFILE 적용 스크립트

DB PROFILE/BASH_PROFILE 적용 스크립트

---

DB가 한 서버에 여러개가 존재할때 SID 별 DB 접근하기 편하도록 쉘스크립트 수정

export EDITOR=vi

echo "======================================="

echo "===Please Select the Instance Number==="

echo "======================================="

echo "1) TESTDB"

echo "2) STARTDB"

echo "3) ABCDB"

echo "What number do you want?"

read number

case $number in

        "1")

                export ORACLE_SID=TESTDB

                echo "Thank you for selecting TESTDB"

                ;;

        "2")

                export ORACLE_SID=STARTDB

                echo "Thank you for selecting STARTDB"

                ;;

        "3")

                export ORACLE_SID=ABCDB

                echo "Thank you for selecting ABCDB"

                ;;

        *)

                exit;;

esac