how to verify sqlplus not installed on solaris - Shell Programming and Scripting

mmunir · #1 (**permalink**) 09-01-2008

i want to write shell script that exit by displaying error if sqlplus is not installed.

The platform is oracle10g on solaris sparc.

I tried the which sqlplus command, but it returns errorcode 0 even sqlplus is not installed.

Kindly help?

yongitz · #2 (**permalink**) 09-01-2008

Hi! Can you post your script here?

mmunir · #3 (**permalink**) 09-01-2008

It is below:

which $ORACLE_HOME/bin/sqlplus > /dev/null 2> /dev/null

if [ $? != 0 ]; then
echo "ERROR: Either sqlplus is not available on this machine or ORACLE_HOME is configured wrongly in install.sh"
exit 1
fi

palsevlohit_123 · #4 (**permalink**) 09-01-2008

filename="$ORACLE_HOME/bin/sqlplus"
if [ -s $filename ]
then
echo "YES. sqlplus available"
else
echo "NO sqlplus not avail"
fi

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to verify Sun Solaris installation	agarwal	SUN Solaris	3	07-03-2008 07:05 PM
Verify Hardware installed HP-UX11	hoffies	HP-UX	16	11-19-2007 03:11 AM
Verify Hardware installed on HP-UX 11	hoffies	UNIX for Dummies Questions & Answers	1	11-12-2007 10:23 AM
Just installed Solaris 8 but....	timresh	UNIX for Dummies Questions & Answers	4	02-05-2005 05:45 PM
Solaris (verify 64 or 32 bit	witt	UNIX for Dummies Questions & Answers	3	11-30-2001 11: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: