unix profile set(frito)

xtenv() {cat /etc/oratabecho "SID="read reexport ORACLE_SID=$re}

alias gohome='cd $ORACLE_HOME;pwd;ls'
alias goarch='cd /oracle/ORACLONE/archive/$ORACLE_SID; pwd; ls;'
alias lsvra='sqlplus /nolog @/home/oraclone/ins.sql'
alias psdb='/home/oraclone/psdb.sh'
alias invalid='sqlplus /nolog @/home/oraclone/invalid.sql'
alias listener='/home/oraclone/xt_lsnrctl.sh status'

golog() {
echo "set line size"echo "line size="read rs
if [ "$ORACLE_SID" = "CLONE" ]
then
cd /oracle/ORACLONE/clonedb/9.2.0/admin/CLONE_fsthqzz5/bdump
tail -$rs alert_$ORACLE_SID.logls -lrt alert_$ORACLE_SID.logpwdelse
cd /oracle/ORACLONE/clonedb/9.2.0/admin/$ORACLE_SID/bdumptail -$rs alert_$ORACLE_SID.logls -lrt alert_$ORACLE_SID.logpwd
fi}

setclone() {export ORACLE_SID=CLONE}
setsd() {export ORACLE_SID=SDTC}
sqlclone() {export ORACLE_SID=CLONE lsvra}
sqlsd() {export ORACLE_SID=SDTC lsvra}