Shell Script And SQLPLUS Post: 302133716

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

passing parameters from a shell script to sqlplus

Hi , I want to pass parameters from a shell script to a sql script and use the parameter in the sql query ..and then I want to spool a particular select query on to my unix box... for 4 different locations by writing only one sql script Right now no file is generated on the unix box...it is a...

2. Shell Programming and Scripting

running shell script from sqlplus

I have a script which connects to different database servers using sqlplus. Is there a way by which I can run a shell command on that host from sqlplus? I know about 'host' command but it runs script on the local machine where the original script is running. Is there a way to run command on the...

3. Shell Programming and Scripting

help me in sending parameters from sqlplus script to unix shell script

Can anybody help me out in sending parameters from sql*plus script to unix shell script without using flat files.. Initially in a shell script i will call sql*plus and after getting some value from some tables, i want that variable value in unix shell script. How can i do this? Please tell me...

4. Shell Programming and Scripting

Call sqlplus in the shell script

Hi, I am writing a script to test database connection. If the first try fails, it will wait for 1 minutes and then try again. The script is as following: ........ for i in $ORACLE_SID do $ORACLE_HOME/bin/sqlplus $username/$password@$i <<! >/dev/null select * from tab; exit if ; then...

5. Shell Programming and Scripting

(Urgent):Creating flat file using sql script and sqlplus from UNIX Shell Script

Hi, I need help urgently for following issue. Pls help me to resolve this issue. I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql) I given...

6. Shell Programming and Scripting

SQLPLUS within shell script

Hi I want to connect to the Oracle database using a username/password and get back the query result(a numeric value) in a variable, which I can then compare using a conditional. Can anybody help me with this. Thanks Gaurav

7. Shell Programming and Scripting

Want to learn/use SQLPLUS in shell script

Hi All, How i will use sqlplus in shell script? Can any one provide sample code which explain following: 1. Connect to oracle DB 2. Exceute select * from tablename 3. Release connection to the DB 4. Append output in file everytime when query executes. Thanks in advance

8. Shell Programming and Scripting

SQLplus and Shell script problem

sql_rows=`sqlplus -s / <<EOF set heading off set pagesize 1000 set tab off set linesize 120 wrap off column "Path" format a15 --column "No_Of_files" format a10 select tablespace_name, substr(file_name,1,instr(file_name,'/',1,2)) as "Path" , count(*) as "No_Of_files" from dba_data_files ...

9. Shell Programming and Scripting

sqlplus in shell script

Hi When I use sqlplus in shell script, I get sqlplus: command not found. ORACLE_HOME is not set. How to set ORACLE_HOME in unix? Thanks

10. Shell Programming and Scripting

Sqlplus in shell script

Hi All, Please let me know what i am missing in the following code (part of my script) Schemas=(AWQM WFCONTROLLER PROVCO PRISM) for s in "${Schemas}" do sch="${s}_$tol" if || ;then echo "This is AD or TD region" sqlplus -s $sch/$tpwd@$ttns <<EOF...

LEARN ABOUT DEBIAN

array-info

array-info(1)															     array-info(1)

NAME

       array-info - check the status of a HP (Compaq) SmartArray controller

SYNOPSIS

       array-info -d array_device_path [-a|-l|-A|-c|-s|-L|-h]

DESCRIPTION

       Array-info is a command line tool to retrieve informations and logical drives status from several RAID controllers (currently HP Compaq IDA
       and CISS and MD).  It displays informations about the firmware version, Rom revision, number of physical and logical  drives  on  the  con-
       troller, aswell as the fault tolerance, size, number of physical disks and status for each logical drive.

OPTIONS

       --device | -d
	      Path to array device, e.g. /dev/ida/c0d0 or /dev/cciss/c0d1

       --all-drives | -a
	      Show informations about all drives

       --logical drive | -l
	      Show informations about selected logical drive

       --show-ctrl | -c
	      Show informations about controller

       --show-logical | -L
	      Show informations about logical drives

       --show-physical | -p
	      Show physical device informations

       --show-status | -s
	      Show status of logical drives

       --show-all | -A
	      Show all informations

       --version | -V
	      Show version

       -h     Show help about options

COPYRIGHT

       This  manual page was written by Raphael Pinson <<raphink@ubuntu.com>>.	Permission is granted to copy, distribute and/or modify this docu-
       ment under the terms of the GNU General Public License, Version 2 or any later version published by the Free Software Foundation.

								    2006-12-15							     array-info(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

passing parameters from a shell script to sqlplus

Discussion started by: phani

2. Shell Programming and Scripting

running shell script from sqlplus

Discussion started by: dkr123

3. Shell Programming and Scripting

help me in sending parameters from sqlplus script to unix shell script

Discussion started by: Hara

4. Shell Programming and Scripting

Call sqlplus in the shell script

Discussion started by: beaniebear