Question: I love your
Oracle Press book "Oracle UNIX Administration Handbook", and I
was wondering what common Linux aliases I should set in my .profile file?
I want to automate the more complex Linux commands
What options are
available to perform custom data mining with Oracle 10g.
Answer: I use Linux
aliases heavily, especially for multi-line commands like examining messages in
the alert log. Here is one set of alias commands that you can put in your
Linux logon profile (.profile, .bshrc, .kshrc, .cshrc):
#*******************************
# Linix / UNIX aliases for Oracle DBAs
#*******************************
alias alert='tail -100 \
$DBA/$ORACLE_SID/bdump/alert_$ORACLE_SID.log|more'
alias errors='tail -100 \
$DBA/$ORACLE_SID/bdump/alert_$ORACLE_SID.log|more'
alias arch='cd $DBA/$ORACLE_SID/arch'
alias bdump='cd $DBA/$ORACLE_SID/bdump'
alias cdump='cd $DBA/$ORACLE_SID/cdump'
alias pfile='cd $DBA/$ORACLE_SID/pfile'
alias rm='rm -i'
alias sid='env|grep ORACLE_SID'
alias admin='cd $DBA/admin'