alerPfO – Alert Parser for Oracle

 
About alerPfO – Alert Parser for Oracle

alerPfo (Alert Parser for Oracle) is a free utility for browsing of Oracle alert.log files in order to display occured problems. This makes the check of alert.logs quiet easy, as alerPfo provides a quick overview of all relevenat messages.

alerPfo has been developed in Perl and therefore supports all platforms on which perl is available.

alerPfo can be downloaded here.

Installation instructions

  1. Installation of the Getopt::Long perl module

    alerPfo requires the perl module “Getopt::Long” to be installed. If you have direct access to the internet, this can be achieved by following commands:

    [root@dbserver ~]# perl -MCPAN -e shell
     
    cpan shell -- CPAN exploration and modules installation (v1.9402)
    Enter 'h' for help.
     
    cpan[1]> install Getopt::Long
    CPAN: Storable loaded ok (v2.15)
    Going to read '/root/.cpan/Metadata'
      Database was generated on Sat, 20 Feb 2010 06:55:54 GMT
    ...
    ...
    Appending installation info to /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/
    perllocal.pod
      JV/Getopt-Long-2.38.tar.gz
      /usr/bin/make install  -- OK
     
    cpan[2]>
  2. Download binary from here
  3. Transfer of the downloaded gzip-Archive to your database server

    lap:Downloads oracle$ scp alerPfO.gz oracle@dbserver:tools/.
    alerPfO.gz                                                   100% 1040     1.0KB/s   00:00    
    lap:Downloads oracle$
  4. Gunzip archive

    [oracle@dbserver ~]$ cd tools/
    [oracle@dbserver tools]$ ll
    total 4
    -rwx------ 1 oracle oinstall 1040 Feb 28 17:10 alerPfO.gz
    [oracle@dbserver tools]$ gunzip alerPfO.gz 
    [oracle@dbserver tools]$ ls -al
    total 16
    drwxr-xr-x 2 oracle oinstall 4096 Feb 28 17:12 .
    drwx------ 7 oracle oinstall 4096 Feb 28 17:10 ..
    -rwx------ 1 oracle oinstall 2477 Feb 28 17:10 alerPfO
    [oracle@dbserver tools]$
  5. Include installation directory into the PATH-Variable (Example for Bash on Linux/UNIX systems)

    Adding “PATH=$PATH:$HOME/tools” to the .bash_profile file:

    [oracle@dbserver tools]$ cat ~/.bash_profile 
    # .bash_profile
     
    # Get the aliases and functions
    if [ -f ~/.bashrc ]; then
    	. ~/.bashrc
    fi
     
    # User specific environment and startup programs
     
    PATH=$PATH:$HOME/bin
     
    PATH=$PATH:$HOME/tools
     
    export PATH
     
    export ORACLE_BASE=/u01/app/oracle
     
    [oracle@dbserver tools]$
  6. Reread .bash_profile file

    [oracle@dbserver tools]$ . ~/.bash_profile
    [oracle@dbserver tools]$

Usage

  • Listing available options

    [oracle@dbserver tools]$ alerPfO 
     
    Error in parsing command line arguments! Usage:
     
    AlerPfO [--verbose] --alert=ALERT_LOG
     
    	 --verbose		... print verbose output
    	 --alert=ALERT_LOG	... specify Oracle alert.log to parse
     
     
    [oracle@dbserver tools]$
  • Example

    [oracle@dbserver tools]$ cd /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/
    [oracle@dbserver trace]$ alerPfO --alert=alert_ORCL.log | more
     
    Starting to parse alert_ORCL.log for relevant messages:
    =======================================================
     
    Mon Jan 18 14:01:51 2011
    Starting ORACLE instance (normal)
     
    Mon Jan 18 14:05:25 2011
    Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_ora_2543.trc:
    ORA-00942: table or view does not exist
     
    Mon Jan 18 14:54:15 2011
    Shutting down instance: further logons disabled
     
    Mon Jan 18 14:54:29 2011
    Shutting down instance (immediate)
     
    Mon Jan 18 14:54:38 2011
    Instance shutdown complete
    Starting ORACLE instance (normal)
     
    Mon Jan 18 14:55:14 2011
    Shutting down instance: further logons disabled
     
    Mon Jan 18 14:55:14 2011
    Shutting down instance (immediate)
     
    Mon Jan 18 14:55:21 2011
    Instance shutdown complete
    Starting ORACLE instance (normal)
     
    Sat Feb 13 00:12:13 2011
    Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_arc1_20409.trc:
    ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 86.31% used, and has 
    294091776 remaining bytes available.
     
    Tue Feb 16 00:32:09 2011
    Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_arc0_20407.trc:
    ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 97.96% used, and has 
    43846656 remaining bytes available.
     
    --More--
  1. No comments yet.
  1. No trackbacks yet.

Connect with Facebook