Visit Our UNIX and Linux User Community


Oracle pmon output needed


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Oracle pmon output needed
# 1  
Old 08-02-2019
Oracle pmon output needed

Code:
$ ps -ef | grep pmon | grep -v grep | awk '{ print $8 }' | cut -d '_' -f3
abc1
abc2
abc3
abc4
abc5
+ASM1

Moderator's Comments:
Mod Comment Please use code tags

from above output i am looking exclude +ASM output and restout put is fine , also when i select any output and if is invalid from above output, shell script should exit

please me out in providing the shell script

--- Post updated at 11:33 AM ---

Hi
anyone please update on it

Last edited by jim mcnamara; 08-02-2019 at 10:13 AM..
# 2  
Old 08-02-2019
someone please provide your inputs
# 3  
Old 08-02-2019
Rather that ps -ef | grep pmon | grep -v grep | awk ...... might I suggest ps -ef | grep [p]mon | ....... instead. The square brackets are a pattern match that has only one option, but because there is no grep process with this string in the process list, you can save a process and make your code clearer in one go.

If you are able to exclude +ASM, why not ignore that with a grep too?

You can probably get rid of the awk statement too by using different flags for ps, for example ps -eo args= | grep [p]mon | grep -v ASM might get you started.




I hope that this helps,
Robin
This User Gave Thanks to rbatte1 For This Post:
# 4  
Old 08-02-2019
Hi,

i am getting output as below,

Code:
$ ps -eo args= | grep [p]mon | grep -v ASM
ora_pmon_abc1
ora_pmon_abc2
ora_pmon_abc3
ora_pmon_abc4
ora_pmon_abc5


but i am looking output as below
Code:
abc1
abc2
abc3
abc4
abc5


Last edited by rbatte1; 08-13-2019 at 07:50 AM..
# 5  
Old 08-02-2019
Try
Code:
$ ps -eo args= |  awk -F"_" '/pmon/ && !/ASM/ {print $3}'
abc1
abc2
abc3
abc4
abc5

This User Gave Thanks to RudiC For This Post:
# 6  
Old 08-02-2019
Thanks Rudic


Code:
echo "======================================================"
echo "Enter the correct DB instance "
echo "======================================================"
ps -eo args= |  awk -F"_" '/pmon/ && !/ASM/ {print $3}'


################################
now from my script when i select any one of the instance from below output script should accept it, if i select wrong instance ..ie abc1111, then it should prompt like invalid entry and exit out

Code:
ps -eo args= |  awk -F"_" '/pmon/ && !/ASM/ {print $3}'
abc1
abc2
abc3
abc4
abc5


Last edited by rbatte1; 08-13-2019 at 07:51 AM..
# 7  
Old 08-02-2019
How about just not offering invalid entries? Did you consider bash's (assuming this is your shell) select statement? Like
Code:
PS3="Enter the correct DB instance: "
select CHOICE in $(ps -eo args= | awk -F"_" '/pmon/ && !/ASM/ {print $3}')
  do echo $CHOICE, $REPLY
  done
1) abc1
2) abc2
3) abc3
4) abc4
5) abc5
Enter the correct DB instance: 4
abc4, 4

Press <CTRL>D to exit the loop. Or, provide an extra item to quit.

Previous Thread | Next Thread
Test Your Knowledge in Computers #121
Difficulty: Easy
The UNIX certification mark is commercially licensed by The Open Group.
True or False?

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 output from file

Hi All, i have a file with below contents (single line) pasted below http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.grid-pnp.org/2005/11/gpnp-profile gpnp-profile.xsd" ProfileSequence="4" ClusterUId="a412e044b1986f00bfb208e0b89d90bf" ClusterName="lab1-cluster"... (3 Replies)
Discussion started by: kamauv234
3 Replies

5. 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

6. 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

7. 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

8. Shell Programming and Scripting

Output formatting help needed.

Hi guys , I have a file which contains following string.(filename tempdisplay) (location 0.0.0.0:5900) i needed to write a script which will extract the string that comes after 0.0.0.0 i.e the string :5900. I have used following method to extract the string :5900 .Is it a preferred way of... (4 Replies)
Discussion started by: pinga123
4 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