Shell Programming and Scripting

I am running this test.ksh on server1. It successfully logins to server2 but runs the queries of query.sql on server1. query.sql is present in both server1 and server2

Can anybody please help.
I need to run queries on server2 itself.
Below is the test script

Code:

server1:oracle1:/home/oracle1>./test.ksh server2
ssh oracle1@$1 
. oraenv
 $ORACLE_HOME/bin/sqlplus -s / @/home/oracle1/shruthi/query.sql

Maybe if you explained what you are up to can we help...
Because you have 2 options:
1) You connect using ssh balhblah -c YOURSCRIPT
2) You use a heredoc
(If you dont know what it is: Here Documents )

What you submitted will connect by opening a new shell on server2, the rest will continue to be executed by the script current shell...

I am using ssh to remotely connect to a server.
All I need is to run the sql query on the remote server to which I have logged in using ssh.

---------- Post updated at 10:07 PM ---------- Previous update was at 10:04 PM ----------

I am using ssh to remotely connect to a server.
All I need is to run the sql query on the remote server to which I have logged in using ssh.

And where do you think the output will be?

What is preventing you from doing so? What have you tried?

As of now , I just need the output to be displayed on the terminal. As soon as the ssh command is interpreted, the host changes back to the local server.
I tried including

Code:

. oraenv  $ORACLE_HOME/bin/sqlplus -s / @/home/oracle1/shruthi/query.sql

...this part of the code inside single quotes...But it shows "oraenv: not found." message.

My question is all unix commands work fine if they are inserted within quotes, why not the above code??

It won't work if it's not a valid command. Try . oraenv ; command


To drop to a shell instead of quitting, try ssh -t ... 'command ; exec bash'

The -t forces it to allocate a terminal so interacting remains possible, and the 'exec bash' drops you to a shell once sql is done instead of quitting.