Connect to Oracle in Windows XP from Linux HOST

Shell Programming and Scripting
1

Hi everyone,
I have oracle 9i installed in Windows XP and i have ubuntu in VM WARE.
I would like to know how to connect to Oracle in windows xp from Linux through shel scripting......

2

Try like this,

#!/bin/sh

res=`sqlplus $user_name/$password@SID <<ENDOFSQL
     set feed off
     set head off
     set pages 0
     set verify off
     select sysdate from dual;
     exit
ENDOFSQL`
3

It still says SQL PLUS not found !
some other way ????

4

Did you installed oracle client on linux? Post the o/p of below command.

which sqlplus