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

#tree/auto/users-34/e589919|grepjsvn

exportJAVA_HOME=/auto/prod/ver/jdk-1.7.0-05-64/

exportORACLE_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/jsvnlog-r$svnversion-qv--non-interactive--trust-server-cert--usernamea528692--password${a528692}|grep-v-e'\--'-e'^r'-e'Changedpaths'|awk'{print$2;}'|seds/^\\/trunk\\/gce_db\\//@/|tee-a/tmp/pb_install.sql

/auto/prod/ver/jdk-1.7.0-05-64/bin/java-jarsvncheckouttool-0.0.1.jara528692Goon@006https://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/sqlplussys/oracle@127.0.0.1:1522/O09ISZ0asSYSDBA@/tmp/pb_install.sql

/dissd0/iss/oracle/11.2.0.3/bin/sqlplusgcedba/gcedba@10.248.156.165:1521/ORCL.corp.statestr.comasSYSDBA@/tmp/pb_install.sql