Sponsored Content
Top Forums Shell Programming and Scripting How to execute multiple(batch) oracle script in unix mechine Post 302177451 by thana on Friday 21st of March 2008 07:32:11 AM
Old 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

how to execute a batch script from shell script

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

Execute oracle query determined at runtime from a unix script

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

Execute a shell script from Oracle procedure

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

Dos batch script to execute unix shell script

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

How to i execute .rdf file oracle report automatically in cron tab unix

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

Need to execute Oracle relocation command in shell script

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

Batch script to execute shell script in UNIX server

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

Execute Oracle gather stats via shell script

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

Assigning multiple column's value from Oracle query to multiple variables in UNIX

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

Export Oracle multiple tables to multiple csv files using UNIX shell scripting

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
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)
All times are GMT -4. The time now is 06:41 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy