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

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Problem with shell script...ORA-00904:invalid identifier

Guys, Please suggest me what's wrong with this script? #!/usr/bin/sh ############################################################################## # Author : Bhagat Singh # # # Date : Nov 13,2006 #...

2. UNIX for Dummies Questions & Answers

Shell Script --- Delete ORA error from data file

Hi All, I have to make the following changes in shell script: When the data file is being created, an �ORA� error occurs in it. I have to remove this ORA error from data file and put it in log file. I am � -n grip command� to find the ORA error and get the line number, How do I delete it...

3. Shell Programming and Scripting

how to copy an alertlog file from a particular time stamp?

Hi, Can any one tell me how to copy an alertlog file from a particular time stamp using shell script? Thanks

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

5. 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 ...

6. 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...

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

8. Shell Programming and Scripting

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

Hi Guys, I wanted to create an Unix Shell Script that should fetch a particular string from a text file on a particular date. We all know Oracle generates alert logs for each and every day for every actions in the database. I have an alert log file now where it contains for about a months...

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 HPUX

cachefswssize

cachefswssize(1M)														 cachefswssize(1M)

NAME

       cachefswssize - determine working set size for cachefs

SYNOPSIS

       logfile

DESCRIPTION

       The command displays the workspace size determined from logfile.  This includes the amount of cache space used by each filesystem using the
       same cachedir and the total cache space used by all the filesystems using the same cachedir.  Optionally, it also displays  the	operations
       that are logged in the logfile.

       The logfile generated by the command is used by for reporting these statistics.

   Options
       recognizes the following option:

       Display the data in the logfile in ASCII format.
		 This option is used for debugging purposes only.

RETURN VALUE

       returns the following values:

	      Success.

	      non-zero	An error occurred.

EXAMPLES

       Following is sample output:

	      cachefswssize /var/tmp/samlog
		   /home/sam
						  end size:		  10688k
					   high water size:		  10704k

		   /foo
						  end size:		    128k
					   high water size:		    128k

		   /usr/dist
						  end size:		   1472k
					   high water size:		   1472k

		   total for cache
					      initial size:		 110960k
						  end size:		  12288k
					   high water size:		  12304k

       Following is an example using with the option:

AUTHOR

       was developed by Sun Microsystems, Inc.

SEE ALSO

       cachefslog(1M), cachefsstat(1M), cfsadmin(1M).

																 cachefswssize(1M)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Problem with shell script...ORA-00904:invalid identifier

Discussion started by: bhagat.singh-j

2. UNIX for Dummies Questions & Answers

Shell Script --- Delete ORA error from data file

Discussion started by: sk005

3. Shell Programming and Scripting

how to copy an alertlog file from a particular time stamp?

Discussion started by: suman_dba1

4. Solaris

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

Discussion started by: newbie_01