Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Problem in connecting to db in a loop

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Problem in connecting to db in a loop
# 8  
Old 04-11-2016
Here it is:

Code:
done <county_list
+ 0< county_list
+ read county_code county_name usr_nm passwd domain
+ IFS=|
+ echo Connecting to county 1
Connecting to county 1
+ /app/oracle/product/11.2.0.3/client/bin/sqlplus abc/def@ALA01 @sqlquery.sql
+ 1>> /home/devdbg2/uat_report/DB_conn/Alameda_conn.txt 2> error.txt
+ stat=0
+ echo PRINTING STATUS 0
PRINTING STATUS 0
+ [ 0 != 0 ]
+ echo SEARCHING FOR ERROR IN LOG FILE
SEARCHING FOR ERROR IN LOG FILE
+ + grep ERROR /home/devdbg2/uat_report/DB_conn/Alameda_conn.txt
+ wc -l
cnt=0
+ [ 0 -ne 0 ]
+ echo no match with the pattern
no match with the pattern
+ echo OUT OF IF LOOP
OUT OF IF LOOP
+ echo

+ + sed -n 4 p /tmp/uat_temp.txt
+ sed s/ //g
count=3
+ echo 1,Alameda,3
+ 1>> /home/devdbg2/uat_report/Report/UAT_Report_04112016.CSV
+ rm -f /tmp/uat_temp.txt
+ read county_code county_name usr_nm passwd domain
+ IFS=|
+ echo Connecting to county 7
Connecting to county 7
+ /app/oracle/product/11.2.0.3/client/bin/sqlplus abc/xyz@CC07 @sqlquery.sql
+ 1>> /home/devdbg2/uat_report/DB_conn/ContraCosta_conn.txt 2> error.txt
+ stat=1
+ echo PRINTING STATUS 1
PRINTING STATUS 1
+ [ 1 != 0 ]
+ continue
+ read county_code county_name usr_nm passwd domain
+ IFS=|

echo "OUT OF WHILE LOOP"
+ echo OUT OF WHILE LOOP
OUT OF WHILE LOOP

# 9  
Old 04-11-2016
OK, post a hex dump (od -Ax -tx1z file) of your county file.
# 10  
Old 04-11-2016
the command doesn work

/home/devdbg2/uat_report>od -Ax -tx1z county_list
od: Invalid argument for -t option
/home/devdbg2/uat_report>
# 11  
Old 04-11-2016
You are not telling me that you can't read the od man page to correct an obviously version dependant command option incompatibility?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sqlplus not connecting the 2nd time in for loop

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

2. UNIX for Dummies Questions & Answers

Problem connecting FreeBSD VM(Hyper-v) to internet

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)
Discussion started by: Vishawdeep
2 Replies

3. UNIX for Dummies Questions & Answers

Problem connecting with Reflection X 14.1

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)
Discussion started by: SIFT3R
2 Replies

4. Shell Programming and Scripting

Problem in Connecting to Oracle Database using KornShell

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)
Discussion started by: mraghunandanan
3 Replies

5. Post Here to Contact Site Administrators and Moderators

Problem connecting to www.unix.com

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)
Discussion started by: Vi-Curious
2 Replies

6. Shell Programming and Scripting

Error connecting oracle from inside while loop

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

7. Programming

Problem Connecting to Socket

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)
Discussion started by: Stevhp
6 Replies

8. UNIX for Dummies Questions & Answers

Having A Problem Connecting to Oracle Using Cron

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)
Discussion started by: goodmis
1 Replies

9. UNIX for Dummies Questions & Answers

Connecting with X-win problem

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)
Discussion started by: dragunu
2 Replies

10. UNIX for Dummies Questions & Answers

Problem Connecting from Windows base OS to linux

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)
Discussion started by: S.Vishwanath
3 Replies
Login or Register to Ask a Question