OraMatt: YABAOracle

Use it…abuse it…don’t lose it…

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
	. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:/sbin:$HOME/bin




export PATH
  #ORACLE_SID=grid;export ORACLE_SID
  ORACLE_BASE=/u01/app ; export ORACLE_BASE
  ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/;export ORACLE_HOME
  GRID_HOME=/u01/app/oracle/grid; export GRID_HOME
  LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH
  PATH=$PATH:$ORACLE_HOME/bin; export PATH

# Oracle GRID_HOME added June 12, 2012
function grid() {
export ORACLE_HOME=/u01/app/oracle/grid
export ORACLE_SID=+ASM
export ORACLE_DB=+ASM
export PATH=$PATH:$ORACLE_HOME/bin:/sbin
echo $ORACLE_HOME
echo $ORACLE_SID
}

# Oracle ORACLE_HOME added June 12, 2012
function database() {
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export ORACLE_BASE=/u01/app
export ORACLE_SID=orcl
export ORACLE_UNQNAME=orcl
export ORACLE_DB=orcl
export CRS_HOME=/u01/app/oracle/grid
export PATH=$PATH:$ORACLE_HOME/bin:$CRS_HOME/bin
}


function sid() {        
export ORACLE_SID=$1         
export ORACLE_UNQNAME=$1
}
  
function sql() {        
export ORACLE_SID=$1         
$ORACLE_HOME/bin/sqlplus "sys/oracle@localhost:1521/${1} as sysdba"         
}
  

function alert () {        
export ORACLE_SID=$1         
tail -f $ORACLE_BASE/diag/rdbms/$1/$1/trace/alert_$1.log         
}

# Archives
# Extract about anything
extract () 
{
    if [ -f $1 ] ; then
        case $1 in
            *.tar.bz2)   tar xvjf $1        ;;
            *.tar.gz)    tar xvzf $1     ;;
            *.bz2)       bunzip2 $1       ;;
            *.rar)       unrar x $1     ;;
            *.gz)        gunzip $1     ;;
            *.tar)       tar xvf $1        ;;
            *.tbz2)      tar xvjf $1      ;;
            *.tgz)       tar xvzf $1       ;;
            *.zip)       unzip $1     ;;
            *.Z)         uncompress $1  ;;
            *.7z)        7z x $1    ;;
            *)           echo "'$1' cannot be extracted via >extract<" ;;
        esac
    else
        echo "'$1' is not a valid file"
    fi
}

encrypt_zip()
{ 

	zip -ejr $1 $2

}



## Alias Section
alias ll='ls -haltr'
alias ipconfig='ifconfig'
alias ip='ifconfig'
alias dir='ls -alth'
alias rm='rm -rvdf'
alias killit='killall -v'
alias cls='clear'
alias cl='clear'
alias rmdir='rm -rdvf'
alias kp='ps auxwww'
alias hosts='sudo vi /etc/hosts'



# History Settings
export HISTSIZE=10000
export HISTCONTROL=erasedups
export HISTCONTROL=ignoredups
shopt -s histappend

# Increase Shared Memory
sudo mount -o remount,size=8G /dev/shm

echo "#############################"
echo                            uptime                                                                  
echo "#############################"
uptime


echo "#############################"
echo                            disk use
echo "#############################"
df -h /

echo "#############################"
echo                              who is on       
echo "#############################"
w

echo "#############################"
echo				Oracle 
echo "#############################"
ps -ef | grep -v grep | grep pmon

 
export PATH LD_LIBRARY_PATH ORACLE_BASE ORACLE_HOME ORACLE_SID ORA_CRS_HOME GRID_HOME
PS1='[\u@\h][${ORACLE_SID}][\w]\$ '


vncserver :2