#!/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:
Post a Comment