Sponsored Content
Full Discussion: Oracle pmon output needed
Top Forums Shell Programming and Scripting Oracle pmon output needed Post 303037479 by RudiC on Friday 2nd of August 2019 12:33:49 PM
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.
 

10 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

10. 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
bc(1)							      General Commands Manual							     bc(1)

NAME
bc - Provides a processor for arbitrary-precision arithmetic language SYNOPSIS
bc [-cl] [file...] The bc command is an interactive program that provides unlimited precision arithmetic. It is a preprocessor for the dc command. STANDARDS
Interfaces documented on this reference page conform to industry standards as follows: bc: XCU5.0 Refer to the standards(5) reference page for more information about industry standards and associated tags. OPTIONS
[Tru64 UNIX] Compiles file, but does not invoke dc. Includes a library of mathematical functions. Also sets the number of digits retained after the decimal point (the scale) to 20; by default the scale is 0. OPERANDS
Pathname of a text file containing program statements. After file has been exhausted, standard input is read. DESCRIPTION
[Tru64 UNIX] The bc command invokes dc automatically, unless the -c (compile only) option is specified. If the -c option is specified, the output from bc goes to the standard output. The bc command lets you specify an input and output base in decimal, octal, or hexadecimal (the default is decimal). The command also has a scaling provision for decimal point notation. The syntax for bc is similar to that of the C language. The bc command takes input first from the specified file. When bc reaches the end of the input file, it reads standard input. In the following description of syntax for bc, letter means one of the letters a-z. Comments Comments are enclosed in /* and */. Names Simple variables: letter Array elements: letter[expression] The words ibase, obase, and scale Other Operands Arbitrarily long numbers with optional sign and decimal point. Number of significant decimal digits Number of digits to right of decimal point Operators + - * / % ^ (% is remainder; ^ is power) ++ -- (prefix and suffix; apply to names) == <= >= != <> = =+ =- =* =/ =% ^= += -= *= /= %= Statements expression {statement;...;statement} if (expression) statement while (expression) statement for (expression;expression;expression) statement (null statement) break quit Function Definitions define letter ( letter,...,letter ) { auto letter,...,letter statement;...statement return ( expression ) } Functions in -l Math Library sine cosine exponential log arctangent Bessel function General Syntax All function parameters are passed by value. The value of a statement that is an expression is displayed, unless the main operator is an assignment. A semicolon or newline character separates statements. Assignments to scale control the number of decimal places printed on output and maintained during multiplication, division, and exponentiation. Assignments to ibase or obase set the input and output number radix, respectively. The same letter may refer to an array, a function, and a simple variable simultaneously. All variables are global to the program. Auto- matic variables are pushed down during function calls. When you use arrays as function parameters, or define them as automatic variables, empty brackets must follow the array name. All for statements must have all three expressions. The quit statement is interpreted when read, not when executed. EXIT STATUS
The following exit values are returned: Successful completion. An error occurred. EXAMPLES
When you enter bc expressions directly from the keyboard, press the End-of-File key sequence to end the bc session and return to the shell command line. To use bc as a calculator, proceed as follows: Enter: $ bc 1/4 The system responds as follows: 0 Enter: scale = 1 /* Keep 1 decimal place */ 1/4 The system responds as follows: 0.2 Enter: scale = 3 /* Keep 3 decimal places */ 1/4 The system responds as follows: 0.250 Enter: 16+63/5 The system responds as follows: 28.600 Enter: (16+63)/5 The system responds as follows: 15.800 Enter: 71/6 The system responds as follows: 11.833 Enter: 1/6 The system responds as follows: 0.166 You may type the comments (enclosed in /* */), but they are provided only for your information. The bc command displays the value of each expression when you press <Return>, except for assignments. To convert numbers from one base to another, proceed as follows: Enter: bc obase = 16 /* Display numbers in Hexadecimal */ ibase = 8 /* Input numbers in Octal */ 12 The system responds as follows: A Enter: 123 The system responds as follows: 53 Enter: 123456 The system responds as follows: A72E To write and run C-like programs, proceed as follows: Create the following file prog.bc: /* compute the factorial of n */ define f(n) { auto i, r; r = 1; for (i=2; i<=n; i++) r =* i; return (r); } Enter: bc -l prog.bc This interprets the bc program saved in prog.bc, then reads more bc command statements from standard input (the keyboard). Starting the bc command with the -l option makes the math library available. This example uses the e (exponential) function from the math library, and f is defined in the program prog.bc. Enter: e(2) /* e squared */ The system responds as follows: 7.38905609893065022723 Enter: f(5) /* 5 factorial */ The system responds as follows: 120 Enter: f(10) /* 10 factorial */ The system responds as follows: 3628800 The statement following a for or while statement must begin on the same line. To convert an infix expression to Reverse Polish Notation (RPN), enter: Enter: bc -c (a * b) % (3 + 4 * c) The system responds as follows: lalb* 3 4lc*+%ps. This compiles the bc infix-notation expression into one that the dc command can interpret. The dc command evaluates extended RPN expressions. In the compiled output, the lowercase l before each variable name is the dc subcommand to load the value of the vari- able onto the stack. The p displays the value on top of the stack, and the s. discards the top value by storing it in register . (dot). You can save the RPN expression in a file for dc to evaluate later by redirecting the standard output of this command. ENVIRONMENT VARIABLES
The following environment variables affect the execution of bc: Provides a default value for the internationalization variables that are unset or null. If LANG is unset or null, the corresponding value from the default locale is used. If any of the internationalization vari- ables contain an invalid setting, the utility behaves as if none of the variables had been defined. If set to a non-empty string value, overrides the values of all the other internationalization variables. Determines the locale for the interpretation of sequences of bytes of text data as characters (for example, single-byte as opposed to multibyte characters in arguments). Determines the locale for the for- mat and contents of diagnostic messages written to standard error. Determines the location of message catalogues for the processing of LC_MESSAGES. FILES
Mathematical library. Desk calculator proper; uses bc as preprocessor. SEE ALSO
Commands: awk(1), dc(1) Standards: standards(5) bc(1)
All times are GMT -4. The time now is 10:03 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy