#!/bin/bash
#
# oradmin - a tiny tool for lazy oracle admins, 
# written by Jens Heine on 03.07.2004 with 
# best temper.
#

#
# Variables and constants
#
SYS_USER="sys"
SYS_USER_PASSWORD="pass"
P_VERSION="0.3"

#
# Function block which implements command line options
#
show_usage() {
  echo -e "\n << `basename $0` $P_VERSION >> \n Written by Jens Heine in 2004."
  echo -e " This is just a tiny tool for lazy oracle admins ;)\n"
  echo -e " Usage: `basename $0` [options]\n"
  echo -e "   DATABASE CONTROL OPTIONS"
  echo -e "     help  = show this info"
  echo -e "     s     = startup normal"
  echo -e "     sn    = startup nomount"
  echo -e "     sm    = startup mount"
  echo -e "     si    = shutdown immediate"
  echo -e "     sa    = shutdown abort"
  echo -e "     sl    = switch logfile"
  echo -e "     csp   = create spfile from pfile"
  echo -e "     cps   = create pfile from spfile"
  echo -e "     bc    = backup controlfile to trace"
  echo -e "     cs    = create database statistics"
  echo -e "\n   DATABASE QUERY OPTIONS"
  echo -e "     qi    = query instance info"
  echo -e "     qom   = query open mode of db"
  echo -e "     qdf   = query datafiles"
  echo -e "     qlm   = query logfile members"
  echo -e "\n   STANDBY DATABASE OPTIONS"
  echo -e "     ssm   = startup nomount,"
  echo -e "             mount standby database"
  echo -e "     ssr   = startup nomount,"
  echo -e "             mount standby database,"
  echo -e "             recover managed standby database"
  echo -e "     csc   = create standby controlfile /tmp/stdby.ctl"
  echo -e "\n   DATA GUARD MANAGER OPTIONS"
  echo -e "     dgs   = show configuration verbose"
  echo -e "     dge   = enable configuration"
  echo -e "     dgd   = disable configuration"
  echo -e "     dgr   = remove configuration"
  echo -e "     dgss site = show site"
  echo -e "     dgsw site = switchover to site"
  echo -e "\n   LISTENER OPTIONS"
  echo -e "     ls    = listener start"
  echo -e "     lsh   = listener show status"
  echo -e "     lss   = listener show services"
  echo -e "     lk    = kill listener"
  echo -e "\n   CONFIGURATION OPTIONS"
  echo -e "     vi    = vim init<SID>.ora"
  echo -e "     vl    = vim listener.ora"
  echo -e "     vt    = vim tnsnames.ora"
  echo -e "\n   MISC OPTIONS"
  echo -e "     t     = tail alert log"
  echo -e "     v     = show program version"
}

show_version() {
  echo -e "\n << `basename $0` $P_VERSION >> \n Written by Jens Heine in 2004.\n"
}

startup_normal() {
  echo -e "`sqlplus "/ as sysdba" <<abc 
    startup 
abc`"
}

startup_nomount() {
  echo -e "`sqlplus "/ as sysdba" <<abc 
    startup nomount
abc`"
}

startup_mount() {
  echo -e "`sqlplus "/ as sysdba" <<abc 
    startup mount
abc`"
}

shutdown_immediate() {
  echo -e "`sqlplus "/ as sysdba" <<abc 
    shutdown immediate
abc`"
}

shutdown_abort() {
  echo -e "`sqlplus "/ as sysdba" <<abc
    shutdown abort 
abc`"
}

switch_logfile() {
  echo -e "`sqlplus "/ as sysdba" <<abc
    alter system switch logfile; 
abc`"
}

create_spfile() {
  echo -e "`sqlplus "/ as sysdba" <<abc
    create spfile from pfile;
abc`"
}

create_pfile() {
  echo -e "`sqlplus "/ as sysdba" <<abc
    create pfile from spfile;
abc`"
}

backup_controlfile_to_trace() {
  echo -e "`sqlplus "/ as sysdba" <<abc
    alter database backup controlfile to trace;
abc`"
}

start_standby_mount() {
  echo -e "`sqlplus "/ as sysdba" <<abc
    startup nomount 
    alter database mount standby database;
abc`"
}

start_standby_recover() {
  echo -e "`sqlplus "/ as sysdba" <<abc
    startup nomount 
    alter database mount standby database;
    alter database recover managed standby database disconnect;
abc`"
}

create_standby_controlfile() {
  echo -e "`sqlplus "/ as sysdba" <<abc
    alter database create standby controlfile as '/tmp/stdby.ctl';
abc`"
}

dg_show_config() {
  echo -e "`dgmgrl <<abc
    connect $SYS_USER/$SYS_USER_PASSWORD 
    show configuration verbose 
abc`"
}

dg_enable_config() {
  echo -e "`dgmgrl <<abc
    connect $SYS_USER/$SYS_USER_PASSWORD
    enable configuration
abc`"
}

dg_disable_config() {
  echo -e "`dgmgrl <<abc
    connect $SYS_USER/$SYS_USER_PASSWORD
    disable configuration
abc`"
}

dg_remove_config() {
  echo -e "`dgmgrl <<abc
    connect $SYS_USER/$SYS_USER_PASSWORD
    remove configuration
abc`"
}

dg_show_site() {
  echo -e "`dgmgrl <<abc
    connect $SYS_USER/$SYS_USER_PASSWORD
    show site verbose $1
abc`"
}

dg_switchover() {
  echo -e "`dgmgrl <<abc
    connect $SYS_USER/$SYS_USER_PASSWORD
    switchover to $1
abc`"
}

listener_start() {
  echo -e "`lsnrctl start`"
}

listener_show_status() {
  echo -e "`lsnrctl status`"
}

listener_show_services() {
  echo -e "`lsnrctl services`"
}

listener_stop() {
  echo -e "`lsnrctl stop`"
}

query_instance_info() {
  echo -e "`sqlplus "/ as sysdba" <<abc
    col INSTANCE_NAME format a20;
    col HOST_NAME format a25;
    select INSTANCE_NAME, HOST_NAME from v\\$instance; 
abc`"
}

query_open_mode() {
  echo -e "`sqlplus "/ as sysdba" <<abc
    select name,open_mode from v\\$database; 
abc`"
}

query_datafiles() {
  echo -e "`sqlplus "/ as sysdba" <<abc
    col name for a45;
    col Mbyte format 99999;
    select NAME,(BYTES/1024/1024) Mbyte from v\\$datafile; 
abc`"
}

query_log_members() {
  echo -e "`sqlplus "/ as sysdba" <<abc
    col group# format 999;
    col member format a60;
    select group#,type,MEMBER from v\\$logfile; 
abc`"
}

create_database_stats() {
  echo -e "`sqlplus "/ as sysdba" <<abc
  exec dbms_stats.gather_database_stats;
abc`"
}

vim_initora() {
  vim "$ORACLE_HOME/dbs/init$ORACLE_SID.ora"
}

vim_listenerora() {
  vim "$ORACLE_HOME/network/admin/listener.ora"
}

vim_tnsnamesora() {
  vim "$ORACLE_HOME/network/admin/tnsnames.ora"
}

tail_alert_log() {
  tail -f -n 50 $ORACLE_HOME/admin/$ORACLE_SID/bdump/alert_$ORACLE_SID.log
}

#
# Main program / check command line options
#
case $1 in
  "help")
    show_usage;
  ;;
  "-help")
    show_usage;
  ;;
  "--help")
    show_usage;
  ;;
  "?")
    show_usage;
  ;;
  "-?")
    show_usage;
  ;;
  "--?")
    show_usage;
  ;;
  "s")
    startup_normal;
  ;;
  "sn")
    startup_nomount;
  ;;
  "sm")
    startup_mount;
  ;;
  "si")
    shutdown_immediate;
  ;;
  "sa")
    shutdown_abort;
  ;;
  "sl")
    switch_logfile;
  ;;
  "csp")
    create_spfile;
  ;;
  "cps")
    create_pfile;
  ;;
  "bc")
    backup_controlfile_to_trace;
  ;;
  "cs")
    create_database_stats;
  ;;
  "ssm")
    start_standby_mount;
  ;;
  "ssr")
    start_standby_recover;
  ;;
  "csc")
    create_standby_controlfile;
  ;;
  "dgs")
    dg_show_config;
  ;;
  "dge")
    dg_enable_config;
  ;;
  "dgd")
    dg_disable_config;
  ;;
  "dgr")
    dg_remove_config;
  ;;
  "dgss")
    dg_show_site $2;
  ;;
  "dgsw")
    dg_switchover $2;
  ;;
  "ls")
    listener_start;
  ;;
  "lsh")
    listener_show_status;
  ;;
  "lss")
    listener_show_services;
  ;;
  "lk")
    listener_stop;
  ;;
  "qi")
    query_instance_info;
  ;;
  "qom")
    query_open_mode;
  ;;
  "qdf")
    query_datafiles;
  ;;
  "qlm")
    query_log_members;
  ;;
  "vi")
    vim_initora;
  ;;
  "vl")
    vim_listenerora;
  ;;
  "vt")
    vim_tnsnamesora;
  ;;
  "t")
    tail_alert_log;
  ;;
  "v")
    show_version;
  ;;
  *)
    echo "Wrong argument(s). Try \"oradmin.sh help\""
    exit 1
  ;;
esac

exit 0