Viewing ASM trace files and alert logs in Unix/Linux

ASM trace files begin with the "+" prefix.  On Unix/Linux I normally view database trace files using the more/less or vi/vim/view commands.  These commands and their variants however accept the "+" command as an option. Run 'man' on any of the commands to see what the "+" option does. Trying to use either of these commands may leave you a bit bewildered at first.

[grid@oelgrid01 trace]$ more +ASM1_ora_15496.trc
usage: more [-dflpcsu] [+linenum | +/pattern] name1 name2 ... 
[grid@oelgrid01 trace]$ less +ASM1_ora_15496.trc 
Missing filename ("less --help" for help)
You have several other options to viewing these trace files.  Of course, you could do a tail/head against the file e.g tail -50 +ASM_filename.trc.  But if the file was pretty big you would probably want to traverse back and forth.  For a small tracefile whose standard output fits on the screen you could just issue either of the following commands:
cat +ASM_filename.trc
cat +ASM_filename.trc | more
A more elaborate way of doing this using the find command:

find . -name '+ASM_filename.trc' -exec vi {} \;

Oracle 11g also provides a utility to help gather, report and view alert logs and list tracefiles.  ADR Command Interpreter (ADRCI) makes this possible.  Typing adrci at the shell prompt takes you into the adrci command-line interface.  ADRCI commands can also be executed in batch mode. Set your ORACLE_HOME and PATH environment variables before executing the adrci commands.

[grid@oelgrid01 trace]$ adrci
ADRCI: Release 11.2.0.2.0 - Production on Mon Feb 21 21:18:27 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
ADR base = "/u01/app/grid"
adrci> 
To view the alert log use the SHOW ALERT command:
adrci> show alert
ADR Home = /u01/app/grid/diag/asm/+asm/+ASM1:
*************************************************************************
Output the results to file: /tmp/alert_7917_14049_+ASM1_1.ado
2011-01-23 19:24:21.550000 -06:00
* instance_number obtained from CSS = 1, checking for the existence of node 0...
* node 0 does not exist. instance_number = 1
Starting ORACLE instance (normal)
2011-01-23 19:24:23.695000 -06:00
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
You can also tail the alert log 
adrci> show alert -tail
To view a l ist of tracefiles use the SHOW TRACEFILE command:
adrci> show tracefile
     diag/asm/+asm/+ASM1/trace/+ASM1_gcr0_4631.trc
     diag/asm/+asm/+ASM1/trace/+ASM1_ora_4030.trc
     diag/asm/+asm/+ASM1/trace/+ASM1_lmd0_4102.trc
     diag/asm/+asm/+ASM1/trace/+ASM1_dia0_4098.trc
     diag/asm/+asm/+ASM1/trace/+ASM1_lmon_4100.trc
     diag/asm/+asm/+ASM1/trace/+ASM1_lmhb_4108.trc
     diag/asm/+asm/+ASM1/trace/+ASM1_ora_4136.trc
     diag/asm/+asm/+ASM1/trace/alert_+ASM1.log
     diag/asm/+asm/+ASM1/trace/+ASM1_rbal_4120.trc
Note however that unlike the SHOW ALERT command this does not show the contents of the tracefile and you may want to resort to one of the methods I indicated before.

ADRCI has many more options available and is worthy of its own blog post. 

Comments

  1. AnonymousJune 12, 2012 at 3:34 AM

    you can user »--«,it marks the end of option arguments.

    less -- +ASM1_ora_15496.trc

    works fine
    andreas

    ReplyDelete
  2. Santosh LokeAugust 15, 2016 at 5:33 AM

    thx for the tip Andreas

    ReplyDelete
  3. UnknownMarch 18, 2017 at 9:57 AM

    Does anybody know what controls how frequently trace files are generated and how to limit their accumulated size?

    ReplyDelete

Post a Comment

Popular posts from this blog

Setup a Wordpress site in 10 Minutes using Oracle Container Cloud Service

Image
Oracle Container Cloud Service Oracle Container Cloud Service lets you easily deploy applications based on docker images. If you don't have an existing application you can create one on docker. However, the easiest method to get a full application up and running is by deploying a stack. Oracle Container Cloud Service provides several example stacks that you can deploy, including web servers based on NGINX or Apache, MongoDB database, and Wordpress. You can find more examples on Oracle GitHub Site . Let's see just how easy it is to spin up a Wordpress site using the Oracle Container Cloud Service. Prerequisites: Access to Oracle Cloud Account Subscription to Oracle IaaS Service First, go to the Oracle Container Cloud Service console and launch a new service. In this example, I created a service with three containers. One manager and two worker nodes. Choose an appropriate "shape" for your compute instances. Note: Oracle uses the term "shape" to r...
Read more

Oracle Home Cloning: Tools and Techniques

One of the many necessary and frequent tasks that a database administrator performs before creating a database is installing the Oracle database binaries. These binaries form what is known as an Oracle Home (referenced by the ORACLE_HOME environment variable on Linux and UNIX environments). Unfortunately, this is also one of the most mundane and uninteresting tasks a DBA can perform. So like all good DBAs know, the best way to deal with such repetitive task is to automate it. Automating installations of Oracle database binaries enables us to reliably repeat the process to enable faster installation as well as provide identical copies of the software in multiple environments. Fortunately, Oracle allows us to clone the Oracle database binaries from one environment to another. Cloning your Oracle binaries from a source copy with all the necessary patches applied enables us to have gold images which can then be deployed to multiple environments. The procedure for cloning an Oracle home...
Read more

Using XFS on Oracle Linux

Install xfs packages on Oracle Linux 6.6 via Oracle Public Yum [root@matthew ~]# yum install xfsprogs Loaded plugins: refresh-packagekit Setting up Install Process public_ol6_UEKR3_latest | 1.2 kB 00:00 public_ol6_UEK_latest | 1.2 kB 00:00 public_ol6_UEK_latest/primary | 19 MB 00:02 public_ol6_UEK_latest 407/407 public_ol6_addons | 1.2 kB 00:00 public_ol6_addons/primary | 77 kB 00:00 public_ol6_addons 269/269 public_ol6_latest | 1.4 kB 00:00 public_ol6_latest/primary | 46 MB 00:05 public_ol6_latest 29302/29302 http://public-yum.oracle.com/beta/repo/OracleLinux/OL6/uek3/x86_64/repodata/repomd.xml: [Errno 14] PYCURL ERROR 22 - "The requested URL returned error: 404 Not Found" Trying other mirror. Resolving Dependencies --> Running transaction check ---> Package xfsprogs.x86_64 0:3.1.11-1.0.5.el6 will be installed --> Finished Dependency Resolution Dependencies Resolved ===================================================================================================...
Read more