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 SUNOS

evolution-addressbook-export

evolution-addressbook-export(1) 				   User Commands				   evolution-addressbook-export(1)

NAME

       evolution-addressbook-export - export local address book from Ximian Evolution, Sun Microsystems Edition

SYNOPSIS

       evolution-addressbook-export  [--async] [--format=[vcard|csv]] [--help] [--list-addressbook-folders] [--output=output-file] [--size=number]
       [--usage] [--version]

DESCRIPTION

       Export the local address book to a file.

OPTIONS

       The following options are supported:

       --async		       Export in asynchronous mode. You can also use -a to specify this option.

       --format=[vcard|csv]    Specify the export format:  virtual card (vcard) or comma-separated value (csv).

       --help		       Display help text. You can also use -? to specify this option.

       --list-addressbook-foldeList the local address-book folders. You can also use -l to specify this option.

       --output=output-file    Specify the name of the output file to store the exported information. If no output file is specified, the exported
			       information is sent to standard output.

       --size=number	       Specify the number of cards in one output file in asychronous mode. The default value is 100.

       --usage		       Display brief usage text.

       --version	       Display version information.

EXAMPLES

       Example 1: Exporting Local Address Book in Asynchronous Mode and Vcard Format to contacts.vcf

       example% evolution-addressbook-export -a --format=vcard --output=contacts.vcf

EXIT STATUS

       The following exit values are returned:

       0	Application exited successfully

       1	Application exited with failure

FILES

       The following files are used by this application:

       /usr/bin/evolution-addressbook-export

	   Executable to export Evolution local address book

       $HOME/evolution

	   Per-user configuration files and local storage for Evolution

       $HOME/evolution/mail/account/folders

	   Temporary files for Evolution mail

       $HOME/evolution/sunone/account/folders

	   Temporary files for Evolution Sun ONE account

ATTRIBUTES

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

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Architecture		     |SPARC			   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWevo			   |
       +-----------------------------+-----------------------------+
       |CSI			     |Enabled			   |
       +-----------------------------+-----------------------------+
       |Interface stability	     |Standard			   |
       +-----------------------------+-----------------------------+
       |MT-Level		     |MT safe with Exceptions	   |
       +-----------------------------+-----------------------------+

SEE ALSO

       Ximian Evolution Sun Microsystems Edition User Guide

       evolution(1), evolution-address-import(1)

NOTES

       Written by Steven Zhang, Sun Microsystems Inc., 2004.

SunOS 5.10							    15 Apr 2004 				   evolution-addressbook-export(1)
All times are GMT -4. The time now is 02:57 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy