Sponsored Content
Full Discussion: Oracle pmon output needed
Top Forums Shell Programming and Scripting Oracle pmon output needed Post 303037523 by amar1208 on Sunday 4th of August 2019 05:25:36 AM
Old 08-04-2019
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; 08-13-2019 at 06:53 AM..
 

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
SbSphere(3)							       Coin							       SbSphere(3)

NAME
SbSphere - The SbSphere class is a representation of a sphere. This class is used within many other classes in Coin. It contains the data neccessary to represent a sphere (a 3D point and a radius). SYNOPSIS
#include <Inventor/SbLinear.h> Public Member Functions SbSphere (void) SbSphere (const SbVec3f &center, const float radius) void setValue (const SbVec3f &center, const float radius) void setCenter (const SbVec3f &center) void setRadius (const float radius) const SbVec3f & getCenter (void) const float getRadius (void) const void circumscribe (const SbBox3f &box) SbBool intersect (const SbLine &l, SbVec3f &intersection) const SbBool intersect (const SbLine &l, SbVec3f &enter, SbVec3f &exit) const SbBool pointInside (const SbVec3f &p) const void print (FILE *file) const Detailed Description The SbSphere class is a representation of a sphere. This class is used within many other classes in Coin. It contains the data neccessary to represent a sphere (a 3D point and a radius). See also: SbCylinder Constructor &; Destructor Documentation SbSphere::SbSphere (void) The default constructor does nothing. The center point and the radius will be uninitialized. SbSphere::SbSphere (const SbVec3f &centerarg, const floatradiusarg) Construct an SbSphere instance with the given center point and radius. Member Function Documentation void SbSphere::setValue (const SbVec3f &centerarg, const floatradiusarg) Set the sphere's center point and radius. See also: getCenter(), getRadius(). void SbSphere::setCenter (const SbVec3f &centerarg) Set the sphere's center point. See also: setValue(), setRadius() and getCenter(). void SbSphere::setRadius (const floatradiusarg) Set the sphere's radius. See also: setValue(), setCenter() and getRadius(). const SbVec3f & SbSphere::getCenter (void) const Returns an SbVec3f with the sphere's center point. See also: setCenter(), getRadius(). float SbSphere::getRadius (void) const Returns the sphere's radius. See also: setRadius(), getCenter(). void SbSphere::circumscribe (const SbBox3f &box) Make the sphere exactly contain box, i.e. the sphere center point will be the same as that of the box, and the radius will be the distance from the box center point to any of the corners. SbBool SbSphere::intersect (const SbLine &l, SbVec3f &intersection) const Finds the intersection enter point for the given line l on the sphere. If the line does not intersect the sphere, FALSE is returned. SbBool SbSphere::intersect (const SbLine &l, SbVec3f &enter, SbVec3f &exit) const Find the intersection points of the ray l on the sphere and return these in enter and exit. If the ray just 'grazes' the sphere, the enter and exit points have equal values. If the ray does not intersect the sphere, FALSE is returned, otherwise we will return TRUE. SbBool SbSphere::pointInside (const SbVec3f &p) const Returns TRUE of the given point p lies within the sphere. void SbSphere::print (FILE *fp) const Dump the state of this object to the file stream. Only works in debug version of library, method does nothing in an optimized compile. Author Generated automatically by Doxygen for Coin from the source code. Version 3.1.3 Wed May 23 2012 SbSphere(3)
All times are GMT -4. The time now is 01:19 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy