Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

alert_oss.log oracle log file in hp-unix

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting alert_oss.log oracle log file in hp-unix
# 1  
Old 04-27-2007
alert_oss.log oracle log file in hp-unix
Hi
I have go this alert_oss.log that is basically capturing all the oracle errorlogs.Now the problem is that it is one huge file and to see log of some particular date i tried
cat alert_oss.log | grep 'Mar 25 10:44:45 2007' > alert_25.txt
is not giving me the required output.
pls suggest

rgds
assassin
# 2  
Old 04-29-2007
Well, if you try to do a grep for a specific date and time, then thats what is going to happen. Try leaving the timestamp out of the grep and just grep for "Mar 25" to see what happens. Also, do not redirect the output to a file yet (not till you've found the pattern that gets the data you want).
# 3  
Old 05-01-2007
hi
i tried with the grep it gives me the output
MAR 25 14:00:00 2007
MAR 25 14:00:052007
MAR 25 14:00:07 2007

but i am not getting the file to read errors, after every execution of oracle it archives and inserts into this file now to read this file from particular date that is what want.After each execution in one line it gives the output format like above.

rgds
assasssin
# 4  
Old 05-01-2007
Not getting what you want to do exactly. Can you post a few lines from the file? Post the lines you want extracted from those as well.

Also, this post is not HP-UX specific, so I am moving it to the scripting section.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Ksh: How to write the log file simultaneously when .sql file executes by UNIX process

Hello Team- we would like to implement an approach which has to write the log file simultaneously when .sql file is executing by Unix process. At present,it is writing the log file once the process is completed. I've tested the current process with the below approaches and none of them... (1 Reply)
Discussion started by: Hima_B
1 Replies

2. Shell Programming and Scripting

How to print logs in unix prompt or to a log file?

I am executing a stored procedure through shell script. In the procedure, i have dbms_output.put_line to log the comments. This is working fine and but logs are available only after the execution of the pl/sql procedure's completion. I want to print the log comments while executing the procedure... (2 Replies)
Discussion started by: vel4ever
2 Replies

3. Shell Programming and Scripting

Capture all error message in Log file and send the Log file by email

Hi I have a requirement to write a script to capture all errors in a Logfile and send the file in email. If there is any error occurred the subject of email will be ERROR , If there are no error occurred the subject of email will be SUCCESS. So I created a Log file and put the Appropriate... (2 Replies)
Discussion started by: dgmm
2 Replies

4. Shell Programming and Scripting

Need help in retrieving log from a UNIX file using the search patterns

Hi everyone, I am trying to retrieve certain log from a big file. The log size can be from 200 - 600 lines. I have 3 search patterns, out of which 2 (first and last lines) search patterns are common for all the transactions but 3rd search pattern (occurs in the middle of transaction) is... (5 Replies)
Discussion started by: msrayudu
5 Replies

5. Shell Programming and Scripting

Delete log file entries based on the Date/Timestamp within log file

If a log file is in the following format 28-Jul-10 ::: Log message 28-Jul-10 ::: Log message 29-Jul-10 ::: Log message 30-Jul-10 ::: Log message 31-Jul-10 ::: Log message 31-Jul-10 ::: Log message 1-Aug-10 ::: Log message 1-Aug-10 ::: Log message 2-Aug-10 ::: Log message 2-Aug-10 :::... (3 Replies)
Discussion started by: vikram3.r
3 Replies

6. Shell Programming and Scripting

Unix script help to read log file

Hi I have a big log file :08,936 DEBUG HttpConnectionManager.getConnection: config = 11:39:08,936 DEBUG Getting free connection, 11:39:08,989 DEBUG Freeing connection, hostConfig=HostConfiguration 11:39:08,989 DEBUG Notifying no-one, there are no waiting threads 11:39:09,046... (4 Replies)
Discussion started by: javaholics
4 Replies

7. Shell Programming and Scripting

How to convert a .log file into .txt file under unix??

Hi Friends, I have a .log file generated from a tool(Windows PC) which can be opened using a notepad, but when I tried to view the file in unix (cygwin on my laptop) the file type is showing as binary file, So I am unable to process the file. I need to extract some of the selected text... (3 Replies)
Discussion started by: ks_reddy
3 Replies

8. HP-UX

how to redirect the growing contents of log file to another file in unix

how to redirect the growing contents of log file to another file in unix (2 Replies)
Discussion started by: megh
2 Replies

9. UNIX for Advanced & Expert Users

unix log file

Hi I want to know where the unix log file is stored I couldnt fınd anythıng under var/log directory Regards (8 Replies)
Discussion started by: tjay83
8 Replies

10. UNIX for Dummies Questions & Answers

How to route error to log file in unix

Hey Every one I have a find statement which find the files and deletes them find /web/local/orderlink/batchmanaged01/scripts/SMOappLogs/log -name 'orderlink.log.*' -type f -mtime +$10-exec rm -f {} \; This statement if finds a file at the given location it will delete the files but if it... (4 Replies)
Discussion started by: pinky
4 Replies
Login or Register to Ask a Question