Sponsored Content
Top Forums Shell Programming and Scripting Script to report on Oracle's trace files Post 302396850 by methyl on Friday 19th of February 2010 12:50:46 PM
Old 02-19-2010
On our system we stop/start Oracle every day to allow for a backup.
This process generates one alert log and one ".trc" log for the start and another pair for the stop. By using a set of logs saved from a good day it is possible to use this list as a reference list of "normal" messages. The script needs to ignore lines which normally change such as datestamp lines, "mount id" lines and redo log switches.

It is then a simple task to extract any exception messages from current logs by eliminating "normal" messages. This method also spots when people change Oracle startup parameters.

Note: The absence of a log can be a sign of big trouble.
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script to move trace files

Please debug this shell script for me.. Basically the idea is to run the script, based on the command to move some trace files to a separate directory and I am getting the error. Only the COMMAND that has rm {} works and I basically want to use it for the fourth one. Please try for the 2nd, 3rd and... (4 Replies)
Discussion started by: ST2000
4 Replies

2. UNIX for Advanced & Expert Users

How to write Flat Files by shell script using Oracle Database

Hello There.. I came to a situation where I need to write flat files using shell scripts, I need to pull the records from the oracle database and create the flat file, This process should be automated. Can any shell script expert out here to help me.. please.. Will be really glad to... (3 Replies)
Discussion started by: coolbuddy
3 Replies

3. Shell Programming and Scripting

Cron Script report new files in directory

Hello, I have a folder on my Redhat linux box that .core files are dropped into when some software we have crashes. At the moment we don't have a way to know if there has been a crash without visiting this directory manually and seeing if there are any new .core files. Can anyone think of a... (3 Replies)
Discussion started by: michaelb1984
3 Replies

4. UNIX for Dummies Questions & Answers

How to trace the big files causing high disk usage

Hi All, One very urgent issue and I need your help. I have two V490 servers installed with Sun Solaris 10. I have traced out that the disk usage is running out of space for both the servers. Currently the /dev/md/dsk/d10 device is 91% in one server and another is 56% and it is increasing... (1 Reply)
Discussion started by: ailnilanjan
1 Replies

5. Solaris

Ping trace telnet monitoring script

Hello, it is my first post :) I need to implement some monitoring tools in a script, ping telnet traceroute I found this one to ping, it works, #!/bin/sh for i in `cat /tmp/PingStatus.txt` do ping -c 5 -w 5 -n $i | grep -q "bytes from" && echo "$i is OK" || opcmsg object=PING a=OS... (5 Replies)
Discussion started by: marmellata
5 Replies

6. Shell Programming and Scripting

How to put a trace on shell script running in AIX?

Please help me in putting a trace on shell script running in AIX Best regards, Vishal (3 Replies)
Discussion started by: Vishal_dba
3 Replies

7. Shell Programming and Scripting

Line count of trace files for 24 period

Hi, Using solaris 10 5.10 o/s I am learning awk as I work here on the job. What I need to do is isolate the trace file for the last 24 hours. After that I need to open those trace files and search for 'TNS-|ORA-' message from each one. These trace files MAY HAVE an occurance of them. I... (5 Replies)
Discussion started by: bdby
5 Replies

8. AIX

Making a trace for a script

Hello experts, I'm trying to make a trace (unix log) in hope to see why I have differences in some bases : I putted at the first { and in the last line } > $DATA_SAS 2>&1 Is it a right command ? Do you have another solution ? thank you, regards, (7 Replies)
Discussion started by: rimob
7 Replies

9. UNIX for Beginners Questions & Answers

awk script to find repeated IP adress from trace file (.tr)

+ 8.00747 /NodeList/0/DeviceList/0/$ns3::PointToPointNetDevice/TxQueue/Enqueue ns3::PppHeader (Point-to-Point Protocol: IP (0x0021)) ns3::Ipv4Header (tos 0x0 DSCP Default ECN Not-ECT ttl 63 id 0 protocol 17 offset (bytes) 0 flags length: 540 10.1.3.3 > 10.1.2.4) ns3::UdpHeader (length: 520 49153 >... (11 Replies)
Discussion started by: Nipa
11 Replies
wbemlogviewer(1M)														 wbemlogviewer(1M)

NAME
wbemlogviewer - start WBEM Log Viewer SYNOPSIS
/usr/sadm/bin/wbemlogviewer The wbemlogviewer utility starts the WBEM Log Viewer graphical user interface, which enables administrators to view and maintain log records created by WBEM clients and providers. The WBEM Log Viewer displays a Login dialog box. You must log in as root or a user with write access to the rootcimv2 namespace to view and maintain log files. Namespaces are described in wbemadmin(1M). Log events can have three severity levels. o Errors o Warnings o Informational The WBEM log file is created in the /var/sadm/wbem/log directory, with the name wbem_log. The first time the log file is backed up, it is renamed wbem_log.1, and a new wbem_log file is created. Each succeeding time the wbem_log file is backed up, the file extension number of each backup log file is increased by 1, and the oldest backup log file is removed if the limit, which in turn is specified in the log ser- vice settings, on the number of logfiles is exceeded. Older backup files have higher file extension numbers than more recent backup files. The log file is renamed with a .1 file extension and saved when one of the following two conditions occur: o The current file reaches the specified file size limit. o A WBEM client application uses the clearLog() method in the Solaris_LogService class to clear the current log file. o A WBEM client application uses the clearLog() method in the Solaris_LogService class to clear the current log file. o A user chooses Action->Back Up Now in the Log Viewer application. Help is displayed in the left panel of each dialog box. Context help is not displayed in the main Log Viewer window. The WBEM Log Viewer is not the tool for a distributed environment. It is used for local administration. The WBEM Log Viewer allows you to perform the following tasks: View the logs Set properties of log fiClick Action->Log File Settings to specify log file parameters and the log file directory. Back up a log file Click Action->Back Up Now to back up and close the current log file and start a new log file. Open historical log fileClick Action->Open Log File to open a backed-up log file. Delete an old log file Open the file and then click Action->Delete Log File. You can only delete backed-up log files. View log record details Double-click a log entry or click View->Log Entry Details to display the details of a log record. Sort the logs Click View->Sort By to sort displayed entries. You can also click any column heading to sort the list. By default, the log entries are displayed in reverse chronological order (new logs first). EXIT STATUS
The wbemlogviewer utility terminates with exit status 0. /var/sadm/wbem/log/wbem_log WBEM log file See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWwbcor | +-----------------------------+-----------------------------+ wbemadmin(1M), init.wbem(1M), mofcomp(1M), attributes(5) 3 Jan 2000 wbemlogviewer(1M)
All times are GMT -4. The time now is 05:02 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy