Wednesday 15 August 2012

Simple shellscript for Crontab


#!/bin/bash
export ORACLE_SID=$1
export PATH=$PATH:/usr/local/bin
export ORAENV_ASK=NO
. /usr/local/bin/oraenv

testsh() {
        $ORACLE_HOME/bin/sqlplus /nolog <
        conn / as sysdba
        alter session set nls_date_format='DD-MM-YYYY HH24:MI:SS';
        select sysdate from dual;
        exit
EOF
        return $?
}

testsh



No comments: