Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Executing remote server sqlplus

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Executing remote server sqlplus
# 1  
Old 09-30-2011
Executing remote server sqlplus
Hello Guys

I have to compare flat file record to oracle table record count count which are on different servers

I am taking the flat file record count from the server now I am connecting to remote server first and then running sqlplus

But after connecting to remote server the sqlplus command is not executing

Code:
 
#!/usr/bin/ksh
ssh -o 'PasswordAuthentication yes' -o 'PreferredAuthentications publickey' -i /home/r141695/.ssh/id_dsa us320
result=`sqlplus -s UID/PWD#2738@Server<<EOF 
set pages 0 feed off;
set feedback off;
#select rcrd_cnt from rptg.r_sb_stg_data_fl_acq_cyc_cntl where srce_id = 1 and data_acq_cyc_cntl_id =$cntl_id and srce_fl_id = $p ;
select dummy from dual;
exit; 
EOF;`
exit
echo $?
echo $pwd

# 2  
Old 09-30-2011
Where did you set the environment for oracle after you connect with ssh?
# 3  
Old 09-30-2011
The problem is that you're assuming that all commands below ssh will be executed on the remote server. They aren't.

To run a command on a remote server you'll have to invoke it like this:
Code:
ssh user@remote 'command'

# 4  
Old 10-03-2011
Hi vbe,
Can you please let me now how to set the environment for oracle to successfully run the command
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Executing ksh script to remote server want output on same window

I'm having a brain freeze moment. I've created a ksh script in AIX that ssh's to a remote server, executes some commands, and then logs out. All of this is sent to a file. I then have the script cat the file so i can see the output. Even though the cat command is outside of the remote session part;... (5 Replies)
Discussion started by: seekryts15
5 Replies

2. UNIX for Dummies Questions & Answers

Executing a script in remote server

Hi All, I have 2 servers A and B. I need to connect to server B from server A and execute a shell script in B which will create some files and i need to copy those files back to server A. Required easiest possible for perfoming above task. (1 Reply)
Discussion started by: Girish19
1 Replies

3. Shell Programming and Scripting

Executing local script/command on remote server

I have a command that I want to run on machine B from machine A. If I run the command on machine B locally, it works fine. Here is the command: for n in `find /data1/ -name 'ini*.ext'` ; do echo cp $n "`dirname $n `/` basename $n .ext`"; done From machine A, I issue this command ... (3 Replies)
Discussion started by: dirtyd0ggy
3 Replies

4. Shell Programming and Scripting

Problem executing perl script on remote server

Hello, I am running in to a problem running a perl script on a remote server. I can run a simple script test.pl which contains just a print statment without issue by running ssh root@1.2.3.4 perl test.pl However, I have a more complex script that does not execute as expected. I think I... (3 Replies)
Discussion started by: colinireland
3 Replies

5. Shell Programming and Scripting

executing commands in remote server using ssh

I have some commands which need to be executed in remote machine. I have Linux Server from where I need to connect to Solaris server using ssh and then declare some variable over there and run some commands. I don't want to call a script which is present in Solaris server from Linux server... (7 Replies)
Discussion started by: maitree
7 Replies

6. Shell Programming and Scripting

executing sed on a remote server

Hi I am trying to edit a text file on a remote server using sed from within a cygwin shell on a windows system. $ sed -i "s/aaa/bbb/g" \\remoteHost\c$\log.info sed: can't read \remoteHostc$log.info: No such file or directory What am I missing ? Thanks. (7 Replies)
Discussion started by: vnn
7 Replies

7. UNIX for Dummies Questions & Answers

Executing ls command in remote server

Hi Guru, I have a requirement where i need to list the *.csv files in my remote server and copy a file from that server to my unix server I wrote dis code #!/bin/sh . /home/aaa/bb/GlobalHost.sh export HOST export USER export PWD ftp -n $HOST <<END_SCRIPT quote USER $USER quote... (1 Reply)
Discussion started by: pssandeep
1 Replies

8. Shell Programming and Scripting

Executing awk in a remote server using ssh

Hello Everybody, I'm facing a weird problem with the awk command. I'm trying to execute a simple awk command as follows, echo 1 2 | awk '{print $2}' This command prints the output 2. When i try to execute the same command in a remote server using ssh as follows, ssh user@host... (2 Replies)
Discussion started by: karthikv
2 Replies

9. Shell Programming and Scripting

SQLPLUS from a remote server

Hi, I am trying to connect to Oracle server (installed in HP UNIX) from some other HP UNIX server using sqlplus Can you somebody advice me method to connect to Database without user ID and password field or atleast password field from Remote Server Regards, Giri (5 Replies)
Discussion started by: chittari
5 Replies

10. Shell Programming and Scripting

executing a remote location script from local server

hi i am having two servers one is local and remote(FTP)server.from local server i have to connect to remote server and execute a shell script i want to run a shell script(remote location) from my local server i am having some knowledge on ftp but i am not getting the result .please give ... (2 Replies)
Discussion started by: srivsn
2 Replies
Login or Register to Ask a Question