Linux 下使用jenkins 的bash 来执行sqlplus 允许sql

# tree /auto/users-34/e589919 | grep jsvn
export JAVA_HOME=/auto/prod/ver/jdk-1.7.0-05-64/
export ORACLE_HOME=/dissd0/iss/oracle/11.2.0.3/

echo "@PB/base/base.sql" > /tmp/pb_install.sql
#/auto/users-34/e589919/jsvn/svnkit-1.7.14/bin/jsvn log -r $svnversion -qv  --non-interactive --trust-server-cert --username a528692 --password ${a528692} | grep -v -e '\--' -e '^r' -e 'Changed paths' | awk '{print $2;}' | sed s/^\\/trunk\\/gce_db\\//@/ | tee -a /tmp/pb_install.sql
/auto/prod/ver/jdk-1.7.0-05-64/bin/java -jar svncheckouttool-0.0.1.jar a528692 Goon@006 https://jabdw3422.corp.statestr.com/svn/gold_copy_base/trunk/gce_db ${svnversion} >>/tmp/pb_install.sql
echo "quit;" >> /tmp/pb_install.sql
cat /tmp/pb_install.sql
#/dissd0/iss/oracle/11.2.0.3/bin/sqlplus sys/oracle@127.0.0.1:1522/O09ISZ0 as SYSDBA @/tmp/pb_install.sql
/dissd0/iss/oracle/11.2.0.3/bin/sqlplus gcedba/gcedba@10.248.156.165:1521/ORCL.corp.statestr.com as SYSDBA @/tmp/pb_install.sql