OraMatt: YABAOracle

#!/bin/sh

# Tail the alert log from a database
 # Author Matt Dee
 # You should have the ORACLE_BASE in your env...if not I should write an if thing...

clear

# Test to make sure got SID name
 if test -z "$1"
 then
 echo "No command-line arguments."
 printf "Enter the database SID you wish to stalk>: "
 read SID
 clear
 echo "#####################################"
 echo "Here is the tail command"
 echo "#####################################"
 echo "tail -f $ORACLE_BASE/diag/rdbms/${SID}/${SID}/trace/alert_${SID}.log"
 echo "#####################################"
 tail -f $ORACLE_BASE/diag/rdbms/$SID/$SID/trace/alert_$SID.log
 else
 clear
 echo "#####################################"
 echo "Here is the tail command"
 echo "#####################################"
 echo "tail -f $ORACLE_BASE/diag/rdbms/${1}/${1}/trace/alert_${1}.log"
 echo "#####################################"
 tail -f $ORACLE_BASE/diag/rdbms/$1/$1/trace/alert_$1.log
 fi