Oracle pmon output needed


Login or Register for Dates, Times and to Reply

 
Thread Tools Search this Thread
# 8  
below is my code, in below if i give invalid entry then it echo as "invalid entry" and should exit the script

Code:
#!/bin/bash
#set -x
PS3="Enter the correct DB instance: "
select CHOICE in $(ps -eo args= | awk -F"_" '/pmon/ && !/ASM/ {print $3}')
  do echo $CHOICE
break
done

# 9  
man bash:
Quote:
Any other value (not on the list of items) read causes name to be set to null

Try
Code:
  [ ! $CHOICE ] && { echo "invalid entry"; break; };

This User Gave Thanks to RudiC For This Post:
# 10  
is this correct one i have udpated ?

Code:
#set -x
PS3="Enter the correct DB instance: "
select CHOICE in $(ps -eo args= | awk -F"_" '/pmon/ && !/ASM/ {print $3}')[ ! $CHOICE ] && { echo "invalid entry"; break; }
  do echo $CHOICE
break
done

--- Post updated at 01:20 PM ---

Thanks

its working now

Code:
#!/bin/bash
#set -x
PS3="Enter the correct DB instance: "
select CHOICE in $(ps -eo args= | awk -F"_" '/pmon/ && !/ASM/ {print $3}')
 do echo $CHOICE
[ ! $CHOICE ] && { echo "You have selected invalid Database"; break; };
break
done

--- Post updated at 01:21 PM ---

Thanks

its working now

Code:
#!/bin/bash
#set -x
PS3="Enter the correct DB instance: "
select CHOICE in $(ps -eo args= | awk -F"_" '/pmon/ && !/ASM/ {print $3}')
do echo $CHOICE
[ ! $CHOICE ] && { echo "You have selected invalid Database"; break; };
break
done


Last edited by jim mcnamara; 08-03-2019 at 11:55 AM..
# 11  
The "compound command" including the break is not needed if you break out of the loop anyhow:
Code:
do echo $CHOICE
 [ ! $CHOICE ] && echo "You have selected invalid Database"
 break

But you can also run some code within the select loop, and "return" to the menu until finished with all databases.

Last edited by RudiC; 08-03-2019 at 10:56 AM..
This User Gave Thanks to RudiC For This Post:
# 12  
Code:
#set -x
PS3="Enter the correct DB instance number: "
select CHOICE in $(ps -eo args= | awk -F"_" '/pmon/ && !/ASM/ {print $3}')
 do echo $CHOICE
[ ! $CHOICE ] && { echo "You have selected invalid Database from above list"; break; };
break
done

Hi rudic
i will be selecting only 1 DB at a time, now 2nd condition is, if i select correct Db instance it should connect the DB else exit

please help

Moderator's Comments:
Mod Comment
Please wrap all code, files, input & output/errors in CODE tags as I have done for you.
It makes it far easier to read and preserves multiple spaces for indenting or fixed-width data.

Last edited by rbatte1; 4 Weeks Ago at 06:53 AM..
# 13  
Now, wouldn't that be something that you can do on your own; no - you must do on your own? No one in here knows what DB you run and how to connect to it. And even if someone knew - do you really want to be spoonfed with readymade turnkey solutions?
Login or Register for Dates, Times and to Reply

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Ps -fea | grep pmon

hello when a write this code $ ps -fea | grep pmon result: root 1515 1 0 Feb 9 ? 0:10 ipmon -sD oracle9i 18357 1 0 Feb 9 ? 1:04 ora_pmon_db1_PROD oracle9i 22830 1 0 Feb 9 ? 0:17 ora_pmon_db2_PROD oracle9i 22859 1 0 Feb 9 ? ... (4 Replies)
Discussion started by: ceciaide
4 Replies

2. Shell Programming and Scripting

Help Needed: UNIX shell variables to store Oracle table records

Hello Folks, I'm working on a requirement to automate the process of generating report(csv file) using metadata info stored in an Oracle table and E-mail it to respective people. Meta data table: Report_ID,Report_SUB_ID,Report_DB,Report_SQL,Report_to_email_Id 1,1,DEV,'select * From... (2 Replies)
Discussion started by: venkat_reddy
2 Replies

3. Shell Programming and Scripting

Help needed in formatting the output

Hi All, Need your help in resolving the below issue. I've a file called "data.txt" with the below lines: TT: <tell://me/sreenivas> <tell://me/100> <tell://me/500> TT: <tell://me/sudheer> <tell://me/300> TT: <tell://me/sreenivas> <tell://me/200> TT:... (6 Replies)
Discussion started by: raosr020
6 Replies

4. Shell Programming and Scripting

Help!! needed to get the desired output

Am in need of your help to get the desired output. nameSECURITY.SERVICES.CONFIG:GETVALUEisPrefetchedNsAccessLast2013-09-13 10:50:13 MESTsAccessTotal1sRunningcHitLastnamePUBLIC.SERVER:INVOKEisPrefetchedNsAccessLast2013-09-17 15:02:05... (5 Replies)
Discussion started by: rocky2013
5 Replies

5. UNIX for Dummies Questions & Answers

Grep output help needed

According to linux hardening guide a PATH variable must not contain . or .. so i grep the path variable using. # echo $PATH | grep "." /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin # echo $PATH | grep ".."... (2 Replies)
Discussion started by: pinga123
2 Replies

6. Shell Programming and Scripting

Help needed in retreiving records from Oracle

Hello, I am new to UNIX. My Requirement: Need to connect to Oracle database from UNIX and execute an SELECT statement and store the records in a flatfile of Comma delimiter. What I have Succeeded: I was able to connect to Oracle from UNIX. Problem: I cannot fetch multiple... (3 Replies)
Discussion started by: arunvasu2
3 Replies

7. UNIX for Dummies Questions & Answers

Help Needed with Sorting Output

Hi all, I'm using Solaris 10, and need help in sorting the below output from the syslog file in descending rather than ascending order. I would like both the hostname and message columns to be sorted, but right now only the message is sorted and the count column, whose order I would like... (2 Replies)
Discussion started by: wthomas
2 Replies

8. Shell Programming and Scripting

Help needed for shell scripting for oracle.

Hi, Please see contains both files created for automating the data from oracle through shell. 1)a_p.ksh #!/bin/ksh LOG=/home/A_P.log MESSAGE=/home/MESSAGE_A_P.txt mail_list=/home/AP_MAIL_LIST.txt data=/home/spooled_A_P.log echo "`date` Starting execution for A_P COUNT" > $LOG ... (2 Replies)
Discussion started by: fidelis
2 Replies

9. Shell Programming and Scripting

Oracle Function Needed

Dear Experts, Please find below the script in perl and can any body convert this script exactly in to oracle 9i fiunction which will return the required result same as perl. #!/usr/bin/perl $nof=@ARGV; @var2 = (); for($n=0; $n<$nof; $n++) { $filename = @ARGV; open... (3 Replies)
Discussion started by: shary
3 Replies

10. Solaris

oracle on solaris, needed urgent help, require it for exams?

Hi all, I wanted to know how to install oracle on solaris (b83).. I also would like to know of a link that i can download oracle from? please reply fast.. I need it for my exams day after tomorrow... please reply (1 Reply)
Discussion started by: wrapster
1 Replies

Featured Tech Videos