#!/bin/ksh
echo DB LIST
ps -ef | grep pmon | grep -v grep | awk -F_ '{print $3}' | sort
db_up=`ps -ef | grep pmon | grep -v grep | awk -F_ '{print $3}' | sort`
echo
echo "Enter database name from the above list"
echo
read ORACLE_SID
echo
echo Database selected is: $ORACLE_SID
echo
#check to make sure SID pass is correct, if not exit
echo $db_up|grep $ORACLE_SID
INPUT_STAT1=$?
if [ "$INPUT_STAT1" = "0" ]
then
# dO NOTHING
echo "Database name selected was good"
else
echo "Database name was NOT selected from the List Provided"
fi
I am trying to create a script that is going to ask the user executing this script a database name, so it can use proper DB on the server and dose other thingi want.
But my trouble is
1. How do i get a user to NOT just hit enter and move along(they need to type something otherwise it keeps prompt for value over and over)
2. Once they do enter something, i want that to match the DB List i provided earlier, i tried coming up with something but there is a big flaw
there. Lets say my DB list comes out as "test dev prod" and once they get to the input part and they just enter p only and not the actual prod,
it will give the good status and say "Ddatabase name selected was good"....it wont go down to the else part....how do i make sure it matches
one of the strings provided in the DB LIST....
Last edited by Don Cragun; 11-07-2013 at 03:52 PM..
Reason: Fix CODE tags.
You didn't answer my question about which version of the Korn shell you're using. If you have a 1993 or later ksh there is an easy way to do this with arrays. If you have a 1988 vintage ksh, using arrays would be more trouble that it would help. I'll be happy to write one of them for you, but I don't want to take the time to do both this afternoon.
You didn't answer my question about which version of the Korn shell you're using. If you have a 1993 or later ksh there is an easy way to do this with arrays. If you have a 1988 vintage ksh, using arrays would be more trouble that it would help. I'll be happy to write one of them for you, but I don't want to take the time to do both this afternoon.
Thanks don, i am not able to get the version, it just gives me the prompt back...
---------- Post updated at 06:01 PM ---------- Previous update was at 05:23 PM ----------
Quote:
Originally Posted by Don Cragun
You didn't answer my question about which version of the Korn shell you're using. If you have a 1993 or later ksh there is an easy way to do this with arrays. If you have a 1988 vintage ksh, using arrays would be more trouble that it would help. I'll be happy to write one of them for you, but I don't want to take the time to do both this afternoon.
If we assume that it is 1993, then how would i do this ?
I have files named with different prefixes. From each I want to extract the first line containing a specific string, and then print that line along with the prefix.
I've tried to do this with a while loop, but instead of printing the prefix I print the first line of the file twice.
Files:... (3 Replies)
Hi,
I am working on a script, which requests users to enter input.
Ex: read -p "Please enter your email id:" email
I don't want users skipping this entry, this has to be mandatory.I dont want to proceed without input.
I can do a check if variable $email is empty and proceed if not.But, i... (7 Replies)
I need to search a string for some specific text which is no big deal using grep. My problem is when the search fails to find the text. I need to add text like "na" when my search does not match.
I have tried this command but it does not work when I put the command in a loop in a bash script:
... (12 Replies)
Dear Friends,
I am looking for a shell script to merge input files into one file .. here is my idea:
1st paramter would be outfile file (all input files content)
read all input files and merge them to input param 1
ex: if I pass 6 file names to the script then 1st file name as output file... (4 Replies)
Hi
I am new to writing script and want to use a Bash Piped while-read and read from user input.
if something happens on server.log then do while loop or if something happend on user input then do while loop.
Pseudocode something like:
tail -n 3 -f server.log | while read serverline || read... (8 Replies)
Hi,
This is most likely a dumb question but I could not find answer to it elsewhere.
I'm building a simple menu with case /esac and want to read user's input:
Please enter XYZ ; read XYZ
How do I take the value of XYZ and insert it as a variable $XYZ in file file.txt ?
I may need to... (9 Replies)
I am trying to match a pattern exactly in a shell script. I have tried two methods
awk '/\<mpath${CURR_MP}\>/{print $1 $2}' multipath
perl -ne '/\bmpath${CURR_MP}\b/ and print' /var/tmp/multipath
Both these methods require that I use the escape character. I am guessing that is why... (8 Replies)
Hey everyone,
Basically, all I'm looking for is a way to regex for not a certain string. The regex I'm looking to avoid matching is:
D222
i.e. an equivalent of:
awk '!/D222/'
The problem is that I use this in the following command in a Bash script:
ls ${source_directory} | awk... (1 Reply)
how i can read a long integer from standar input and a string with as many characters as specified in the number?
i thing that i must use the read command ofcourse.... (6 Replies)
