You have to create the .netrc file since it doesn't exist. And you can use "prompt off" inside your script:
ftp 192.168.10.4 <<EOF
The other method is not sure that it works with all ftp clients (I've tested it and it works with Suse but not with Slackware). Just replace "ftp 192.168.10.4" with "ftp ftp://oracle:Shekjg34@192.168.10.4" in the above script to see if it works.