Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

SQL Connection check though Scripting

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers SQL Connection check though Scripting
# 1  
Old 08-20-2008
SQL Connection check though Scripting
Hi Guys,

I wanted to check the sql connection through scripting if it is avilable then proceed else stop the process

I was trying
sqlplus -L username/passwd@sid
if this is not sucess it gives non-zero.

but if it is success it is going into the sqlplus prompt.

So how could i get out of it and check the status.
# 2  
Old 08-20-2008
try adding EOF
sqlplus -L username/passwd@sid << EOF > /dev/null
EOF
# 3  
Old 08-20-2008
sorry it won't work.. it willl return status as 0 only...
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to use for loop to execute multiple .sql files while using SQLPLUS for db connection.?

Hello , Im calling every single file inside my script like 1.sql,2.sql so on it looks so tedious. I want to replace with for loop where every file gets executed. When i use for loop im getting errorUnexpected EOF] , can anyone please help me out in this.. How i can use for loop to invoke my... (6 Replies)
Discussion started by: preethi87
6 Replies

2. UNIX for Dummies Questions & Answers

UNIX string connection to sql server db

Hi, i have to perform a connection from unix to sql server database, using TCP protocol. I have all connection parameters (user,pwd,server_name,port,db_name). How can i perform this connection, by unix console ? is it available a command similar to this one (for oracle): sqlplus... (1 Reply)
Discussion started by: nash83
1 Replies

3. UNIX for Dummies Questions & Answers

Test new DSN connection to sql server

I installed an odbc driver and created a DSN to connect to a sql server database on AIX 6. I want to know how to test the DSN from the command line. What syntax or commands do I use? ---------- Post updated at 11:44 AM ---------- Previous update was at 08:26 AM ---------- OK I figured out how... (9 Replies)
Discussion started by: Jdbrown239
9 Replies

4. Programming

TCP connection check

Hi. I am writing client - server application using TCP sockets. I need some very basic functionality, namely: how to check if another "participant" of the connection is still present? I want to handle situations, when client is gone, or server breaks down, etc. (25 Replies)
Discussion started by: Shang
25 Replies

5. Shell Programming and Scripting

SQL query in a loop with single sqlplus connection

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)
Discussion started by: lsantacana
4 Replies

6. Shell Programming and Scripting

Execute multiple SQL scripts from single SQL Plus connection

Hi! I would like to do a single connection to sqlplus and execute some querys. Actually I do for every query one connection to database i.e echo 'select STATUS from v$instance; exit' > $SQL_FILE sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT echo 'select VERSION from v$instance;... (6 Replies)
Discussion started by: guif
6 Replies

7. Shell Programming and Scripting

Help with SQL*Plus Connection

I "inherited" these scripts which are used to access an Oracle DB on a test envoiroment. Originaly someone from our security team would add an system user and password to the otherwise finished script and encrypt the whole thing. The encrypted file (script.x) would then be scheduled with Control-M.... (7 Replies)
Discussion started by: dani_nonato
7 Replies

8. Shell Programming and Scripting

Connection to Microsoft SQL Server

Hi, I am using "ksh" and trying to connect to the Microsoft SQL Server but it gives an error that is: DB-LIBRARY error: Unexpected EOF from SQL Server. Can any one please help me to resolve this issue. And i am using Putty to connect to the Unix server. Thanks (3 Replies)
Discussion started by: anupdas
3 Replies

9. UNIX for Dummies Questions & Answers

check Internet connection?

I am using SUSE OS and want to check internet connection... I have tried: ping -c3 google.com The output i have got is: Unknown host google.com does it means that i do not have Internet connection?? Or please help me with any Command to find Internet connection? Thanks for any help. (1 Reply)
Discussion started by: salil2012
1 Replies

10. Shell Programming and Scripting

sql scripting help

I would like to run the following as bash script sql -U history update feed_domain_configuration set enabled=1 where domain='lon' and vendor_name='<lond' -sam (3 Replies)
Discussion started by: sam786
3 Replies
Login or Register to Ask a Question