10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I want to check for "errors" or "ORA-" in Y.if there is an error then exit
Y=`sqlplus -s user/passwd<< EOF
if ; then
but this doesnt work (6 Replies)
Discussion started by: haadiya
2. Shell Programming and Scripting
Please provide Shell script to capture ORA errors from Alert Log for a given date or Current date.
-Veera (1 Reply)
Discussion started by: Veera_V
3. Shell Programming and Scripting
I have a shell script which select total count from a table and use its value in a if condition like below
tot=`sqlplus -s $connect_string << EOF
set echo off
set feedback off
set head off
select count(*) from test_table;
echo... (2 Replies)
Discussion started by: vel4ever
4. Shell Programming and Scripting
as the title says, I am after a simple script, which will open the Alert log from
an 18.104.22.168 Linux environment and mail the error message and description to a recipient email address.
I can then schedule this job via cron and let it run every 15 minutes.
I have searched online... (16 Replies)
Discussion started by: jnrpeardba
5. UNIX for Advanced & Expert Users
Hi - I am trying to grep all "ORA" errors in a log files.I have to grep all ORA errors except one error for example ORA-01653.How can exclude that error in "grep" command?
In following "grep" command I want to exclude "ORA-01653" error
grep -i ORA alert.log >>/tmp/ora_errors.txt
... (7 Replies)
Discussion started by: Mansoor8810
Am intermittently getting the following errors on one of my databases.
Errors in file /oracle/HRD/saptrace/background/hrd_psp0_13943.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302:... (1 Reply)
Discussion started by: newbie_01
7. Shell Programming and Scripting
Can anyone tell me how to get all ORA errors between two particular times in an alertlog file using shell script.
Thanks (3 Replies)
Discussion started by: suman_dba1
8. Shell Programming and Scripting
I am using Solaris 10. Some of my boxes have gnu grep and I can use -A and -B flags on those. However, the solaris flavor of grep won't use the flags -A or -B. And some of my boxes won't be getting gnu grep.
Should I try using perl, awk, or sed?
Actual PROBLEM: I am... (7 Replies)
Discussion started by: el_guero
9. UNIX for Dummies Questions & Answers
I need to automate the creation of a file. It needs to have the date of the previous day. In sqlplus we use sysdate -1 but I checked the man page for date and didn't find a similar command. This is what I use for creating a file for the current date:
What do I... (1 Reply)
Discussion started by: kskywr
10. UNIX for Advanced & Expert Users
How can I get an equivalent in unix for the following Oracle SQL command:
select sysdate - 2 from dual;
José (4 Replies)
Discussion started by: josecollantes