|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Checking SQL DB Availability
Post 302888292 by SeaSoul on Thursday 13th of February 2014 04:20:32 PM
02-13-2014
Checking SQL DB Availability
Hello everybody. I have a little question. Im creating a script for checking the status of different servers, and everything is running fine except for one thing. I have to check if certain DBs are connectables, I dont care anything else, nor running querys nor updating tables, the only thing I need to know is if the DB is connectable. It should be an easy task but frankly Im not very sure how to do it, so I tried the code below. And the problem I got with it is an "sqlplus : not found" from the unix shell. If anyone could help me itd be great. Thanks in advance.
Here goes what I have until now. If anyone knows another way thats great, I really dont care HOW to do it, just that it works.
#!/bin/bash
dbconnection=1
echo "Setting environment"
ssh -l myuser UNIXSERVER ". /apps/Ascential/DataStage/DSEngine/dsenv"
echo "Connecting to SQL"
dbcoonection=$(ssh -l myuser UNIXSERVER "sqlplus ????@????/????")
dbconnection=$?
echo "Status = $dbconnection"
if [ "$dbconnection" -lt "1" ]; then
echo "Connected"
else
echo "Not connected"
fi
Here goes what I have until now. If anyone knows another way thats great, I really dont care HOW to do it, just that it works.
#!/bin/bash
dbconnection=1
echo "Setting environment"
ssh -l myuser UNIXSERVER ". /apps/Ascential/DataStage/DSEngine/dsenv"
echo "Connecting to SQL"
dbcoonection=$(ssh -l myuser UNIXSERVER "sqlplus ????@????/????")
dbconnection=$?
echo "Status = $dbconnection"
if [ "$dbconnection" -lt "1" ]; then
echo "Connected"
else
echo "Not connected"
fi
|
|
10 More Discussions You Might Find Interesting
1. IP Networking
Hi. In my KSH script I'm running a command on a remote server. I want to know how I can test to see if the remote server is available (accessible) prior to running the command. Any ideas?
My command looks like:
`ssh $USER@$TARGET_SERVER_DNS ls -l $REMOTE_FOLDER `
This check should be... (1 Reply)
Discussion started by: dylanmilks
1 Replies
2. Shell Programming and Scripting
Hi. In my KSH script I'm running a command on a remote server. I want to know how I can test to see if the remote server is available (accessible) prior to running the command. Any ideas?
My command looks like:
`ssh $USER@$TARGET_SERVER_DNS ls -l $REMOTE_FOLDER `
This check should be... (4 Replies)
Discussion started by: dylanmilks
4 Replies
3. Shell Programming and Scripting
Hi Guru's,
I need to check the availability of a web page for every one hour through a script. Following is the requirement.
1. Go to http://vsn.srivsn.com
2. If any error encountered in openeing the home page, it should trigger an email with the appropriate error message.
3. If page opens... (6 Replies)
Discussion started by: srivsn
6 Replies
4. Solaris
Hi, Im new in shell programming.
I need to know the availability for specific printers. We send requests from solaris to printers located at an NT server. My idea is creating a shell that will monitor availbaility and send an email when something is wrong.
I have a file with printers and its... (2 Replies)
Discussion started by: agsarm1971
2 Replies
5. Shell Programming and Scripting
hi,
i am using a sqlplus connection in one of my shell scripts. i want to check if the connection is set properly or not.. can i use '$?' to check the status of the sql connectivity..? or is there any other option to do that..?
thanks, (1 Reply)
Discussion started by: kripssmart
1 Replies
6. Shell Programming and Scripting
HI CAN ANY ONE HELP ME FOR BELOW QUESTION
CHECKING AVAILABILITY OF SERVICE IN LINUX (2 Replies)
Discussion started by: satheeshkr_cse
2 Replies
7. Programming
I'm writing a KSH shell script that's using SQL though DB2.
If I have a table defined and populated
db2 "create table tb(num int,letter char(4))"
db2 "insert into tb values(111,a)
db2 "insert into tb values(112,b)
db2 "insert into tb values(111,c)
How can I check if a letter user... (0 Replies)
Discussion started by: busdude
0 Replies
8. Shell Programming and Scripting
Hi,
I want my script to check for availability of few files contineously for some time.
Lets say from 10:00 AM to 10:30 AM script should keep checking on a particular location for each file one by one. If all the files are available then only it should complete the next processing part, else... (2 Replies)
Discussion started by: amit.mathur08
2 Replies
9. SCO
Hi, (i'm sorry for my english)
I'm a problem on boot sco unix 5.0.5 open server.
this stop at "Checking protected password and checking subsystem databases"
(See this image )
I'm try this:
1) http://www.digipedia.pl/usenet/thread/50/37093/#post37094
2) SCO: SCO Unix - Server hangs... (9 Replies)
Discussion started by: buji
9 Replies
10. Programming
I want to check for rows in a table where all values (except the key) is empty. I am using MySQL 5.5.
I plan to do this mechanically, so the approach should work for any table in my database schema.
Suppose for illustration purposes I start with the following table:
CREATE TABLE `sources` (
... (4 Replies)
Discussion started by: figaro
4 Replies
LEARN ABOUT DEBIAN
colorgccrc
COLORGCCRC(5) File Formats Manual COLORGCCRC(5) NAME
colorgccrc - configuration file for colorgcc DESCRIPTION
A colorgccrc configuration file is used to configure the highlighting of the compiler output from colorgcc. SYNTAX
Each line consists of a keyword designating a configuration variable. The keyword is followed by `:' and then one or several values (depending on the keyword). Lines beginning with a hash mark `#' are comments. CONFIGURATION VARIABLES
g++ | gcc | c++ | cc | g77 | gcj | gnat | gpc Specifies the paths to the compilers. Takes one value; a path to the compiler. nocolor Specifies what terminal types colorization should be disabled on. Takes one or several values, separated by whitespace. srcColor Specifies the highlighting attributes source-code should be given. Takes one or several color attributes. See the section COLOR ATTRIBUTES for more information. introColor Specifies the highlighting attributes for normal compiler output. Takes one or several color attributes. See the section COLOR ATTRIBUTES for more information. warningFileNameColor | errorFileNameColor Specifies the highlighting attributes for the filename in a warning or an error, respectively. Takes one or several color attributes. See the section COLOR ATTRIBUTES for more information. warningNumberColor | errorNumberColor Specifies the highlighting attributes for the line-number in a warning or an error, respectively. Takes one or several color attributes. See the section COLOR ATTRIBUTES for more information. warningMessageColor | errorMessageColor Specifies the highlighting attributes for the message-text in a warning or an error, respectively. Takes one or several color attributes. See the section COLOR ATTRIBUTES for more information. COLOR ATTRIBUTES
The following attributes are valid for highlighting. clear, reset bold, underline, underscore, blink, reverse, concealed black, red, green, yellow, blue, magenta, cyan, white on_black, on_red, on_green, on_yellow, on_blue, on_magenta, on_cyan, on_white SEE ALSO
gcc(1), colorgcc(1) HISTORY
Jan 15 2003: Initial version of this manual-page. REPORTING BUGS
Report bugs to <jmoyers@geeks.com> AUTHORS
Jamie Moyers <jmoyers@geeks.com> is the author of colorgcc. This manual page was written by Joe Wreschnig <piman@sacredchao.net>, and modified by David Weinehall <tao@debian.org>, for the Debian GNU/Linux system (but may be used by others). COPYRIGHT
Copyright (C) 2003 Jamie Moyers This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICU- LAR PURPOSE. Jan 15, 2003 COLORGCCRC(5)