Hi,
I am getting the error "No matching <<", when i run the below. Is it that we can't execute SQL in a Unix loop. I am executing a SQL in a loop. Is it the EOF is written wrongly.
. /opt/app/wlsconfigv61/domains/profiles/oracleV901.profile
export DBUSER=ecdb01
set -A DBINSTANCE... (3 Replies)
Connected to oracle database
sqlplus << EOF
$CONNECTSTR
set heading off
set trimspool on
set feedback off
select ID,DATE from sysadm.TEST where VALUE = 'A' order by ID;
value_id = ID
value_date = DATE
EOF
1. Is it possible to reference the values, ID,DATE in unix shell script.
2.... (20 Replies)
Hello,
I am doing a shell script which contain a pl/sql loop to search for 3 values, i would like to call another shell script inside this sql loop each time it find the values. so how can i call shell script from pl/sql using its variables, any idea?
Here is idea about the code:
my... (1 Reply)
Hi i want to run a query in loop(unix loop) every 2 hours and spool the result to a file.
i am trying but getting error here is the script
$ while true
do
sqlplus ank/ank<<!
spool ank.lst
select * from v$database;
exit
sleep 7200
done
:D (2 Replies)
Trying to compile all SQL files using a shell script. But the below code is not working. Below Code works fine when for loop is not there(commenting line no: 1,2 and 9).
1. sq_lfile=`ls *.sql`
2. for current_sql_file in $sql_file
3. do
4. sqlplus uname/pass@Service>>SQLLOG << -ENDOFSQL... (3 Replies)
Hi,
I'm trying to build a shell script that reads a set of accounts from a file. For each account I need to perform a set of sql queries. So I have a loop with a set of sqlplus connections to retrieved my data.
Is it possible to have a single sqlplus connection before entering the loop and... (4 Replies)
I want to spool files from unix using a sql script that would
take values from another sql query within the KSH script..
unix loop
select order_date from date_tbl
for each order_Date i need to call this spool script with the value
sqlplus scott/tiger@order_db @/ordspool/order_date.sql... (2 Replies)
Hi all,
I have script, which performing sql queries and put output into file.
When I run this script manually, its working fine, but when I want to schedule it with cron I am getting errors...
I defined LD_LYBRARY_PATH and ,but no result. After I defined it, I am getting error:
# more... (4 Replies)
I am having one heck of a time, and I need anyone that can assist in finding my issue here....
First off, here is the script we are using:
pastebin dot com slash njwUg6vd
All usernames and passwords have been edited out. We are using an actual database user, and not root (tried both).
I... (0 Replies)
Hi,
I am trying to extend unix variable value with mysql resultset. It's working fine in terminal but not working in shell script.
#!/bin/bash
export prcs_nm=$1
export tbl_nm=$2
export rslt=$(
mysql -sN -u root -proot123 -e "
select sql_query
from retail_db.config where prcs_nm =... (3 Replies)
Discussion started by: Prasad
3 Replies
LEARN ABOUT MOJAVE
tping
TPING(1) LAM COMMANDS TPING(1)NAME
tping - Send echo messages to LAM nodes.
SYNOPSIS
tping [-hv] [-c count] [-d delay] [-l length] nodes
OPTIONS -h Print the command help menu.
-v Turn OFF verbose mode.
-c count Send count messages.
-d delay Delay delay seconds between each message.
-l length Each message is length bytes long.
DESCRIPTION
The tping command sends messages to, and collects replies from, a list of nodes, via the LAM echo server. It is similar to the UNIX
ping(8) command, and is used as a quick diagnosis of the LAM network.
Unless options are specified, tping sends a 1 byte message an infinite number of times, displaying the roundtrip time of each message as it
completes, with a delay of 1 second between roundtrips. After the loop is broken (with keyboard interrupt, eg: ^C), tping prints statis-
tics about all roundtrip messages.
EXAMPLES
tping h
Echo messages to the local node.
tping -v n7 -l 1000 -c 10
Echo 1000 byte messages to node 7. Stay silent while working. Stop after 10 roundtrips and report statistics.
BUGS
There is no built-in timeout and tping will wait forever to receive an echo. If no echo is received, due to a dead link or node, tping
hangs. Stop the process with a keyboard suspend signal (eg: ^Z) and terminate LAM with lamhalt(1) or lamwipe(1) (although the use of
lamwipe(1) is deprecated).
SEE ALSO lamhalt(1), lamwipe(1)LAM 7.1.4 July, 2007 TPING(1)