02-03-2015
Run a sql script on multiple $Oracle_SID at once and send an alert if reaches the threshold
I am trying to accomplish following tasks in my KSH script:
- Run a sql script on multiple $ORACLE_SID at once
- Sends an alert only if the threshold > 2 for any of the $ORACLE_SID
Please advice as to how I can approach this!!
Thanks in advance!
Last edited by rbatte1; 02-04-2015 at 06:32 AM..
Reason: Converted to LIST=1 tags
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi i want to know how can i write a script to check if any changes are made and send an alert in crontabs . i am using .ksh file extension for writing scripts. (3 Replies)
Discussion started by: honey26
3 Replies
2. HP-UX
I have an issue with one of the processes which is showing %cpu over 120% when i issue the top command. I am looking for a script that send me an email alert when it crosses the 90% thresholds.
Appreciate your help (1 Reply)
Discussion started by: chkaiban
1 Replies
3. Shell Programming and Scripting
Hi
Can someone assist in writing a script.
I have a filesystem named /sybase in my aix lpar.
When this filesystem becomes 94% full all the files and directories under /sybase/logs should be deleted immediately. :confused: (7 Replies)
Discussion started by: newtoaixos
7 Replies
4. Shell Programming and Scripting
Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database.
I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :(
What should I do? I'm not sure that... (2 Replies)
Discussion started by: Kapom
2 Replies
5. Shell Programming and Scripting
Thanks again for helping me out.
I was wondering if anyone else has encountered this issue.
I have a SQL script that produces a list -however we are only interested in that list if the length is not zero
Here is the sql file named dailyBalance.sql
select * from Balance where... (1 Reply)
Discussion started by: Astrocloud
1 Replies
6. Shell Programming and Scripting
Hello All,
I need immediate help in creating shell script to call archivebkup.ksh script when archive file system capacity reaches threshold value or 60%
Need to identify the unique file system that reaches threshold value.
ex:
capacity
... (4 Replies)
Discussion started by: sasikanthdba
4 Replies
7. Shell Programming and Scripting
Hi Experts,
I have a list of Dbs.In that DBs i need to execute some sql scripts.
each sql script is unique and it should run on particular DB only.
For example. i have DBs like MDC20V,NDC20V,ODC20V and sql scripts like MD.sql,ND.sql,OD.sql.so MD.sql should run only in MDC20V and ND.sql should... (1 Reply)
Discussion started by: navsan420
1 Replies
8. Shell Programming and Scripting
HI Guys,
I am writing one shell script to send the mail alert to some email id's if the file not modified in last 10 mins but its not working, I believe MTIME is null string is wrong . can you please assist me on this.
script :-
filename="abc.txt"
echo "Filename is $filename"... (1 Reply)
Discussion started by: abhigrkist
1 Replies
9. UNIX for Beginners Questions & Answers
Hi
I have below shell script to send mail alert , however I want to add more functionality in this script and that is , script should only check that file between 9 am to 5pm , and if there is no activity in this time 9 am to 5 pm for 2hours then it should give me mail alert, please help... (2 Replies)
Discussion started by: scazed
2 Replies
10. UNIX for Beginners Questions & Answers
Hi All,
need your help , i have some files and got some below condition
cat tdr12009.log | grep -i success | grep promo | awk -F'' '{print substr($1,1,16),$15}' | more
2019-10-16 00:03 delta=1
2019-10-16 00:03 delta=2
2019-10-16 00:04 delta=20
2019-10-16 00:09 delta=10
2019-10-16... (5 Replies)
Discussion started by: fajar_3t3
5 Replies
IDLE(1) General Commands Manual IDLE(1)
NAME
IDLE - An Integrated DeveLopment Environment for Python
SYNTAX
idle [ -dins ] [ -t title ] [ file ...]
idle [ -dins ] [ -t title ] ( -c cmd | -r file ) [ arg ...]
idle [ -dins ] [ -t title ] - [ arg ...]
DESCRIPTION
This manual page documents briefly the idle command. This manual page was written for Debian because the original program does not have a
manual page. For more information, refer to IDLE's help menu.
IDLE is an Integrated DeveLopment Environment for Python. IDLE is based on Tkinter, Python's bindings to the Tk widget set. Features are
100% pure Python, multi-windows with multiple undo and Python colorizing, a Python shell window subclass, a debugger. IDLE is cross-plat-
form, i.e. it works on all platforms where Tk is installed.
OPTIONS
-h Print this help message and exit.
-n Run IDLE without a subprocess (see Help/IDLE Help for details).
The following options will override the IDLE 'settings' configuration:
-e Open an edit window.
-i Open a shell window.
The following options imply -i and will open a shell:
-c cmd Run the command in a shell, or
-r file
Run script from file.
-d Enable the debugger.
-s Run $IDLESTARTUP or $PYTHONSTARTUP before anything else.
-t title
Set title of shell window.
A default edit window will be bypassed when -c, -r, or - are used.
[arg]* and [file]* are passed to the command (-c) or script (-r) in sys.argv[1:].
EXAMPLES
idle Open an edit window or shell depending on IDLE's configuration.
idle foo.py foobar.py
Edit the files, also open a shell if configured to start with shell.
idle -est "Baz" foo.py
Run $IDLESTARTUP or $PYTHONSTARTUP, edit foo.py, and open a shell window with the title "Baz".
idle -c "import sys; print sys.argv" "foo"
Open a shell window and run the command, passing "-c" in sys.argv[0] and "foo" in sys.argv[1].
idle -d -s -r foo.py "Hello World"
Open a shell window, run a startup script, enable the debugger, and run foo.py, passing "foo.py" in sys.argv[0] and "Hello World" in
sys.argv[1].
echo "import sys; print sys.argv" | idle - "foobar"
Open a shell window, run the script piped in, passing '' in sys.argv[0] and "foobar" in sys.argv[1].
SEE ALSO
python(1).
AUTHORS
Various.
21 September 2004 IDLE(1)