03-21-2008
code:
#!/bin/bash
sqlplus -s username/password <<EOF
@file1.ora
@file2.ora
........
........
........
end;
/
EOF
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am new to shell scripting. Can anyone tell how to invoke a batch program from my shell script
thnx (1 Reply)
Discussion started by: lakshmis10
1 Replies
2. Shell Programming and Scripting
Hi
I am trying to run a SQL statement from a unix script determined at runtime.
It is throwing me an error. Please advise some solution to this.
echo "Enter username for the database"
read username
echo "Enter password for the database"
read password
echo "Enter SQL stmt"
read... (4 Replies)
Discussion started by: infyanurag
4 Replies
3. Shell Programming and Scripting
Hi Gurus,
Want to execute a shell script from a oracle procedure and get the status of the same, any assistance in this regard will be appreciated.
proc_data.sh is script name which I want to execute from oracle procedure
It should work something like below
procedure test
begin... (1 Reply)
Discussion started by: palanisvr
1 Replies
4. Shell Programming and Scripting
Can anyone help me with a dos batch script to execute a shell script residing in an unix server. I am not able to use ssh.
Thanks in advance (2 Replies)
Discussion started by: Shri123
2 Replies
5. UNIX for Advanced & Expert Users
Hi,
I want to execute .rdf file which uses oracle report in crontab ..Can you please help me out how to schedule it crontab.as it is a rdf file
Please give any suggestions regarding the above issue. (0 Replies)
Discussion started by: soumyamishra
0 Replies
6. Shell Programming and Scripting
Hello,
I need to execute below command in shell script
srvctl relocate service -d $database -s $service -i $avail -t $pref -f and also need to get the errors ,if any,in another file.
What's the right way to execute such commands in shell script?
Best regards,
Vishal (1 Reply)
Discussion started by: Vishal_dba
1 Replies
7. Shell Programming and Scripting
Hi team,
My requirement is to transfer pdf files from windows machine to unix server and then from that unix server we should sftp to another server.
I have completed the first part i.e From windows to using to unix server with the help of psftp.exe
code:
psftp user@host -pw password <... (1 Reply)
Discussion started by: bhupeshchavan
1 Replies
8. Shell Programming and Scripting
Hi ,
I am trying to automate a gather stats in shell script
#!/usr/bin/ksh
export ORACLE_HOME=/orcl/app/oracle/product/11.2.0.1/db_1
export PATH="$PATH:$ORACLE_HOME/bin"
export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:$ORACLE_HOME/lib32"
export TNS_ADMIN=/opt/netprobe/config... (1 Reply)
Discussion started by: neil.k
1 Replies
9. Shell Programming and Scripting
Hi All,
I need to read values of 10 columns from oracle query and assign the same to 10 unix variables. The query will return only one record(row).
I tried to append all these columns using a delimiter(;) in the select query and assign the same to a single variable(V) in unix. I thought I... (3 Replies)
Discussion started by: hkrishnan91
3 Replies
10. UNIX for Beginners Questions & Answers
Hello All,
just wanted to export multiple tables from oracle sql using unix shell script to csv file and the below code is exporting only the first table.
Can you please suggest why? or any better idea?
export FILE="/abc/autom/file/geo_JOB.csv"
Export= `sqlplus -s dev01/password@dEV3... (16 Replies)
Discussion started by: Hope
16 Replies
LEARN ABOUT DEBIAN
tentacle_client
TENTACLE_CLIENT(1) Client file transfer protocol TENTACLE_CLIENT(1)
NAME
tentacle_client - a client file transfer protocol
SYNOPSIS
tentacle_client <options> Tentacle is a client/server file transfer protocol that aims to be:
- Executable programs or shell commands
- System calls (functions provided by the kernel)
- Library calls (functions within program libraries)
Tentacle was created to replace more complex tools like SCP and FTP for simple file transfer/retrieval, and switch from authentication
mechanisms like .netrc, interactive logins and SSH keys to X.509 certificates. Simple password authentication over a SSL secured connection
is supported too.
The client and server (TCP port 41121) are designed to be run from the command line or called from a shell script, and no configuration
files are needed.
Tentacle is now the default file transfer method for Pandora FMS and Babel Enterprise.
Tentacle is implemented in Perl and ANSI C (Windows platforms included).
You can download it and get more information at the official Sourceforge website http://tentacled.sourceforge.net/.
OPTIONS
Tentacle Client options :
-a address : Server address (default 127.0.0.1).
-c : Enable SSL without a client certificate.
-e cert : OpenSSL certificate file. Enables SSL.
-f ca : Verify that the peer certificate is signed by a ca.
-g : Get files from the server.
-h : Show help.
-k key : OpenSSL private key file.
-p port : Server port (default 41121).
-q : Quiet. Do now print error messages.
-r number : Number of retries for network operations (default 3).
-t time : Time-out for network operations in seconds (default 1s).
-v : Be verbose.
-w : Prompt for OpenSSL private key password.
-x pwd : Server password.
EXAMPLES
tentacle_client -a 192.168.1.1 -v /bin/bash
Simple file transfer with maximum file size set to 1MB
tentacle_client -a 192.168.1.1 -x password -v /bin/bash
Simple file transfer with password authentication (not secure)
tentacle_client -a 192.168.1.1 -x password -e cert.pem -k key.pem -v /bin/bash
Secure file transfer with client certificate and password authentication
NOTES
Tentacle requires Perl 5.8 or higher to works
SEE ALSO
tentacle_server(1), pandora_server(1), pandora_agent(1)
0.2.0 2010-05-11 TENTACLE_CLIENT(1)