07-21-2006
Hi Pankaj,
Answer of 2nd point is yes you can do that in shell script...have a look at code below..from this script you can check if err_message have some value in it then there is a oracle error.And if there is no value in that variable you can run the script....that can be done by IF THEN ELSE.......
Z=`sqlplus -s user/password@host <<eof
set serveroutput on;
declare
v_message varchar2(1000);
v_value number;
begin
select column into v_value from tablename where rownum<2;
EXCEPTION
WHEN OTHERS THEN
v_message := SQLERRM;
dbms_output.put_line(v_message);
END;
/
EXIT;
eof`
err_message=`echo "$Z" | grep "ORA-"`
echo $err_message
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I'm trying to write shell script that when invoke, has 2 arguements, or 1.
If there's one arguement, then that's the process name. If there's 2, then one is the timeout.
USAGE: Assign1.sh <process> <timeout>
If no timeout was set, then the default timeout is 15 minutes.
So after it read the... (6 Replies)
Discussion started by: NoobieBoobie
6 Replies
2. AIX
Hi all,
In my script i need to store the process ID of my app server in a variable. I know how to verify whether a process is running, by following:
ps -ef|grep 'jboss'
status=$?
if ; then
# process is running
else
# process is nor running
fi
But what I need here... (11 Replies)
Discussion started by: haroon_a
11 Replies
3. Shell Programming and Scripting
Hi Experts, we do have a shell script for Unix Solaris, which will kill all the process manullay, it used to work in my previous env, but now it is throwing this error.. could some one please help me to resolve it
This is how we execute the script (and this is the requirement) ... (2 Replies)
Discussion started by: jonnyvic
2 Replies
4. Shell Programming and Scripting
Hi, I am looking for a solution for the following problem:
Im Using tcpdump within a shellskript started in a subshell by using brackets: ( /usr/sbin/tcpdump -i ... -c 1 )
- I want the outout of tcpdump saved in a variable
- Than tcpdump-Process in the Subshell should be killed
- and I... (6 Replies)
Discussion started by: 2retti
6 Replies
5. Shell Programming and Scripting
Hello,
I would like a to have an script that would accept variables for "foruser" and "touser" during an db import..
I am pasting an sample script below...
The "and" in the below script needs to changed..to a correct syntax
for i in `cat /tmp/from` and for j in `cat /tmp/to`
do
{... (2 Replies)
Discussion started by: jjoy
2 Replies
6. Shell Programming and Scripting
Hi,
I am writing a shell script to run a process and write the output of the process to a file.
Inside program.sh:
./process.sh > tempfile
..
open tempfile
do the following
But the problem is that process.sh is running indefinitely and program.sh is not executed completely. Can... (4 Replies)
Discussion started by: dreamgirl314
4 Replies
7. Shell Programming and Scripting
Im having a bit of troble coming up with a script that does this monitors processes to see if they die, if they do die, restart the process
and write out to a log file that the process was restarted with the new PID and the date and time the new process was launched.
Any suggestions? (1 Reply)
Discussion started by: jspinal
1 Replies
8. Shell Programming and Scripting
Hi All,
I have a shell script in Linux and it will be invoked by 2 methods,
1) An automated background process .
2) Logining into the box and directly executing the script.
I need to put a validation in my shell script such that it will be executed successfully on when an... (11 Replies)
Discussion started by: vininx
11 Replies
9. Red Hat
hey , i have to write a script to run a process through shell script and if the process runs successfully then return success.
i used nohup to start the process but nothing occured .
#!/bin/sh
nohup ./cvt -f MediationSources.xml &
can anyone pls help me
Thanks (3 Replies)
Discussion started by: ramsavi
3 Replies
10. Shell Programming and Scripting
Hi
I have one doubt while calling a shell scripts from another shell script.
suppose i have two shell script abc.sh and xyz.sh
i call many instance of xyz.sh in abc.sh when i look at process id's using ps command i can see process ids for abc.sh command bur not a single process id of xyz.sh.... (2 Replies)
Discussion started by: AnkitMogha
2 Replies
script(1) General Commands Manual script(1)
NAME
script - Makes a transcript of terminal session
SYNOPSIS
script [-a] [file]
The script command makes a transcript of everything printed on your terminal.
OPTIONS
Appends the transcript to file rather than writing it to file.
OPERANDS
The name of an output file that will contain the transcript of the session. If this parameter is omitted, the file typescript is written.
DESCRIPTION
The transcript is written to file, or appended to file if the -a option is given. If no file name is given, the transcript is saved in the
file typescript.
The script ends when the forked shell exits.
This program is useful when you are using a CRT and want a hard-copy record of the dialog (for example, a technical writer might create an
example of a working session this way).
If you specify the -a option and the file does not exist, it is created.
If you do not specify the -a option and the file exists, it is replaced.
RESTRICTIONS
The script command requires a streams based terminal. In single user mode, streams may not be enabled. Under these circumstances, script
will exit with no action. If you are the superuser and need to run this command in single user mode, use the following special instruc-
tions.
Enabling Streams
If it is necessary to enable a streams environment in the single user mode, enter the command /sbin/init.d/streams. This command is avail-
able to the superuser only.
SEE ALSO
Commands: autopush(8), cat(1), echo(1), strsetup(8), tee(1)
System Administration
script(1)