Sponsored Content
Full Discussion: error in if statement
Top Forums UNIX for Dummies Questions & Answers error in if statement Post 302298629 by Swapna173 on Wednesday 18th of March 2009 07:13:51 AM
Old 03-18-2009
error in if statement

Hi,

This is my script to catch any oracle errors.

In this, the $sqlerr returns
ORA-01017: invalid username/password; logon denied
when i specify wrong username/password

the if condition is failing. how can i resolve the issue.
the if statement gives error
Code:
[: too many arguments

Code:
sqloutput=`sqlplus -s -L $dasDBConnectString @$SqlFiles/testSQLConnection.sql`
		sqlerr=`echo "$sqloutput" | grep "ORA-"`
		echo $sqlerr
		if [ -n $sqlerr ] #sql connection error
		then
			Status=10
		else
			Status=$?
		fi

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

parsing error in if statement

hello, I am trying to parse an error returned by a command inside the if statement but it is just displays the full error instead and then stops. if ; then echo "no such package" else echo "similar version found will use pkgrm" fi the above code just displays please let me know... (2 Replies)
Discussion started by: rakeshou
2 Replies

2. Shell Programming and Scripting

Error with if statement..Please help

:b:hi, I have a script as given below: pr_det="1" if then awk ' BEGIN {printf("%23s","session")}' >> report.txt awk ' BEGIN {printf "\n"} ' >> report.txt else awk ' BEGIN {printf("%55s","file_dsc")} ' >> report.txt awk ' BEGIN {printf("%101s","no_recs")} '... (1 Reply)
Discussion started by: jisha
1 Replies

3. Shell Programming and Scripting

Snytax error on If Statement--help

year=`date '+%Y'` month=`date '+%m'` day=`date '+%d'` day=`expr $day - 1` case $month in 1 | 3 | 5 | 7 | 8 | 10 | 12);; if($day =7 ); then $day=6 fi 4 | 6 | 9 | 11);; if ; then $day=31 fi 2);; if ; then if ; then (2 Replies)
Discussion started by: dannyd_y
2 Replies

4. Linux

error in if statement

Hi , I am getting an error when I run the script for checking word "view" in a file . I am using if statement. like this if then VW_VAR=` cat $TN.${ecmdate}.sql1 | grep -i view | awk '{print $3}' | cut -d '.' -f2 ` echo " VW_$VW_VAR " sed -e... (16 Replies)
Discussion started by: capri_drm
16 Replies

5. Shell Programming and Scripting

Error in IF statement

HI i am getting error while executing the given statement for filename in `cat a/file.lst` do if then echo "Exit Code Description :File $filename - is missing in Input Directory" >a.log exit else count1=`awk 'END {print NR}' $filename` echo "$count1">>a.log count2=`awk 'END {print... (4 Replies)
Discussion started by: ravi214u
4 Replies

6. Shell Programming and Scripting

error in insert statement

hi, When i try to run the code below, i get the following error "ksh: syntax error: `(' unexpected" i am not able to figure it out. Can anyone help me? Code: (2 Replies)
Discussion started by: ragavhere
2 Replies

7. Shell Programming and Scripting

Error in if statement

I am working on script for stale nfs. the file consists of cat data01stale.log - - - - /abcd/backup - - - - /abcd/data Script (16 Replies)
Discussion started by: nareshkumar522
16 Replies

8. Shell Programming and Scripting

If statement Syntax error

Hi Can you please tell me what is wrong with this line: if && ]; then basically i want to check if x = 12 and F (Filename) end with 'g'. But it is throwing syntax error. (7 Replies)
Discussion started by: rtagarra
7 Replies

9. Shell Programming and Scripting

Awk/if statement error

Can anybody tell the correct way to use the following awk pattern check within an if statement? When I run this command outside of the if statement cat /tmp/test2.out | awk -v T=$TIME -v G=$GROUP -v C=$CDATE '$0 ~ T && $0 ~ G && $0 ~ C' | grep -i "Starting the group" I get the following... (0 Replies)
Discussion started by: kieranfoley
0 Replies

10. UNIX for Beginners Questions & Answers

Error code with if statement

hello all im new to unix and when i use below script i get an error : #! /bin/bash Echo -e "enter the name of the file : \c" read file_name if then echo "$file_name found" else echo "$file_name not found" fi running the script i get below error : $ ./hello (26 Replies)
Discussion started by: Ibrahims1
26 Replies
shexp(1)						      General Commands Manual							  shexp(1)

Name
       shexp - display password expiration information for a user

Syntax
       shexp [-q] [username]

Description
       The command is used to display a user's password expiration information.  The specified username, or logname if no username is supplied, is
       converted to a UID by searching through the passwd file.  The UID is then used to look up the user's entry in  the  Auth  Data  Base.   The
       password expiration information is then printed out in format.
       % shexp
       Expires Tue Dec	6 10:49:18 EST 1988
       If  the	password  has  already expired the word Expires will be replaced with the word Expired. If password expiration is disabled for the
       particular user in question the output of will be Never expires.

Options
       -q   Instead of displaying the expiration date and time in format, outputs it as three decimal numbers: the minimum password lifetime,  the
	    maximum password lifetime, and the password modification time.  All three numbers are displayed as they are found in the database.

Restrictions
       Only the super-user may obtain information about users with UIDs other than the real UID of the invoking process.

Diagnostics
       User not found in passwd data base.
       There is no entry in for the specified username.

       Cannot stat auth file.
       The database is missing (security features may not be enabled).

       Insufficient privilege.
       An insufficiently privileged user is asking for information about a username with a UID different then their current real-UID.

       An exit value of 0 indicates a successful operation, any other exit status indicates an error.

Files
See Also
       passwd(1), getauthuid(3), auth(5)
       Security Guide for Users

																	  shexp(1)
All times are GMT -4. The time now is 09:52 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy