I am using the shell script code to connect to Oracle RAC database.
Passing the parameter of cluster database name.
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.
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)
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)
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)
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)
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)
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)
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
LEARN ABOUT DEBIAN
user_clusters
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)