sorry to mention that the solution you gave is not working for me.
I tried using continue command in two ways, one as mentioned by you, and the other by searching for any ERROR in the sqlplus output file.
Both continue statements doesn seem to work.
I have included some echo statements for your reference.
Code:
while IFS="|" read county_code county_name usr_nm passwd domain
do
echo "Connecting to county $county_code"
$ORACLE_HOME/bin/sqlplus ${usr_nm}/${passwd}@${domain} @sqlquery.sql >> ${conn_dir}/${county_name}_conn.txt 2>error.txt
stat=$?
echo "PRINTING STATUS $stat"
[ "$stat" != 0 ] && continue
echo "SEARCHING FOR ERROR IN LOG FILE"
cnt=`grep "ERROR" ${conn_dir}/${county_name}_conn.txt|wc -l`
if [ $cnt -ne 0 ]
then
echo "pattern match found - next continue command will be executed"
continue
else
echo "no match with the pattern"
fi
echo "OUT OF IF LOOP"
echo ""
count=`sed -n "4 p" /tmp/uat_temp.txt | sed 's/ //g'`
echo "${county_code},${county_name},${count}" >> $rep_dir/UAT_Report_${CUR_DATE}.CSV
rm -f /tmp/uat_temp.txt
done < county_list
echo "OUT OF WHILE LOOP"
OUTPUT:
Code:
/home/devdbg2/uat_report>./UAT_usr_login_report.sh
Connecting to county 1
PRINTING STATUS 0
SEARCHING FOR ERROR IN LOG FILE
no match with the pattern
OUT OF IF LOOP
Connecting to county 7
PRINTING STATUS 0
SEARCHING FOR ERROR IN LOG FILE
pattern match found - next continue command will be executed
OUT OF WHILE LOOP
sqlplus connection output file:
Code:
/home/devdbg2/uat_report/DB_conn>cat ContraCosta_conn.txt
SQL*Plus: Release 11.2.0.3.0 Production on Mon Apr 11 02:22:41 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name: Enter password:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
Here in county_list, passwrd for ContraCosta is incorrect. in that case, my script should print an error message and continue to run the query for the next county ie Fresno.
But, my script exits whenever there is an ORA error printing the lines followed by the sqlplus commands and exit at the current iteration if the while loop.
I have a network consisting of Linux Server, Win-Nt & 95 OS. I am able to connect from Linux to Win-NT using either ftp / telnet in time. But it takes me around & more than 50 seconds to connect from Wint -Nt/95 to Linux using either ftp/telnet. My network is small & it hardly consists 20-25... (3 Replies)
Hello all,
I am trying to connect to my Solaris 8 system with X-win. However, when i try to connect, a black screen comes up, then closes up immediatley.
I have checked /var/dt/Xerrors, and I am getting the folllowing:
Warning: Missing charsets in String to FontSet conversion
Warning:... (2 Replies)
Can someone tell me how to prevent this?
stty: standard input: Invalid argument
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
SP2-0306: Invalid option.
Usage: CONN where <logon> ::= <username> | /
ERROR:
ORA-12162: TNS:net service name is incorrectly... (1 Reply)
Can anyone help? I'm trying to write a program which will write to a socket. I can get the server to run, but always get an error when I try to connect.
It gives me an error at the "connect" command.
It's probably a simple error, but I can't seem to find it.
#include <sys/socket.h>... (6 Replies)
Hi,
I m trying to connect oracle database from inside while loop.
I m trying to put the output of sql query in a flat file.
Anyone please help me out.
cat $FILE_NAME | \
while read da_name
do
$ORACLE_HOME/bin/sqlplus -s user_name/password@instance << EOF >> $OUTPUT_FILE
select... (3 Replies)
Discussion started by: Devesh5683
3 Replies
6. Post Here to Contact Site Administrators and Moderators
I've been having a problem connecting to the forum. I know it is just something with my computer but I have no idea what it is. It started last week.
Every time I connect I get this:
<?xml version="1.0" encoding="ISO-8859-1" ?>
- <rss version="2.0"... (2 Replies)
Hello, I am very new to Scripting. I am having a Kornshell Script below for connecting to Oracle database. But getting an error while executing it.
#!/bin/ksh
ssh -X root@192.168.2.127 <perimuka>
sleep 5
su - oracle
sqlplus <mraghunandanan>/<peri123> <<eof
Can anyone tell what is wrong... (3 Replies)
Other people at work are able to connect but I am not. I am not sure if there is a setting that I am missing. Connecting from Win7 to Solaris 10. Connection attempt log:
gnome-session
Connecting 144.243.90.235 via TELNET
Thu Mar 29 15:15:32 2012
login: ***
Password: *******
Last login: Thu... (2 Replies)
I created a VM for FreeBSD on hyper-v and i am having trouble connecting it to the internet. My virtual machine config are as below:
100 GB HD
1GB RAM
Generation 1
Two Network adapters
1. Legacy Network Adapter
2. Network Adapter
both are connected to network switch "Internet" which... (2 Replies)
Hi,
I am trying to get the rows(First step is to get the poolid's and then second step run a loop to get the output based on each pool id and third connection is to get the member id and pool id based on a different condition) where based of certain conditions and storing it in a file. I wrote the... (6 Replies)
Discussion started by: ajayakunuri
6 Replies
LEARN ABOUT SUNOS
multimode
asadmin-multimode(1AS)asadmin-multimode(1AS)NAME
asadmin-multimode, multimode - allows you to execute multiple commands while preserving environment settings and remaining in the asadmin
utility
SYNOPSIS
multimode [--file filename] [--printprompt=true] [--encoding encode] [--terse=false] [--echo=false]
Use multimode to process the asadmin commands. The command-line interface will prompt you for a command, execute that command, display the
results of the command, and then prompt you for the next command. Additionally, all the asadmin option names set in this mode are used for
all the subsequent commands. You can set your environment and run commands until you exit multimode by typing "exit" or "quit." You can
also provide commands by passing a previously prepared list of commands from a file or standard input (pipe). You can invoke multimode from
within a multimode session; once you exit the second multimode environment, you return to your original multimode environment.
This command is supported in local mode only.
--file reads the commands as defined in the file.
--printprompt allows the printing of asadmin prompt after each command is executed. Set this option to false when the commands
are piped or redirected from the standard input or file. By default the option is set to true.
--encoding specifies the locale for the file to be decoded.
--terse indicates that any output data must be very concise, typically avoiding human-friendly sentences and favoring well-
formatted data for consumption by a script. Default is false.
--echo setting to true will echo the command line statement on to the standard output. Default is false.
Example 1: Using multimode to execute multiple commands
example% asadmin multimode --file commands_file.txt
Where: example% is the system prompt. The multimode settings are executed from the commands_file.txt file.
EXIT STATUS
0 command executed successfully
1 error in executing the command
asadmin-export(1AS), asadmin-unset(1AS)J2EE 1.4 SDK March 2004 asadmin-multimode(1AS)