|
#!/bin/ksh
|
|
alias ck=’cd $HOME/work/ck’
|
|
export DBTOP=$HOME/work/ck
|
|
. $HOME/.ORACLE_BASE
|
|
|
|
alias bkups=’cd $ADMIN/exp/bkups’
|
|
alias DBS=’cd $ORACLE_HOME/dbs’
|
|
alias log=’cd $ORACLE_BASE/admin/$ORACLE_SID/log;clear;pwd;ls’
|
|
alias phone=’head -1 $HOME/.phone; cat $HOME/.phone |grep -i ‘
|
|
export PFILE=$ORACLE_BASE/admin/${ORACLE_SID}/pfile
|
|
export SH=$ORACLE_BASE/general/sh
|
|
export SQL=$ORACLE_BASE/general/sql
|
|
export ISQL=$ORACLE_BASE/admin/www/isql
|
|
|
|
alias adhoc=’cd $ORACLE_BASE/admin/$ORACLE_SID/adhoc; clear; pwd; ls’
|
|
alias admin=’cd $ORACLE_BASE/admin/$ORACLE_SID; clear; pwd; ls’
|
|
alias adump=’cd $ORACLE_BASE/admin/$ORACLE_SID/adump; clear; pwd; ls’
|
|
alias ALERT=’view $ORACLE_BASE/admin/$ORACLE_SID/bdump/alert_$ORACLE_SID.log’
|
|
alias arch=’cd $ORACLE_BASE/admin/$ORACLE_SID/arch; clear; pwd; ls’
|
|
alias ARCH_DIR=’cd $ORACLE_BASE/admin/$ORACLE_SID/arch’
|
|
alias bdump=’cd $ORACLE_BASE/admin/$ORACLE_SID/bdump; clear; pwd; ls’
|
|
alias bksp=’stty erase ^?’
|
|
alias bs=’stty erase ^H’
|
|
alias cddt=’cd `date +%m%d%y`’
|
|
alias cdump=’cd $ORACLE_BASE/$ORACLE_SID/admin/cdump; clear; pwd; ls’
|
|
alias ckcp=’$ORACLE_BASE/general/sh/check_ps.ksh CPMGR’
|
|
alias ckfsv=’$ORACLE_BASE/general/sh/check_ps.ksh f60srvm’
|
|
alias ckipc=’/etc/sysdef | tail -24′
|
|
alias ckora=’$ORACLE_BASE/general/sh/check_ps.ksh ora_ | sort’
|
|
alias ckps=’$ORACLE_BASE/general/sh/check_ps.ksh’
|
|
alias ckrsv=’$ORACLE_BASE/general/sh/check_ps.ksh rwmts60′
|
|
alias ckrunf=’$ORACLE_BASE/general/sh/check_ps.ksh f60webmx | grep -v f60srv | sort’
|
|
alias cksmon=’$ORACLE_BASE/general/sh/check_ps.ksh smon | sort +8′
|
|
alias cksys=’/usr/platform/`uname -i`/sbin/prtdiag -v’
|
|
alias cktns=’$ORACLE_BASE/general/sh/check_ps.ksh tnslsnr’
|
|
alias ckuser=’$ORACLE_BASE/general/sh/user_info.ksh’
|
|
alias CONFIG=’vi $ORACLE_BASE/admin/$ORACLE_SID/pfile/config${ORACLE_SID}.ora’
|
|
if [ "$OS" = "HP-UX" ]; then
|
|
alias cpu=’sar -M 1 1′
|
|
elif [ "$OS" = "Solaris" ]; then
|
|
alias cpu=’uname -X | grep CPU’
|
|
elif [ "$OS" = "AIX" ]; then
|
|
alias cpu=’prtconf |egrep -i “Processor|cpu”‘
|
|
fi
|
|
alias create=’cd $ORACLE_BASE/admin/$ORACLE_SID/create; clear; pwd; ls’
|
|
alias dbtop=’cd $ORACLE_BASE/general’
|
|
alias dbtoplog=’cd $ORACLE_BASE/general/log;clear;pwd;env|grep ORACLE_SID=|grep -v ORACLE_SID_;ls’
|
|
alias dbtopsh=’cd $ORACLE_BASE/general/sh;clear;pwd;env|grep ORACLE_SID=|grep -v ORACLE_SID_;ls’
|
|
alias dbtopsql=’cd $ORACLE_BASE/general/sql;clear;pwd;env|grep ORACLE_SID=|grep -v ORACLE_SID_;ls’
|
|
alias gerp=’/bin/grep’
|
|
alias gzcat=’gunzip <’
|
|
alias INIT=’vi $ORACLE_HOME/dbs/init${ORACLE_SID}.ora’
|
|
alias l=’ls -lstr’
|
|
alias land=’lp -d cc1-3pub6 -y landscape’
|
|
alias lastfile=’vi $(ls -ltr |tail -1 |awk {“print \$9″})’
|
|
alias LISTENER=’vi $ORACLE_HOME/network/admin/listener.ora’
|
|
alias ll=’ls -ltra’
|
|
alias mddt=’mkdir `date +%m%d%y`’
|
|
alias mem=’prtconf | grep Memory’
|
|
alias page=’prtconf | egrep -i “Total Paging|Percent Used”‘
|
|
alias obase=’cd $ORACLE_BASE; clear; pwd; ls’
|
|
alias ohome=’cd $ORACLE_HOME’
|
|
alias on=’cd $ORACLE_HOME/network/admin’
|
|
alias ora=’env | grep ORA|sort’
|
|
alias oraexp=’cd $ORACLE_BASE/admin/$ORACLE_SID/exp; clear; pwd; ls’
|
|
alias ORATAB=’vi /etc/oracle/oratab’
|
|
alias pfile=’cd $ORACLE_BASE/admin/$ORACLE_SID/pfile; clear; pwd; ls’
|
|
alias psora=’ps -ef |grep -i lgwr |grep -v grep| awk -F_ {“print \$3″} |sort’
|
|
alias scripts=’cd $ORACLE_BASE/general/sh’
|
|
alias sid=’echo $ORACLE_SID’
|
|
alias sql=’cd $ORACLE_BASE/general/sql’
|
|
alias sqlp=’sqlplus “/ as sysdba”‘
|
|
alias svrmgrl=’sqlplus -prelim “/ as sysdba”‘
|
|
alias TAILALERT=’tail -f $ORACLE_BASE/admin/$ORACLE_SID/bdump/alert_$ORACLE_SID.log’
|
|
alias TNSNAMES=’vi $ORACLE_HOME/network/admin/tnsnames.ora’
|
|
alias udump=’cd $ORACLE_BASE/admin/$ORACLE_SID/udump; clear; pwd; ls’
|
|
#alias apache=’cd $ORACLE_HOME/Apache/Apache’
|
|
alias apache=’cd /usr/local/Zend/apache2′
|
|
alias www=’cd $ORACLE_BASE/admin/www’
|
|
alias servers=’cat $SH/servers.list |grep -v \#| sort |awk -F”:” {“print \$1, \$3, \$4, \$5″}’
|
|
alias display=’echo “Enter last digits of display”;read a; export DISPLAY=10.131.224.$a:0.0; export DISPLAY’
|
|
alias dfk=’df -k |sort |more’
|
|
|
|
#—————————-
|
|
# Syncronization of Servers
|
|
#—————————-
|
|
alias push=’$SH/ssh_push’
|
|
alias push_all=’$SH/ssh_push_to_all_designated_servers.ksh’
|
|
alias pull=’$SH/scp_pull’
|
|
|
|
#—————————-
|
|
# SQL Queries
|
|
#—————————-
|
|
alias rodba+=’[ -f $SH/.rodba.pw ] && sqlplus rodba/$(cat $SH/.rodba.pw)’
|
|
alias rodba=’$SH/rodba.ksh’
|
|
alias vlsuser=’$SH/vlsuser.ksh’
|
|
alias rodba++=’[ -f $SH/.rodba.pw ] && sqlplus rodba/$(cat $SH/.rodba.pw)@DBATOOLS’
|
|
export TMPDIR=/tmp/dba
|
|
export RODBA_PW=$([ -f $SH/.rodba.pw ] && cat $SH/.rodba.pw)
|
|
|
|
alias backup_status=’cat $SQL/backup_status.sql $SQL/exit.sql > $TMPDIR/backup_status.sql; sqlplus -s rodba/${RODBA_PW}@dbatools @$TMPDIR/backup_status.sql’
|
|
alias backup_status3=’cat $SQL/backup_status_3days.sql $SQL/exit.sql > $TMPDIR/backup_status_3days.sql; sqlplus -s rodba/${RODBA_PW}@dbatools @$TMPDIR/backup_status_3days.sql’
|
|
alias backup_status7=’cat $SQL/backup_status_7days.sql $SQL/exit.sql > $TMPDIR/backup_status_7days.sql; sqlplus -s rodba/${RODBA_PW}@dbatools @$TMPDIR/backup_status_7days.sql’
|
|
alias vmstats=’cat $SQL/vmstat.sql $SQL/exit.sql > $TMPDIR/vmstat.sql; sqlplus -s rodba/${RODBA_PW}@dbatools @$TMPDIR/vmstat.sql’
|
|
|
|
#———————————-
|
|
# Change Aliases on a weekly basis
|
|
#———————————-
|
|
alias editalias=’sudo vi /etc/aliases; sudo /usr/sbin/newaliases’
|
|
alias editaliases=’sudo vi /etc/aliases; sudo /usr/sbin/newaliases’
|
|
|
|
#—————————-
|
|
# CVS
|
|
#—————————-
|
|
alias cvsprod=’. $SH/CVS.profile prod’
|
|
alias cvsstg=’. $SH/CVS.profile stg’
|
|
alias cvsadd=’echo “Enter File to Add to CVS Repository”; read FILE; cvs add $FILE; cvs ci -m “Initial load of file into the cvs repository” $FILE’
|
|
alias cvsci=’echo “Enter File to Check-In to CVS Repository”; read FILE; cvs ci $FILE’
|
|
|
|
#—————————-
|
|
# X Windows
|
|
#—————————-
|
|
alias xwin=’echo “Enter Hostname:”; read HOST; ssh $HOST “/usr/openwin/bin/xterm -display $DISPLAY -bg blue -sb -fg white -sl 10000 -geometry 120×26 -fn 6×13 -title $HOST &”‘
|
|
alias X=’$SH/wterm.sh’
|
|
|
|
#—————————-
|
|
# OEM
|
|
#—————————-
|
|
alias omsstop=’oemctl stop oms sysman/oracle123′
|
|
alias omsstart=’oemctl start oms’
|
|
|
|
#—————————-
|
|
# Apache
|
|
#—————————-
|
|
alias apachestop=’. oracle_setup.ksh RMANPROD; cd $ORACLE_HOME/Apache/Apache/bin; ./apachectl stop’
|
|
alias apachestart=’. oracle_setup.ksh RMANPROD; cd $ORACLE_HOME/Apache/Apache/bin; ./apachectl start’
|
|
alias apacherestart=’. oracle_setup.ksh RMANPROD; cd $ORACLE_HOME/Apache/Apache/bin; ./apachectl restart’
|
|
|
|
#—————————-
|
|
# PERFSTAT
|
|
#—————————-
|
|
alias sqlperf=’[ -f $SH/.perfstat.pw ] && sqlplus perfstat/$(cat $SH/.perfstat.pw)’
|
|
|
|
#—————————-
|
|
# RMAN
|
|
#—————————-
|
|
alias rman+=’[ -f $SH/.rman.pw ] && rman target / catalog rman/$(cat $SH/.rman.pw)@RMANPROD’
|
|
alias rmandev+=’rman target / catalog rman/rman@RMANDEV’
|
|
alias sqlrman=’[ -f $SH/.rman.pw ] && sqlplus rman/$(cat $SH/.rman.pw)@RMANPROD’
|
|
alias sqlrmandev=’sqlplus rman/rman@RMANDEV’
|
|
alias rman_crosscheck_archivelogs=’[ -f $SH/.rman.pw ] && print “change archivelog all crosscheck;” |rman target / catalog rman/$(cat $SH/.rman.pw)@RMANPROD’
|
|
|
|
alias appp=’cd $ORACLE_BASE/admin/www/appportal’
|
|
alias tail_edm_logs=’tail -f /usr/epoch/EB/log/backups.log’
|
|
alias view_edm_logs=’view /usr/epoch/EB/log/backups.log’
|
|
|
|
alias XDK=’export ORACLE_SID=DBA920; export ORAENV_ASK=NO; . oraenv; cd $ORACLE_HOME/xdk/demo/java/xsql/dba’
|
|
alias RDA=’cd $ORACLE_BASE/admin/www/RDA’
|
|
alias CGI=’export ORACLE_SID=DBA920; export ORAENV_ASK=NO; . oraenv; cd $ORACLE_HOME/Apache/Apache/cgi-bin’
|
|
|
|
#—————————-
|
|
# Make Man Pages
|
|
#—————————-
|
|
alias makeman=’$SH/makeman.ksh’
|
|
alias kill_remote_x=’$SH/kill_remote_x.ksh’
|
|
export CK=$HOME/work/ck
|
|
|
|
#—————————-
|
|
# dba_ shell script aliases
|
|
#—————————-
|
|
alias dbamenu=’cd $SH; $SH/menu’
|
|
alias dba_session=’$SH/dba_session’
|
|
alias dba_efs=’$SH/dba_efs’
|
|
alias dba_sqltrace=’$SH/dba_sqltrace’
|
|
alias dba_sqltrace_user=’$SH/dba_sqltrace_user’
|
|
alias dba_histograms=’$SH/dba_histograms’
|
|
alias dba_init=’$SH/dba_init’
|
|
alias dba_sga=’$SH/dba_sga’
|
|
alias dba_user_memory=’$SH/dba_user_memory’
|
|
alias dba_last_analyzed=’$SH/dba_last_analyzed’
|
|
alias dba_object=’$SH/dba_object’
|
|
alias dba_object_id=’$SH/dba_object_id’
|
|
alias dba_analyze_table=’$SH/dba_analyze_table’
|
|
alias dba_analyze_schema=’$SH/dba_analyze_schema’
|
|
alias dba_long_sql=’$SH/dba_long_sql’
|
|
alias unix_ps_oracle=’$SH/unix_ps_oracle’
|
|
alias unix_oramem=’$SH/oramem.ksh’
|
|
alias unix_check_backup=’$SH/unix_check_backup’
|
|
alias unix_defunct=’$SH/unix_defunct’
|
|
|
|
alias topmem=’ps -e -o pid,vsz,args | sort -nr -k2,2 | head -20′
|
|
alias topcpu=’ps -e -o pcpu,pid,user,comm |sort -r -k 1 |head -20′
|
|
|
|
alias tel=’cd $SH; $SH/tel’
|
|
alias listdev=’/usr/sbin/lsdev -Cc disk’
|
|
|
|
alias ASM1=’. $SH/setup_oracle_asm.ksh +ASM1′
|
|
alias ASM2=’. $SH/setup_oracle_asm.ksh +ASM2′
|
|
alias ASM3=’. $SH/setup_oracle_asm.ksh +ASM3′
|
|
alias ASM4=’. $SH/setup_oracle_asm.ksh +ASM4′
|
|
alias asm1=’. $SH/setup_oracle_asm.ksh +ASM1′
|
|
alias asm2=’. $SH/setup_oracle_asm.ksh +ASM2′
|
|
alias asm3=’. $SH/setup_oracle_asm.ksh +ASM3′
|
|
alias asm4=’. $SH/setup_oracle_asm.ksh +ASM4′
|
|
|
|
|
|
alias lsdir=’ls -l |grep ^d’
|
|
alias topswap=”lsps -s; lsps -s |grep % |awk {‘print \$2′}”
|
