connect to sqlplus from shell

aya_r · #1 (**permalink**) 02-07-2007

I'm writting a shell script and at the begining I login to sqlplus by
sqlplus -l user_name/password@instance
what I would like is to check if the database is down or not , and if the database has started moved to the next step else sleep for a certain time and then check again .
I know how to do the sleep part, but I don't know how to check if the database is not down. can some one help me please.

Thanks,

Dhruva · #2 (**permalink**) 02-07-2007

you can check with $? status.if database is down you will not be able to connect with data base.

if [ $? != 0 ]
then
PROGRAM_STATUS=`echo NOT CONNECTED TO SQL`
fi

you may check another post here

srikanthus2002 · #3 (**permalink**) 02-07-2007

am using infomix database on unix os

Code:

if [ `tbstat - | grep On-Line | wc -l` -eq 0 ]
then
        echo Informix database seems to be down. Please start the database
        echo do this do this
else
        echo database is running
        echo do this
fi

where tbstat is used to find database status...here you have to find out the command which gives status of your database....

radoulov · #4 (**permalink**) 02-07-2007

Quote:

Originally Posted by aya_r

I'm writting a shell script and at the begining I login to sqlplus by
sqlplus -l user_name/password@instance
what I would like is to check if the database is down or not , and if the database has started moved to the next step else sleep for a certain time and then check again .
I know how to do the sleep part, but I don't know how to check if the database is not down.
[...]

For quick and "dirty" check you can use something like this:

Code:

oracheck ()
{
  printf "whenever sqlerror exit failure\nselect null from dual;\n" |
  sqlplus -sl user/pass 2>&- 1>&- || return 1
}


Usage:

until oracheck; do sleep n; done
go_to_the_next_step

matrixmadhan · #5 (**permalink**) 02-07-2007

If its on Informix use

Code:

 onstat -

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
connect sqlplus from unix	nehak	UNIX for Dummies Questions & Answers	1	05-27-2008 08:12 AM
Shell Script And SQLPLUS	maco_home	UNIX for Dummies Questions & Answers	6	08-25-2007 12:05 PM
connect to sqlplus in a script	big123456	Shell Programming and Scripting	1	09-18-2006 06:56 AM
calling sqlplus from shell	suds19	Shell Programming and Scripting	2	10-24-2002 04:01 PM
sqlplus and shell scripting	inquirer	UNIX for Dummies Questions & Answers	10	08-16-2001 12:46 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: