You don't need #!/bin/bash if you're running it with expect.
And you probably need to add spawn:
spawn ssh -o StrictHostKeyChecking=no -l pin100 slc02gnh.us.oracle.com
expect "Password: "
Maybe also need to expect another acknowledgement reply and in the end interact with it
Can't test here sorry.