Extracting Sysdate-1 ORA Errors - Can you help me in this UNIX Script? Post: 302794405

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Getting sysdate - 2 by an unix command

How can I get an equivalent in unix for the following Oracle SQL command: select sysdate - 2 from dual; Thanks Jos�

2. UNIX for Dummies Questions & Answers

sysdate -1 in unix

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: rciind`date '+%m%d%Y'`.txt What do I...

3. Shell Programming and Scripting

Unix shell script (grep -A 6 -B 2 "ORA-" filename

BACKGROUND: 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...

4. Shell Programming and Scripting

How to get ORA errors in alertlog file using shell script.

Hi, Can anyone tell me how to get all ORA errors between two particular times in an alertlog file using shell script. Thanks

5. Solaris

maxuprc and maxusers - ORA-27300, ORA-27301, ORA-27302

Hi all, 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:...

6. UNIX for Advanced & Expert Users

grep all ORA errors except one ORA error

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. Shell Programming and Scripting

Shell script to capture ORA errors from Alert Log

Hi, as the title says, I am after a simple script, which will open the Alert log from an 11.2.0.1 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...

8. Shell Programming and Scripting

How to turn off ora errors in shell script?

I have a shell script which select total count from a table and use its value in a if condition like below connect_string="username/password@tnsname" tot=`sqlplus -s $connect_string << EOF set echo off set feedback off set head off select count(*) from test_table; EOF ` if then echo...

9. Shell Programming and Scripting

Shell script to capture Current day ORA errors from Alert Log

Please provide Shell script to capture ORA errors from Alert Log for a given date or Current date. -Veera

10. Shell Programming and Scripting

Check for �errors� or �ORA-�

I want to check for "errors" or "ORA-" in Y.if there is an error then exit Y=`sqlplus -s user/passwd<< EOF exec test_Proc; exit; EOF` if ; then exit 1 fi but this doesnt work

LEARN ABOUT DEBIAN

synce-pmv

PMV(1)							   http://synce.sourceforge.net/						    PMV(1)

NAME

       pmv - move (rename) files

SYNOPSIS

       pmv [- LEVEL] [-p DEVNAME] [-h] SOURCE DESTINATION

DESCRIPTION

       pmv renames or moves a file on a device connected through SynCE.

       Forward slashes ('/') on the command line are converted to backward slashes ('').

OPTIONS

       -d LEVEL
	      Set debug log level:

	      0 - No logging (default)

	      1 - Errors only

	      2 - Errors and warnings

	      3 - Everything

       -p DEVNAME
	      Use the device with the given name, instead of the default.

       -h     Display help message.

       SOURCE Full path to the current filename.

       DESTINATION
	      Full path to the new filename.

AUTHOR

       This manual page was written by David Eriksson <twogood@users.sourceforge.net>.

SEE ALSO

       synce(1) pcp(1) pls(1) prm(1) pmkdir(1) prmdir(1)

The SynCE project						   November 2002							    PMV(1)

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Getting sysdate - 2 by an unix command

Discussion started by: josecollantes

2. UNIX for Dummies Questions & Answers

sysdate -1 in unix

Discussion started by: kskywr

3. Shell Programming and Scripting

Unix shell script (grep -A 6 -B 2 "ORA-" filename

Discussion started by: el_guero

4. Shell Programming and Scripting

How to get ORA errors in alertlog file using shell script.

Discussion started by: suman_dba1