|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Oracle pmon output needed
Post 303037523 by amar1208 on Sunday 4th of August 2019 05:25:36 AM
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
donei 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: | ||
|
Last edited by rbatte1; 08-13-2019 at 06:53 AM..
|
|
10 More Discussions You Might Find Interesting
1. Solaris
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
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
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
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
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
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
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
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
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
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
LEARN ABOUT DEBIAN
wcsremap
WCSREMAP(1) User Commands WCSREMAP(1) NAME
wcsremap - AME SYNOPSIS
remap [-vf][-a rot][[-b][-j] ra dec][-i bits][-l num] file1.fit file2.fit ... filen.fit DESCRIPTION
Remap FITS or IRAF images into single FITS image using WCS or : remap [-vf][-a rot][[-b][-j] ra dec][-i bits][-l num] @filelist -a: Output rotation angle in degrees (default 0) -b ra dec: Output center in B1950 (FK4) RA and Dec -e long lat: Output center in ecliptic longitude and latitude -f file: Use WCS from this file as output WCS -g long lat: Output center in galactic longitude and latitude -i num: Number of bits per output pixel (default is input) -j ra dec: center in J2000 (FK5) RA and Dec -l num: Log every num rows of output image -m mode: c closest pixel (more to come) -n num: integer pixel value for blank pixel -o name: Name for output image -p secpix: Output plate scale in arcsec/pixel (default =input) -s: Set BZERO and BSCALE in output file from input file -t: Number of samples per linear output pixel -u: Delete distortion keywords from output file -v: Verbose -w type: Output WCS type (input is default) -x x y: Output image reference X and Y coordinates (default is center) -y nx ny: Output image dimensions (default is first input image) wcsremap 3.8.4 June 2012 WCSREMAP(1)