Sponsored Content
Top Forums UNIX for Advanced & Expert Users grep all ORA errors except one ORA error Post 302469373 by ctsgnb on Friday 5th of November 2010 04:46:19 PM
Old 11-05-2010
Code:
grep ORA alert.log | grep -v ORA-01653

Code:
[ctsgnb@shell ~]$ cat alert.log
blablablablabalbala
ORA-01555 blablablabla
blablablablabalbala
ORA-01653 blablablabla
blablablablabalbala
ORA-01234 blablablabla
ORA-09430215 blablablabla
ORA-01653 blablablabla
blablablablabalbala
blablablablabalbala
blablablablabalbala
ORA-09415 blablablabla
[ctsgnb@shell ~]$ grep ORA alert.log|grep -v ORA-01653
ORA-01555 blablablabla
ORA-01234 blablablabla
ORA-09430215 blablablabla
ORA-09415 blablablabla
[ctsgnb@shell ~]$

 

10 More Discussions You Might Find Interesting

1. 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 (3 Replies)
Discussion started by: suman_dba1
3 Replies

2. 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:... (1 Reply)
Discussion started by: newbie_01
1 Replies

3. HP-UX

ORA-27300 error because of hp ux

Dear All, i am not able to start the 9i oracle database because of the following problems. I log in into unix and then into sqlplus export oracle_sid=SATEST startup nomount i am getting the following errors ORA-27300: OS system dependent operation:semget failed with... (3 Replies)
Discussion started by: alokpattar
3 Replies

4. 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... (16 Replies)
Discussion started by: jnrpeardba
16 Replies

5. HP-UX

ORA-06512 Error in Oracle 10g

HI All , I am using oracle 10g and HP AIX . I am getting the below error while running the package. ORA-29280: invalid directory path ORA-06512: at "SYS.UTL_FILE", line 41 ORA-06512: at "SYS.UTL_FILE", line 478 ORA-06512: at "DW_APP.PKG_ASS_FVC", line 595 ORA-06512: at line 2 ... (4 Replies)
Discussion started by: Perlbaby
4 Replies

6. 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... (2 Replies)
Discussion started by: vel4ever
2 Replies

7. 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... (4 Replies)
Discussion started by: raja_dba
4 Replies

8. 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 (1 Reply)
Discussion started by: Veera_V
1 Replies

9. 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 (6 Replies)
Discussion started by: haadiya
6 Replies

10. Red Hat

Ora-27603:ora-27626:

Hi, User claim that job is running slow from their end. I DBA found in database the below errors in alert log file. ORA-27603: Cell storage I/O error, I/O failed on disk o/192.168.10.3/RECO_DM01_CD_01_drm01 at offset 13335789568 for data length 1048576 ORA-27626: Exadata error: 2201 (IO... (2 Replies)
Discussion started by: Maddy123
2 Replies
P10CFGD(1)						      General Commands Manual							P10CFGD(1)

NAME
p10cfgd - remote configuration daemom for Gracilis PackeTen SYNOPSIS
p10cfgd [IP_PORT] COPYRIGHT
Copyright (c) 1993 by Colorado Digital Eclectics (CODE) All rights reserved. DESCRIPTION
Rmtcfgd is a server program used to send configuration files to a Gracilis PackeTen. It can be run in background or it can be run by inetd. If p10cfgd is to be run by inetd, add the following line to /etc/services rmtcfg 1236/tcp # Remote Configuration of PackeTen and add the following to /etc/inetd.conf # Remote configuration service for PackeTen rmtcfg stream tcp nowait root /usr/bin/p10cfgd p10cfgd P10cfgd normally does not require the IP_PORT parameter. It listens for connections on IP Port 1236 as a default. The program will send on a line by line basis the file requested by the client that connects on the IP Port. The only expected input from the client is the file name. When the file has been sent, the connection is closed. The requested file must be in the directory /etc/p10cfgd. Rmtcfgd maintains a log of its activity in the file /var/log/p10cfgd.log. Program startup and all connections are logged in the file with GMT time stamps. The file is opened in append mode. The protocol used by the PackeTen is very simple. The PackeTen opens a tcp connection to port 1236 on a host system. Once the connection is made, the PackeTen sends the name of the file it wants to the host. The host then opens the file and sends it line by line to the Pack- eTen until all lines have been sent. The files to be transfered must be plain text files and each line must have at least one character in addition to the newline at the end. P10cfgd replaces all blank lines with lines that contain two spaces. If you wish to send a blank line, to stop loading of part of a LocalInfo file for example, place an underscore '_' at the begining of the line. The entire contents of the line will be deleted and a blank line will be sent to the client. At the end of the file, the server sends a time command ( time MMD- DYYHHMM ) with the UTC time on the server. This will either set the time on the PackeTen or add a time stamp to the LocalInfo file. The server then closes the connection. The remote configuration command used on the PackeTen is rmtcfg <server_host> <filename> [options] The valid options are -t <timeout in seconds> default is 60 sec -p <IP port #> default is 1236 -i the file is for LocalInfo -h <secondary server> if the primary does not answer The rmtcfg commands would be placed in to the EEPROM on the PackeTen so that they would be executed during a reboot. The information stored in the EEPROM should include enough information to set the PackeTen up to allow communications with the primary and the secondary server. This would include commands to set MYCALL and the IP_ADDRESS, to attach an interface to the channel with the server, routing information and so forth. A sample EEPROM configuration for a PackeTen, empire.wd0fhg.ampr.org [44.32.0.32], that gets its configuration from a remote system winfree.n3eua.ampr.org [44.32.0.2], over a 9600 baud ax25 path would be: # first the general setup of the PackeTen ee hostname gw.wd0fhg ee sitename empire ee ipaddr 44.32.0.32 ee mycall WD0FHG # Then we attach a 9600 ax25 interface as ax1 ee attach sync302 1 hdx ax25 ax1 8192 256 9600 ext ext nrzi # and set the default route to send every thing out ax1 ee route add default ax1 44.32.0.1 ee password sure-thing # # Now we will ask for the remainder of the setup # from the server winfree.n3eua.ampr.org [44.32.0.2] # Note that we have a secondary server available at # [44.20.0.195] that would be used if winfree is down. # first the Local Information file ee com 0 rmtcfg 44.32.0.2 empire.info -i -h 44.20.0.195 # and then the remaining configuration command file ee com 1 rmtcfg 44.32.0.2 empire.cfg -h 44.20.0.195 # ee save # end-of-eeprom setup Rmtcfgd started life as the simple server program in PERL by Larry Wall and R.L. Schwartz published by ORA,Inc. ENVIRONMENT
No environment variables are used. FILES
/etc/p10cfgd/* - files that can be accessed remotely /var/log/p10cfgd.log - p10cfgd log file AUTHOR
John Conner, WD0FHG, conner@empire.com hacked on by Bdale Garbee, N3EUA, bdale@gag.com. SEE ALSO
Gracilis, Inc. PackeTen Manual and NOS User's Manual DIAGNOSTICS
Complains if it can't open a file to remote client and to log file. 7th Edition July 29, 1993 P10CFGD(1)
All times are GMT -4. The time now is 05:33 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy