SQL Connection check though Scripting

Swapna173 · #1 (**permalink**) 08-20-2008

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.

vidyadhar85 · #2 (**permalink**) 08-20-2008

try adding EOF
sqlplus -L username/passwd@sid << EOF > /dev/null
EOF

vidyadhar85 · #3 (**permalink**) 08-20-2008

sorry it won't work.. it willl return status as 0 only...

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
check ssh connection to remote host	praveenbvarrier	Shell Programming and Scripting	6	10-06-2008 12:46 PM
Bash Script to check Remote Host Connection	zulfikarmd	UNIX for Dummies Questions & Answers	5	04-16-2008 06:53 AM
How to check the file existence using shell scripting in Solaris-10	krevathi1912	SUN Solaris	2	11-26-2007 05:07 AM
How to check process/cpu utilisation thru unix shell scripting	manas_ranjan	UNIX for Dummies Questions & Answers	0	07-25-2007 04:00 PM
How to check the TCP/UDP port of a connection	tayyabq8	UNIX for Dummies Questions & Answers	2	05-18-2006 12:55 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: