Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Log checking script
Top Forums Shell Programming and Scripting Log checking script Post 303045904 by thumbelina on Friday 17th of April 2020 03:37:42 PM
Old 04-17-2020
just to clarify, the other logs are in the same directory as they first log but i would like to expand this eventually to be able to use across other db environment but im taking it one step at a time. I do have a userlist in the script i just didnt include it in the posted code for privacy reasons. this is the email that the original script creates if this helps. disclaimer: i didnt write the original script but i have been given the task of upgrading it as a project.

Please check these possible errors from the /pdb1/pdb.lg log.

----------------------------------------------------------------------------
SEARCH PATTERN = abnormal
----------------------------------------------------------------------------
Code:
[2020/04/13@07:42:17.885-0500] P-30355      T-140597209511744 I SRV    14: (794)   Usernum 716 terminated abnormally. 
[2020/04/13@10:37:32.364-0500] P-30367      T-139842457388864 I SRV    15: (794)   Usernum 715 terminated abnormally. 
[2020/04/13@11:14:57.815-0500] P-30320      T-140658028422976 I SRV    11: (794)   Usernum 719 terminated abnormally. 
[2020/04/13@14:50:49.182-0500] P-30399      T-140378140444480 I SRV    17: (794)   Usernum 713 terminated abnormally. 
[2020/04/13@17:47:39.479-0500] P-30331      T-139866618869568 I SRV    12: (794)   Usernum 718 terminated abnormally. 
[2020/04/13@17:54:00.450-0500] P-30320      T-140658028422976 I SRV    11: (794)   Usernum 719 terminated abnormally. 
[2020/04/13@17:57:30.993-0500] P-30423      T-140633268692800 I SRV    22: (794)   Usernum 708 terminated abnormally. 
[2020/04/13@19:17:05.347-0500] P-30344      T-140503546509120 I SRV    13: (794)   Usernum 717 terminated abnormally. 
[2020/04/14@01:24:36.615-0500] P-30331      T-139866618869568 I SRV    12: (794)   Usernum 718 terminated abnormally. 
[2020/04/14@01:24:45.980-0500] P-30320      T-140658028422976 I SRV    11: (794)   Usernum 719 terminated abnormally. 
[2020/04/14@13:33:46.572-0500] P-30355      T-140597209511744 I SRV    14: (794)   Usernum 716 terminated abnormally. 
[2020/04/14@15:33:18.741-0500] P-30399      T-140378140444480 I SRV    17: (794)   Usernum 713 terminated abnormally. 
[2020/04/14@18:18:41.118-0500] P-30412      T-140339427333952 I SRV    20: (794)   Usernum 710 terminated abnormally. 
[2020/04/15@01:07:55.407-0500] P-30308      T-140475794827072 I SRV    10: (794)   Usernum 720 terminated abnormally. 
[2020/04/15@01:25:21.829-0500] P-30344      T-140503546509120 I SRV    13: (794)   Usernum 717 terminated abnormally. 
[2020/04/15@01:45:59.626-0500] P-30399      T-140378140444480 I SRV    17: (794)   Usernum 713 terminated abnormally. 
[2020/04/15@01:45:59.660-0500] P-30308      T-140475794827072 I SRV    10: (794)   Usernum 720 terminated abnormally. 
[2020/04/15@07:11:10.400-0500] P-30399      T-140378140444480 I SRV    17: (794)   Usernum 713 terminated abnormally. 
[2020/04/15@07:31:43.706-0500] P-30344      T-140503546509120 I SRV    13: (794)   Usernum 717 terminated abnormally. 
[2020/04/15@10:18:32.844-0500] P-30403      T-140013961852736 I SRV    18: (794)   Usernum 712 terminated abnormally. 
[2020/04/15@15:17:32.587-0500] P-30412      T-140339427333952 I SRV    20: (794)   Usernum 710 terminated abnormally. 
[2020/04/15@15:56:16.336-0500] P-30399      T-140378140444480 I SRV    17: (794)   Usernum 713 terminated abnormally. 
[2020/04/15@18:17:16.439-0500] P-30399      T-140378140444480 I SRV    17: (794)   Usernum 713 terminated abnormally. 
[2020/04/16@01:41:47.610-0500] P-30367      T-139842457388864 I SRV    15: (794)   Usernum 715 terminated abnormally. 
[2020/04/16@01:41:47.613-0500] P-30320      T-140658028422976 I SRV    11: (794)   Usernum 719 terminated abnormally.

----------------------------------------------------------------------------
SEARCH PATTERN = allow*
----------------------------------------------------------------------------
Code:
[2020/04/12@13:25:51.351-0500] P-28111      T-139668866561856 I BROKER  0: (12813) Allowed index cursors (-c): 2904 
[2020/04/12@13:25:51.439-0500] P-28111      T-139668866561856 I BROKER  0: (10836) Database connections are not allowed at this time.

----------------------------------------------------------------------------
SEARCH PATTERN = attempt*
----------------------------------------------------------------------------
Code:
[2020/04/13@17:54:50.850-0500] P-30408      T-140270759073600 I SRV    19: (1280)  Connection timed out on socket=255 for usernum 711, attempt disconnect. 
[2020/04/13@17:55:37.442-0500] P-30403      T-140013961852736 I SRV    18: (1280)  Connection timed out on socket=255 for usernum 712, attempt disconnect. 
[2020/04/13@18:07:13.250-0500] P-30412      T-140339427333952 I SRV    20: (1280)  Connection timed out on socket=255 for usernum 710, attempt disconnect. 
[2020/04/14@00:25:52.738-0500] P-30308      T-140475794827072 I SRV    10: (1280)  Connection timed out on socket=255 for usernum 720, attempt disconnect. 
[2020/04/14@17:53:54.530-0500] P-30378      T-139793563330368 I SRV    16: (1280)  Connection timed out on socket=255 for usernum 714, attempt disconnect. 
[2020/04/15@03:37:59.906-0500] P-30331      T-139866618869568 I SRV    12: (1280)  Connection timed out on socket=255 for usernum 718, attempt disconnect. 
[2020/04/15@12:17:05.890-0500] P-30308      T-140475794827072 I SRV    10: (1280)  Connection timed out on socket=255 for usernum 720, attempt disconnect.

----------------------------------------------------------------------------
SEARCH PATTERN = error
----------------------------------------------------------------------------
Code:
[2020/04/13@07:42:17.886-0500] P-30355      T-140597209511744 I SRV    14: (-----) TCP/IP write error occurred with errno 32
[2020/04/13@10:37:32.365-0500] P-30367      T-139842457388864 I SRV    15: (-----) TCP/IP write error occurred with errno 32
[2020/04/13@11:14:57.817-0500] P-30320      T-140658028422976 I SRV    11: (-----) TCP/IP write error occurred with errno 32
[2020/04/13@14:50:49.183-0500] P-30399      T-140378140444480 I SRV    17: (-----) TCP/IP write error occurred with errno 32
[2020/04/13@17:47:39.481-0500] P-30331      T-139866618869568 I SRV    12: (-----) TCP/IP write error occurred with errno 32
[2020/04/13@17:54:00.451-0500] P-30320      T-140658028422976 I SRV    11: (-----) TCP/IP write error occurred with errno 32
[2020/04/13@17:54:50.851-0500] P-30408      T-140270759073600 I SRV    19: (-----) TCP/IP write error occurred with errno 32
[2020/04/13@17:55:37.444-0500] P-30403      T-140013961852736 I SRV    18: (-----) TCP/IP write error occurred with errno 32
[2020/04/13@17:57:30.995-0500] P-30423      T-140633268692800 I SRV    22: (-----) TCP/IP write error occurred with errno 32
[2020/04/13@18:07:13.252-0500] P-30412      T-140339427333952 I SRV    20: (-----) TCP/IP write error occurred with errno 32
[2020/04/13@19:17:05.348-0500] P-30344      T-140503546509120 I SRV    13: (-----) TCP/IP write error occurred with errno 32
[2020/04/14@00:25:52.740-0500] P-30308      T-140475794827072 I SRV    10: (-----) TCP/IP write error occurred with errno 32
[2020/04/14@01:24:36.617-0500] P-30331      T-139866618869568 I SRV    12: (-----) TCP/IP write error occurred with errno 32
[2020/04/14@01:24:45.982-0500] P-30320      T-140658028422976 I SRV    11: (-----) TCP/IP write error occurred with errno 32
[2020/04/14@13:33:46.573-0500] P-30355      T-140597209511744 I SRV    14: (-----) TCP/IP write error occurred with errno 32
[2020/04/14@15:33:18.742-0500] P-30399      T-140378140444480 I SRV    17: (-----) TCP/IP write error occurred with errno 32
[2020/04/14@17:53:54.536-0500] P-30378      T-139793563330368 I SRV    16: (-----) TCP/IP write error occurred with errno 32
[2020/04/14@18:18:41.190-0500] P-30412      T-140339427333952 I SRV    20: (-----) TCP/IP write error occurred with errno 32
[2020/04/15@01:07:55.408-0500] P-30308      T-140475794827072 I SRV    10: (-----) TCP/IP write error occurred with errno 32
[2020/04/15@01:25:21.831-0500] P-30344      T-140503546509120 I SRV    13: (-----) TCP/IP write error occurred with errno 32
[2020/04/15@01:45:59.629-0500] P-30399      T-140378140444480 I SRV    17: (-----) TCP/IP write error occurred with errno 32
[2020/04/15@01:45:59.661-0500] P-30308      T-140475794827072 I SRV    10: (-----) TCP/IP write error occurred with errno 32
[2020/04/15@03:37:59.908-0500] P-30331      T-139866618869568 I SRV    12: (-----) TCP/IP write error occurred with errno 32
[2020/04/15@07:11:10.402-0500] P-30399      T-140378140444480 I SRV    17: (-----) TCP/IP write error occurred with errno 32
[2020/04/15@07:31:43.707-0500] P-30344      T-140503546509120 I SRV    13: (-----) TCP/IP write error occurred with errno 32
[2020/04/15@10:18:32.846-0500] P-30403      T-140013961852736 I SRV    18: (-----) TCP/IP write error occurred with errno 32
[2020/04/15@12:17:05.891-0500] P-30308      T-140475794827072 I SRV    10: (-----) TCP/IP write error occurred with errno 32
[2020/04/15@15:17:32.588-0500] P-30412      T-140339427333952 I SRV    20: (-----) TCP/IP write error occurred with errno 32
[2020/04/15@15:56:16.337-0500] P-30399      T-140378140444480 I SRV    17: (-----) TCP/IP write error occurred with errno 32
[2020/04/15@18:17:16.441-0500] P-30399      T-140378140444480 I SRV    17: (-----) TCP/IP write error occurred with errno 32
[2020/04/16@01:41:47.611-0500] P-30367      T-139842457388864 I SRV    15: (-----) TCP/IP write error occurred with errno 32
[2020/04/16@01:41:47.614-0500] P-30320      T-140658028422976 I SRV    11: (-----) TCP/IP write error occurred with errno 32

----------------------------------------------------------------------------
SEARCH PATTERN = kill*
----------------------------------------------------------------------------
Code:
[2020/04/15@15:30:21.000+0000] P-9021       T-140038969972608 I ABL   435: (298)   KILL signal received.

Moderator's Comments:
Mod Comment
Please use code tags when posting data and code samples!
Last edited by vgersh99; 04-17-2020 at 05:17 PM.. Reason: code tags, please!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

checking for script errors

ok, i have a script which i use to search my process' for specific keywords and kill any process containing them. there is a prompt to enter a keyword for searching and another prompt for which user you want to search the process' of. i want the script to have something that if you entered a search... (1 Reply)
Discussion started by: Blip
1 Replies

2. Shell Programming and Scripting

log file checking

Hi, I want to write a script which will count the occurence of several different strings in a log file? Can anyone help me with this? Thanks in advance! (1 Reply)
Discussion started by: mpang_
1 Replies

3. Shell Programming and Scripting

checking size of the first line in a log file

Hi My test.log file looks like this: 0 190_GSTV_HUX_003QISCGSK026_error070322_115331917.log 34 190_GSTV_HUX_003QISCGSK026_error070117_151311385.log 12 190_GSTV_HUX_003QISCGSK026_error070117_151230001.log 2 190_GSTV_HUX_003QISCGSK026_error070117_101010001.log 0... (19 Replies)
Discussion started by: kiran1112
19 Replies

4. Shell Programming and Scripting

Checking the directory and concatenate the data of all the log files in that dir

Hi Gurus, I am new to unix and need your help to make a shell script. I have a requirement, would appreciate if you could please help me on it: Requirement: ------------- I will pass 2 parameters in shell script 1). Directory name say errors 2). file extension say .log First of all this... (4 Replies)
Discussion started by: anshulinpc
4 Replies

5. Shell Programming and Scripting

Script for checking yesterday's log

Hi, Have to check log file for yesterday, I have tried this script, but it is showing error as -d illegal option. res=max_total`date -d'yesterday'+%y%m%d`.log res=max_total`date +%y%m%d`.log this is working fine for today. Please help me on this. Thanks in advance, Neha. (3 Replies)
Discussion started by: NehaKrish
3 Replies

6. Shell Programming and Scripting

File checking script need help

Hi, Gurus, I need a scripts to check specified file if it exists or not at certain time (say every month between 5th and 7th). if file exists do something otherwise do another thing. can anybody help this? Thanks in advance :wall: (3 Replies)
Discussion started by: ken002
3 Replies

7. Shell Programming and Scripting

Help with database checking script

I haven't coded in ksh in forever and this script is proving me not a great coder. I keep getting unexpected end of file when I try to execute this...Line 94 is the last line of the code.. #!/usr/bin/ksh . /home/oraprod/.bash_profile DBSID=prod # Database sid CONNECTSTR=apps/xxxxxxxx@prod #... (6 Replies)
Discussion started by: kirkladb
6 Replies

8. Shell Programming and Scripting

Checking postfix mail log with AWK

Hello, Few days ago I found a person checking his mail log by AWK. But unfortunately I forget to take the command from him. Today I got to need that command badly. Here is a reference. When I check from my mail log like this it will not show me the details. grep "from=<noreply@panix.com>"... (2 Replies)
Discussion started by: rinti
2 Replies

9. Shell Programming and Scripting

Shell Script for continuously checking status of a another script running in background, and immedia

Hi, I want to write a script which continuously checking status of a script running in background by nohup command. And if same script is not running then immediately start the script...please help.. i am using below command to run script nohup system_traps.sh & but in some... (9 Replies)
Discussion started by: ketanraut
9 Replies

10. Shell Programming and Scripting

Script will keep checking running status of another script and also restart called script at night

I am using blow script :-- #!/bin/bash FIND=$(ps -elf | grep "snmp_trap.sh" | grep -v grep) #check snmp_trap.sh is running or not if then # echo "process found" exit 0; else echo "process not found" exec /home/Ketan_r /snmp_trap.sh 2>&1 & disown -h ... (1 Reply)
Discussion started by: ketanraut
1 Replies
All times are GMT -4. The time now is 01:36 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy