Verificar erros no AIX

Em algumas situações de Troubleshooting, enfrentamos aquele tipo de erro “muito estranho” no Banco de Dados, e queremos verificar se há algo errado no Sistema Operacional.

No AIX, mesmo com um usuário normal, não é necessário acordar o plantonista Unix para fazer uma análise preliminar, e nem ficar caçando pelos Log do SO. O utilitário errpt faz uma verificação geral dos Logs, para que você possa requerer uma análise mais detalhada do analista de AIX.

Veja no exemplo abaixo que ao ser executasem nenhuma opção, é mostrado um resumo dos erros. A opção -a mostra detalhes dos erros, e a opção -j restringe os detalhes a um código de erro específico.

oracle@MyServer /home/oracle> errpt
IDENTIFIER TIMESTAMP  T C RESOURCE_NAME  DESCRIPTION
3074FEB7   1030232910 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
DE3B8540   1030232810 P H hdisk5         PATH HAS FAILED
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
DE3B8540   1030232810 P H hdisk9         PATH HAS FAILED
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
DE3B8540   1030232810 P H hdisk6         PATH HAS FAILED
DE3B8540   1030232810 P H hdisk3         PATH HAS FAILED
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
DE3B8540   1030232810 P H hdisk1         PATH HAS FAILED
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
DE3B8540   1030232810 P H hdisk4         PATH HAS FAILED
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
DE3B8540   1030232810 P H hdisk10        PATH HAS FAILED
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232810 T H fscsi0         ADAPTER ERROR
3074FEB7   1030232710 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
DE3B8540   1030232510 P H hdisk9         PATH HAS FAILED
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
DE3B8540   1030232510 P H hdisk6         PATH HAS FAILED
DE3B8540   1030232510 P H hdisk3         PATH HAS FAILED
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
DE3B8540   1030232510 P H hdisk5         PATH HAS FAILED
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
DE3B8540   1030232510 P H hdisk4         PATH HAS FAILED
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
DE3B8540   1030232510 P H hdisk1         PATH HAS FAILED
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
DE3B8540   1030232510 P H hdisk10        PATH HAS FAILED
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7   1030232510 T H fscsi1         ADAPTER ERROR
3074FEB7 1030232510 T H fscsi1         ADAPTER ERROR
oracle@MyServer /home/oracle> errpt -a -j DE3B8540 | more
—————————————————————————
LABEL:          SC_DISK_ERR7
IDENTIFIER:     DE3B8540

Date/Time:       Sat Oct 30 23:28:28 GRNLNDST 2010
Sequence Number: 29177
Machine Id:      00CF5A444C00
Node Id:         BHSLZORA02
Class:           H
Type:            PERM
Resource Name:   hdisk5
Resource Class:  disk
Resource Type:   mpioosdisk
Location:        U789D.001.DQD93HY-P1-C3-T1-W5001738007F90151-L4000000000000
VPD:
Manufacturer…………….IBM
Machine Type and Model……2810XIV
ROS Level and ID…………31302E32
Serial Number……………07F901F7
Device Specific.(Z0)……..0000053241101002
Device Specific.(Z1)……..

Description
PATH HAS FAILED

Probable Causes
ADAPTER HARDWARE OR CABLE
DASD DEVICE

Failure Causes
UNDETERMINED

Recommended Actions
PERFORM PROBLEM DETERMINATION PROCEDURES
CHECK PATH

Detail Data
PATH ID
1
SENSE DATA
0600 1200 0000 FF04 0000 0000 0000 0000 0000 0000 0000 0000 0200 0400 0000 0000
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
Standard input

One comment

  1. Pingback: Tweets that mention Verificar erros no AIX | Nerv -- Topsy.com

Leave a Reply

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

Esse site utiliza o Akismet para reduzir spam. Aprenda como seus dados de comentários são processados.