Shell Programming and Scripting

#!/usr/bin/expect

if {[llength $argv] != 3} {
   puts "usage: $argv0 username password hostname"
   exit 1
}

set username [lindex $argv 0] 
set password [lindex $argv 1] 
set hostname [lindex $argv 2]

ORACLE_SID=TEST
ORACLE_HOME=/u01/oratest/db/tech_st/11.1.0
export ORACLE_SID ORACLE_HOME
LD_LIBRARY_PATH=$ORACLE_HOME/lib
PATH=$ORACLE_HOME/bin:$PATH
output=`sqlplus -s /nolog <<EOT
   set pages 0 feed off
   whenever sqlerror exit failure;
   connect xgbzprod/xgbzprod
   exec XGBZ_GL_COA_XMLTAG_PROC;
EOT
   `
cd  /u01/oratest/gebiz_processed
for fn in GEBIZ_COA_RPO000*.*; do

# EXPECT using continuing
set timeout 10
spawn $env(SHELL)
match_max 100000
send -- "sftp username@IP Address\r"
expect -exact "testing123@10.1.2.3's password:"
send -- "Password\r"
expect -exact "sftp>"
send -- "cd /<SFTP location>\r"
expect -exact "sftp>"
send -- "lcd /<Local locatoin>\r"
expect -exact "sftp>"
send -- "bin\r"
send -- "put $fn\r"
expect -exact "sftp>"
send -- "quit\r"
send -- "exit\r"
expect eof

#!/bin/bash

TMPEXPECT=expectscript.$$

cat <<EOT > $TMPEXPECT
#!/usr/bin/expect

if {[llength \$argv] != 3} {
   puts "usage: \$argv0 username password host"
   exit 1
}

#log_file -a expectscript.log
#log_user 0

set username  [lindex \$argv 0] 
set password  [lindex \$argv 1] 
set host      [lindex \$argv 2]

set timeout 60 

spawn /usr/bin/ssh \$username@\$host

expect {
    "assword: " {
        send "\$password\n"
        expect { 
            "expecting." { }
            "try again." { exit 1 }
            timeout      { exit 1 }
        } 
    }
    "(yes/no)? " { 
        send "yes\n" 
        expect {
            "assword: " {
                send "\$password\n"
                expect { 
                    "expecting." { }
                    "try again." { exit 1 }
                    timeout      { exit 1 }
                } 
            }
        }
    }
}

exit 0 
EOT

chmod 755 $TMPEXPECT
./$TMPEXPECT <username> <password> <hostname>