Running remote shell script containing sql statements Post: 302073622

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Running SQL Scripts from Shell script - Need insight!

I've a script that fetches various values from the database as below: #! /bin/ksh $conn="user/pwd@service_name" `sqlplus -s << $conn EOF1 @xyz.sql @pqr.sql @abc.sql EOF1` The output of the script should generate txt files containing the results from queries which are further...

2. UNIX for Dummies Questions & Answers

Sh Shell Script executing remote SQL queries

Hi there folks, I am trying to execute remote sql queries on an Oracle server. I would like to save the result of the executed sql queries on a text file, and send that text file as an attachment to an email address. Could anyone give me an idea on how the above could be achieved? Any help...

3. UNIX for Dummies Questions & Answers

Running file sql from shell without capture the password

Dear All I have file a.sql, let's say the content is: _________________________________ select * from dual; exit; _________________________________ and I have shell script a.sh, the content is: _________________________________ ORACLE_SID=testing; export ORACLE_SID...

4. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

Hi- I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment... I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert...

5. Shell Programming and Scripting

Looping through a shell script with sql statements

Hello members, I'm working on the Solaris environment and the DB i'm using is Oracle 10g. Skeleton of what I'm attempting; Write a ksh script to perform the following. I have no idea how to include my sql query within a shell script and loop through the statements. Have therefore given a...

6. Shell Programming and Scripting

Running Oracle SQL from shell script

Hi, can anyone help me with this script please. I need the oracle command to go into the unix batch file. #!/bin/sh # A menu driven Shell script which has following options # for acmtoron@> # # # Exit # As per option do the job #---- while : do clear echo " A C M LOG MONITORING...

7. Shell Programming and Scripting

Running remote system shell script and c binary file from windows machine using java

Hi, I have an shell script program in a remote linux machine which will do some specific monitoring functionality. Also, have some C executables in that machine. From a windows machine, I want to run the shell script program (If possible using java). I tried with SSH for this. but, in...

8. UNIX for Dummies Questions & Answers

SQL block in a Shell Script connecting to a local and remote DB

Hi All, In a Shell scriipt with a SQL block I want to issue a query against a local DB and a remote DB on a remote server. The shell script is running locally. This is how I connect to the local server. But I want the query to reference remote table in the join. Question can I specify a...

9. OS X (Apple)

Quit a shell script thats running on a remote machine

I'm in a situation where I am executing a shell script(Bash) on another machine remotely using ssh, and for various reasons sometimes need to quit it and restart it. The shell script being run does many different things, so its hard to know what process to kill on the remote machine, and even if I...

10. Shell Programming and Scripting

Running set of commands in remote servers in shell script

Hi Wishing to all. I am very new joined in an organization as a unix system administrator. I need a help in preparing a script for a report. i have a file contains all of the linux/ubuntu servers line by line around 140 servers. vi servers.txt nh01 nh02 nh03 bh01 bh04 - - :wq

LEARN ABOUT CENTOS

hwloc-assembler-remote

HWLOC-ASSEMBLER-REMOTE(1)					       hwloc						 HWLOC-ASSEMBLER-REMOTE(1)

NAME

       hwloc-assembler-remote - Assemble multiple remote host topologies

SYNOPSIS

       hwloc-assembler-remote [options] output.xml host1 host2 ...

OPTIONS

       --ssh <ssh>
	      Use the given ssh command (and options) to connect to remote hosts.

       --lstopo-path <path>
	      Use  the	given path as the remote lstopo command when gathering remote topologies.  By default, lstopo is taken from the PATH envi-
	      ronment variable.

       --lstopo-opts <opts>
	      Pass the given lstopo options when gathering remote topologies.

       --show Display the resulting topology before exit.

       -f --force
	      Ignore failure to load a remote host topology.

DESCRIPTION

       hwloc-assembler-remote is a frontend to hwloc-assembler.  It takes care of retrieving the remote nodes' topologies before  assembling  them
       with hwloc-assembler.

EXAMPLES

       To assemble three nodes topologies:

	   $ hwloc-assembler-remote output.xml host1 host2 host3

       To assemble the topology of a multi-process MPI job defined as a machinefile:

	   $ hwloc-assembler-remote output.xml `cat machinefile | sort | uniq`

RETURN VALUE

       Upon successful execution, hwloc-assembler-remote returns 0.

       hwloc-assembler-remote will return nonzero if any kind of error occurs, such as (but not limited to) failure to parse the command line.

SEE ALSO

       hwloc(7), lstopo(1), hwloc-assembler(1)

1.7								   Apr 07, 2013 					 HWLOC-ASSEMBLER-REMOTE(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Running SQL Scripts from Shell script - Need insight!

Discussion started by: manthasirisha

2. UNIX for Dummies Questions & Answers

Sh Shell Script executing remote SQL queries

Discussion started by: Javed

3. UNIX for Dummies Questions & Answers

Running file sql from shell without capture the password

Discussion started by: Aditya Purwanto

4. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

Discussion started by: rajagavini