Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: seeking help with shell script
Top Forums Shell Programming and Scripting seeking help with shell script Post 302140374 by Niadh on Friday 12th of October 2007 05:28:33 AM
Old 10-12-2007
Got it sussed.
The script I have is as follows from AIX 5L.
The bit i was trying to figure out is in bold. Took a bit of experimentation to get it right.

#!/usr/bin/sh
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:/usr/local/bi
n:/oracle/app/oracle/product/9.2.0/bin:.
export PATH

export DISTRIBUTION='****@*******.co.uk'

export TODAY=`date +'%d/%B/%Y'`
TNS_NAME=$1
export TNS_NAME
export ORACLE_HOME=/oracle/app/oracle/product/9.2.0
export ORAENV_ASK=NO
export warning_limit=75

PASSWORD=`grep $TNS_NAME ~oracle/dba_scripts/PASSWORDS/secure |cut -f2`
export PASSWORD

cd /oracle/dba_scripts

sqlplus /nolog <<EOF

connect system/$PASSWORD@$TNS_NAME
@/oracle/dba_scripts/percent_used1.sql
exit
EOF

export TBS_WARNINGS=`cat percent_used1.txt | awk '{print $2}'|sort -u -n -r|head -n1`
if [ $TBS_WARNINGS -ge $warning_limit ]
then
mailx -s"***CRITICAL*** Space report for "$TNS_NAME" on "$TODAY DISTRIBUTION < percent_used1.txt
else
mailx -s"Space report for "$TNS_NAME" on "$TODAY $DISTRIBUTION < percent_used1.txt

sleep 120
rm /oracle/dba_scripts/percent_used1.txt
exit 1
fi
 

9 More Discussions You Might Find Interesting

1. Filesystems, Disks and Memory

seeking a doc on lvm etc...

Hi. I wanted to increase my knowledge base with unix. can you help me find a like that talks about luns, physical volumes, volume groups, logical volumes then mountpoints? i would appreciate it thanks Jigar (1 Reply)
Discussion started by: jigarlakhani
1 Replies

2. UNIX for Dummies Questions & Answers

Seeking UNIX documentation

Hi, I am looking for documentation (PDF, DOC, books, web ...) about UNIX scripts. What could you advice me ? Thanks. (3 Replies)
Discussion started by: Filippo
3 Replies

3. UNIX for Dummies Questions & Answers

Seeking help...Urgent!!! Please help me...

Can any1 please help me answer a couple of this question? 1) What is the process management of UNIX? (single task, multitasks, etc...) 2) What is the process management of Linux? (single task, multitasks, etc...) 3) What is the type of process of UNIX? (process, thread, etc...) 4)... (1 Reply)
Discussion started by: blind02002
1 Replies

4. Shell Programming and Scripting

seeking help in text processing

Hi, I am a newbie in shell scripting. I want to get an expert help in solving a text processing issue. The issue I am facing is that, in the below log file contents I need to extract each block of lines (it could be a single line also) based on some regular expression and store it in... (8 Replies)
Discussion started by: Alecs
8 Replies

5. Shell Programming and Scripting

Seeking for help in writing shell

Hi All, I got a problem and stuck to filter a log file, called it as "sample.log". This "sample.log" file is being generated by "script A". The "sample.log" look like below: :FORMATDATE_FORMATTIME:CmdArg->:SomeDoce:SomeFormatDocument: :FORMATDATE_FORMATTIME:imprtcp succeeded.... (1 Reply)
Discussion started by: anakiar
1 Replies

6. Programming

[C] seeking good books

I suppose everybody here read reference books like Kernighan & Ritchie one, but where's the real deal? I mean I'd like to learn more about special efficient techniques, tips&tricks, what compiler effectively does, and stuff like that. Could you please suggest me some books or internet... (1 Reply)
Discussion started by: Luke Bonham
1 Replies

7. Shell Programming and Scripting

Seeking assistance in Shell script

#!/bin/bash >error_log for s in `cat s.txt` do uptime $s >>error_log echo $s >>error_log done The above code produce output with server name and its uptime in 2 different lines .My requirement is to have the same in one line . Please assist (3 Replies)
Discussion started by: vinil
3 Replies

8. Shell Programming and Scripting

Seeking help with search

Hello All, I'm looking for some help with grepping for two specific strings in files with multiple lines. For instance, I have files and the content looks like this: =====Start===== Record:1 Field 1 = aaaaaaaaaa Field 2 = bbbbbbbbbb Field 3 = 1234567890 ... (9 Replies)
Discussion started by: bbbngowc
9 Replies

9. Shell Programming and Scripting

Seeking Alternative for diff in hp

Hi , I have to use HP-unix OS to get difference between 2 files.while i tried a piece of code in other OS(linux/unix) as below, it worked fine & the output is desired one. diff --suppress-common-lines -y file_1 file_2 >d.txt The same doesn't works in HP -unix. Any help shall be... (6 Replies)
Discussion started by: vinil
6 Replies

LEARN ABOUT OPENSOLARIS

whereis

whereis(1B)					     SunOS/BSD Compatibility Package Commands					       whereis(1B)

NAME

       whereis - locate the binary, source, and manual page files for a command

SYNOPSIS

       /usr/ucb/whereis [-bmsu] [-BMS directory... -f] filename...

DESCRIPTION

       The  whereis utility locates source/binary and manuals sections for specified files. The supplied names are first stripped of leading path-
       name components and any (single) trailing extension of the form .ext, for example, .c. Prefixes of s. resulting from  use  of  source  code
       control are also dealt with. whereis then attempts to locate the desired program in a list of standard places:

	 etc
	 /sbin
	 /usr/bin
	 /usr/ccs/bin
	 /usr/ccs/lib
	 /usr/lang
	 /usr/lbin
	 /usr/lib
	 /usr/sbin
	 /usr/ucb
	 /usr/ucblib
	 /usr/ucbinclude
	 /usr/games
	 /usr/local
	 /usr/local/bin
	 /usr/new
	 /usr/old
	 /usr/hosts
	 /usr/include
	 /usr/etc

OPTIONS

       The following options are supported:

       -b    Searches only for binaries.

       -B    Changes or otherwise limits the places where whereis searches for binaries.

       -f    Terminates  the  last  directory list and signals the start of file names, and must be used when any of the -B, -M, or -S options are
	     used.

       -m    Searches only for manual sections.

       -M    Changes or otherwise limits the places where whereis searches for manual sections.

       -s    Searches only for sources.

       -S    Changes or otherwise limit the places where whereis searches for sources.

       -u    Searches for unusual entries. A file is said to be unusual if it does not have one entry of each requested type. Thus `whereis -m	-u
	     *' asks for those files in the current directory which have no documentation.

EXAMPLES

       Example 1 Finding files

       Find all files in /usr/bin which are not documented in /usr/share/man/man1 with source in /usr/src/cmd:

	 example% cd /usr/ucb
	 example% whereis -u -M /usr/share/man/man1 -S /usr/src/cmd -f *

FILES

	   o	  /usr/src/*

	   o	  /usr/{doc,man}/*

	   o	  /etc, /usr/{lib,bin,ucb,old,new,local}

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWscpu			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       chdir(2), attributes(5)

BUGS

       Since whereis uses chdir(2) to run faster, pathnames given with the -M, -S, or -B must be full; that is, they must begin with a `/'.

SunOS 5.11							    10 Jan 2000 						       whereis(1B)
All times are GMT -4. The time now is 06:54 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy