Unix Alias for Oracle Database

alias abort=’echo shutdown abort|sqlplus -L -s / as sysdba’

alias alertvi=’vi $ORACLE_HOME/admin/ ORACLE_SID/bdump/alert_ORACLE_SID.log’

alias nomount=’echo startup nomount quiet|sqlplus -L -s / as sysdba’

alias ora=’cd $ORACLE_HOME’

alias pmon=’ps -ef | grep [p]mon’

alias startup=’echo startup quiet|sqlplus -L -s / as sysdba’

alias sysdba=’sqlplus -L / as sysdba’

alias tns=’cd $ORACLE_HOME/network/admin’

alias alert=’tail -100 $ORACLE_LOG/alert_$ORACLE_SID.log|more’

alias blog=’tail -130 /backup/dbbackup.log’

alias bdump=’cd $ORACLE_HOME/admin/sunmoto/bdump’

alias udump=’cd $ORACLE_HOME/admin/sunmoto/udump’

Leave a Reply

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