Running multiple commands with parameters in ssh

Question

I'm trying to run some commands from ssh. There are multiple variables in each remote server.

for db_serv in `olsnodes`; do
   for db_ins in `ssh $db_serv ps -ef | grep ora_pmon_ | grep -v grep | cut -d"_" -f3`; do
   SessionSayisi=`ssh $db_serv ps -ef | grep $db_ins | grep 'LOCAL=NO'|grep -vc ASM`
   echo "SessionSayisi= $SessionSayisi $db_ins"
   done
done

This works well but takes long time because the command is running ssh for each variable. I need to connect only one time for each server, then get all variable outputs, then ssh to another.

Here is what i tried but it didn't work:

 for db_serv in `olsnodes`; do
ssh $db_serv ps -ef | grep ora_pmon_ | grep -v grep | cut -d"_" -f3 << EOF
for db_ins in `ps -ef | grep ora_pmon_ | grep -v grep | cut -d"_" -f3`; do
echo "SessionSayisi= $SessionSayisi $db_ins"
done
EOF
done

I can get the name but can't get "$db_ins" variable, it just shows blank. Also it puts an "do" word at last of each EOF. — AloneInTheDark
– AloneInTheDark, Commented Mar 13, 2014 at 12:06

Josh Jolly · Accepted Answer · 2014-03-13 12:11:27Z

1

It looks like you only need to run one SSH command - if you capture the output in a variable, then you can run the rest of your commands on that variable instead of on the remote machine:

for db_serv in $(olsnodes); do
    procs=$(ssh "$db_serv" ps -ef)
    for db_ins in $(echo "$procs" | grep ora_pmon_ | grep -v grep | cut -d"_" -f3); do
        SessionSayisi=$(echo "$procs" | grep "$db_ins" | grep 'LOCAL=NO'| grep -vc ASM)
        echo "SessionSayisi= $SessionSayisi $db_ins"
    done
done

answered Mar 13, 2014 at 12:11

Josh Jolly

11.9k3 gold badges41 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

AloneInTheDark Over a year ago

That solved my problem, thank you. I'll mark it as solution after 5 minutes(site rule).

Collectives™ on Stack Overflow

Running multiple commands with parameters in ssh

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related