Sponsored Content
Top Forums UNIX for Dummies Questions & Answers If condition fails, advise using wildcard Post 302603513 by Siva SQL on Thursday 1st of March 2012 07:34:55 AM
Old 03-01-2012
If condition fails, advise using wildcard

OS Environment: HP-UX B.11.31 U ia64

I am using the shell script code to connect to Oracle RAC database.
Passing the parameter of cluster database name.


Code:
typeset -l DB_ID=$1
+ typeset -l DB_ID=sivDB

#---- 3. SetDB validation -------------
if [ "$ORACLE_SID"x != "${DB_ID}"x ]; then
 print "============================"
 print " setdb failed for $db"
 print "============================"
 exit
fi

+ [ sivDB1x != sivDBx ]
+ print ========================================================
+ print  setdb failed for
 setdb failed for
+ print ========================================================
+ exit

Question:
Here I want the IF condition to succeed if first 5 characters of $ORACLE_SID matches with ${DB_ID}. Please advise.

For example: [ sivDB1x != sivDBx ]

Note: Actually I pass the Oracle RAC DB name. During the setdb ( setting the Oracle Environment ) it sets the instance running on the node like sivDB1 for Node1 and sivDB2 for Node 2 for the RAC DB of sivDB.
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Find wildcard .shtml files in wildcard directories and removing them- How's it done?

I'm trying to figure out how to build a small shell script that will find old .shtml files in every /tgp/ directory on the server and delete them if they are older than 10 days... The structure of the paths are like this: /home/domains/www.domain2.com/tgp/ /home/domains/www.domain3.com/tgp/... (1 Reply)
Discussion started by: Neko
1 Replies

2. UNIX for Dummies Questions & Answers

I am one of the newbies, please advise

I am new to UNIX and Linux. I have some experiences with Windows server. I am thinking to start with those OS (Unix/Linux) and more specifically with the OS for the server. however, i have no idea which one would i start first, unix or linux? Because i also dont know how they are different. ... (3 Replies)
Discussion started by: sanlen
3 Replies

3. Linux

Please advise me.

Hello all, I have a question, and would like some advice please. I am a windows guy by trade....5 years in the Marines is where I learnt a lot of what i know. I took a junior level sys admin job...learned a bit more...and now I do IT security. All of this happened in the last 8 years. So I'm 27... (2 Replies)
Discussion started by: Quality
2 Replies

4. Shell Programming and Scripting

Stop execution of script if some condition fails

After my if condtion give rusult true then script should stop execution. Please advice...Thnaks in advance (1 Reply)
Discussion started by: vivek1489
1 Replies

5. HP-UX

Difference between [condition] and [[condition]] and ((condition)) when used with if condition

Executed the following if conditions .. and got different results . only (( )) gave correct o/p with all scenarios . Can anybody please let me know what is the difference between and ] and ((condition)) when used with if condition. And why each condition gave different result. 1.... (2 Replies)
Discussion started by: soumyabubun
2 Replies

6. Shell Programming and Scripting

redirect stdout echo command in condition A run in condition B

hi, I have some problems in my simple script about the redirect echo stdout command inside a condition. Why is the echo command inside the elif still execute in the else command Here are my simple script After check on the two diff output the echo stdout redirect is present in two diff... (3 Replies)
Discussion started by: jao_madn
3 Replies

7. Shell Programming and Scripting

If condition return 0 even when it fails to satisfy te condition

HI My doubt may be basic one but I need to get it clarified.. When i use "if" condition that checks for many AND, OR logical conditions like if ]; then return 0 fi Even the if condition fails it returns as zero.. Any clue.. But if i add else condition like if ]; ... (2 Replies)
Discussion started by: Priya Amaresh
2 Replies

8. Shell Programming and Scripting

How to exit from shell script if above condition fails?

HI cd ${back_home} if above back_home does not exist, then script shoul exit. Please let us know how to do that (7 Replies)
Discussion started by: buzzme
7 Replies

9. Shell Programming and Scripting

If condition fails for special charecter

I have a sample server name listed in variable as below: var="server-13" I need to check if the 7th character on $var is number 1 whichenv=`echo "$var"| head -c 7 | tail -c 1` if ]; then echo "9 found" else echo "9 Not Found" fi Output: This works... (3 Replies)
Discussion started by: mohtashims
3 Replies
USER_CLUSTERS(5)					 Debian PostgreSQL infrastructure					  USER_CLUSTERS(5)

NAME
user_clusters - File linking users to PostgreSQL clusters DESCRIPTION
This file maps users against the database clusters to which they will connect by default. However, every user can override these settings in ~/.postgresqlrc. When scanning this file, the first matching line will be used. It is a good idea to provide a default explicitly, with a final line where both user and group are set to *. If there is no default, the implicit default is to connect to the cluster whose postmaster is listening on port 5432 and to the database matching the user's login name. FORMAT
Comments are introduced by the character #. Comments may follow data on a line; the first comment character terminates the data. Leading whitespace and blank lines are ignored. Each uncommented, non-blank line must describe a user, group or the default (where both user and group are set to *). Fields must be given in the following order, separated by white space: USER The login id of the Unix user to whom this line applies. The wildcard character * means any user. GROUP The group name of the Unix group to which this line applies. The wildcard character * means any group. VERSION The major PostgreSQL version of the cluster to connect to. CLUSTER The name of a cluster to connect to. A remote cluster is specified with host:port. If port is empty, it defaults to 5432. DATABASE Within the cluster, the database to which the user will connect by default if he does not specify a database on the command line. If this is *, the default database will be the one named by the user's login id. NOTES
Since the first matching line is used, the default line must come last. SEE ALSO
pg_wrapper(1), postgresqlrc(5) Debian Feburary 2005 USER_CLUSTERS(5)
All times are GMT -4. The time now is 04:44 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy