Shell Script output


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Shell Script output
# 1  
Old 10-04-2011
Shell Script output

Hi All,

Below is the shell script for which desired output is required:

Shell script:

Code:
#!/bin/bash

. /oracle/TEST/db/tech_st/11.1.0/TEST_<hostname>.env

sqlplus /nolog << EOF
connect / as sysdba
spool /home/oracle/db_output.log

@lockwait.sql

prompt Database Locks

@dba_data_files.sql

prompt Tablespace usage

EXIT;
EOF

export DBALIST="xyz@abc.com"

cd /usr/bin


Report output should print here the message "TOP Report Output"

Code:
./top c n 1 b >> /home/oracle/db_output.log


Report output should print here the message "Disk Usage Output"


Code:
df -h >> /home/oracle/db_output.log



mailx -s "TEST:Database Health Check Report" $DBALIST  < /home/oracle/db_output.log


Thanks for your time!

Regards,

a1_win

Last edited by pludi; 10-04-2011 at 09:59 AM..
# 2  
Old 10-18-2011
Is there a question? Lot all looks good to me.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Shell script to call and sort awk script and output

I'm trying to create a shell script that takes a awk script that I wrote and a filename as an argument. I was able to get that done but I'm having trouble figuring out how to keep the header of the output at the top but sort the rest of the rows alphabetically. This is what I have now but it is... (1 Reply)
Discussion started by: Eric7giants
1 Replies

2. Shell Programming and Scripting

A shell script to run a script which don't get terminated and send a pattern from the output by mail

Hi Guys, I am very new to shell script and I need your help here to write a script. Actually, I have a script abc.sh which don't get terminated itself. So I need to design a script to run this script, save the output to a file, search for a given string in the output and if it exists send those... (11 Replies)
Discussion started by: Sambit Sahu
11 Replies

3. Shell Programming and Scripting

Shell Script function to use script name for log file output

Hi Team - I"m very new to Shell Scripting so I have a rather novice question. My forte is Windows Batch Scripting so I was just wondering what the Shell Script equivalent is to the DOS command %~n? %~n is a DOS variable that dispayed the script name. For instance (in DOS): REM... (11 Replies)
Discussion started by: SIMMS7400
11 Replies

4. Shell Programming and Scripting

Customize the Shell Script output

Hello guys. about two weeks ago i had a question about customizing output and thanks to you guys i could solve it. now i have a similar question but this time its little complex. this is my output: -------------------+--------------------+---------+--------- ias-component | process-type ... (3 Replies)
Discussion started by: Ymir
3 Replies

5. Shell Programming and Scripting

how to duplicate an output in shell script

how to duplicate an output from a shell command? for example: `date` will give the current date to the console. I want this to be displayed in console and also parallely store it in file or variable. user1@solaris4:~> date Tue Feb 28 17:48:31 EST 2012 user1@solaris4:~> date > file ... (3 Replies)
Discussion started by: Arun_Linux
3 Replies

6. Shell Programming and Scripting

Shell Script to Filter Output

Hi guys - I use this script below to search for files that are of todays date. It also informs if the file doesnt exist or is old. I am trying to make the script inform of the errors in the "begining" of the output email. Such as all errors are grouped together. I am using the following... (1 Reply)
Discussion started by: DallasT
1 Replies

7. Shell Programming and Scripting

shell script no output

xxxxxx (4 Replies)
Discussion started by: vinayrao
4 Replies

8. Shell Programming and Scripting

Using output of perl script in shell

Hi, I have a perl script which prints the epoch value of given date. I want to use its output in a shell script.Can someone suggest me how to do it. Thanks and Regards Jyothi (4 Replies)
Discussion started by: jyothi_wipro
4 Replies

9. Shell Programming and Scripting

[How To?] Run shell script and get output into another shell.

Hi guys, I have a simple question, I want to store the output of the following command: As you can see it is running all the time, and we get a new line every 3sec. I just want to store these new lines into a single variable, so I can use it into a script. To clear the screen, and... (4 Replies)
Discussion started by: Thireus
4 Replies

10. Shell Programming and Scripting

Shell Script Output

I'm trying to automate numerous grep searches via shell scripting. However, the output of echo is ONE line whereas grepping from the command line would give line breaks as seen in the file. For example: test.txt: 12345 - hi 12345 - how 54321 - are 12345 - you grep output would be:... (4 Replies)
Discussion started by: sharpi03
4 Replies
Login or Register to Ask a Question