Shulou(Shulou.com)06/01 Report--

Oracle rac problem solving

1 View related logs

[root@rac1 rac1] # pwd

/ u01/app/grid/11.2.0/log/rac1

[root@rac1 rac1] # ls

Acfs acfsrepl acfssec agent clientcrfmond cssdcvu evmd gnsd mdnsd racg

Acfslog acfsreplroot admin alertrac1.log crflogd crsd ctssd diskmon gipcd gpnpd ohasd srvm

Admin = > record some summary information

Alertgnd-rac01.log = > record some summary information when the node crs status changes. For more information, please see css log.

Client = > record crs initialization, ocr application including: CLSCFG, CSS, OCRCHECK, OCRCONFIG, OCRDUMP and OIFCFG

Crsd = > record the related log of crsd. After waiting for css to enter fatal mode, crs starts crsd and then starts the relevant resource.

Cssd = > record cssd related log, node stop, start, reconfig, etc., all problems will be recorded, the most important log

Evmd = > log the evmd

Racg = > record the log related to ons,vip

two。 The diagcollection.pl script is provided in the "$ORA_CRS_HOME/bin" directory of the Oracle cluster environment, and executing it as the root user accomplishes the purpose of collecting the necessary diagnostic information.

Execute the collection script diagcollection.pl

[root@rac1 ~] # cd $ORA_CRS_HOME/bin

[root@rac1 bin] #. / diagcollection.pl-help

Production Copyright 2004, 2010, Oracle. All rights reserved

Cluster Ready Services (CRS) diagnostic collection tool

Diagcollection

-- collect

[--crs] For collecting crs diagnostic information

[--adr] For collecting diagnostic information for ADR; specify ADR location

[- chmos] For collecting Cluster Health Monitor (OS) data

[- acfs] Unix only. For collecting ACFS diagnostic information

[- all] Default.For collecting all diagnostic information.

[- core] UNIX only. Package core files with CRS data

[- afterdate] UNIX only. Collects archives from the specified date. Specify in mm/dd/yyyy format

[- aftertime] Supported with-adr option. Collects archives after the specified time. Specify in YYYYMMDDHHMISS24 format

[- beforetime] Supported with-adr option. Collects archives before the specified date. Specify in YYYYMMDDHHMISS24 format

[--crshome] Argument that specifies the CRS Home location

[- incidenttime] Collects Cluster Health Monitor (OS) data from the specified time. Specify in MM/DD/YYYYHH24:MM:SS format

If not specified, Cluster Health Monitor (OS) data generated in the past 24 hours are collected

[- incidentduration] Collects Cluster Health Monitor (OS) data for the duration after the specified time. Specify in HH:MM format.

If not specified, all Cluster Health Monitor (OS) data after incidenttime are collected

NOTE:

1. You can also do the following

. / diagcollection.pl-- collect-- crs-- crshome

-- clean cleans up the diagnosability

Information gathered by this script

-- coreanalyze UNIX only. Extracts information from core files

And stores it in a text file

[root@rac1 bin] #. / diagcollection.pl-- collect-- all-- crshome $ORA_CRS_HOME

Production Copyright 2004, 2005, Oracle. All rights reserved

Cluster Ready Services (CRS) diagnostic collection tool

The following CRS diagnostic archives will be created in the local directory.

CrsData_rac1.tar.gz-> logs,traces and cores from CRS home. Note: core files will be packaged only with the-core option.

OcrData_rac1.tar.gz-> ocrdump, ocrcheck etc

CoreData_rac1.tar.gz-> contents of CRS core files in text format

Collecting crs data

/ bin/tar: Removing leading `/ 'from member names

Collecting OCR data

Collecting information from core files

No corefiles found

The following Oracle Home diagnostic archives will be created in the local directory.

OraData_rac1.tar.gz-> logs, traces and cores from Oracle Home

Collecting oracle home data

/ bin/tar: Removing leading `/ 'from member names

The package file generated this time is as follows:

[root@rac1 bin] # ls-l * tar.gz

-rw-r--r-- 1 root root 138 Nov 18 22:38 coreData_rac1.tar.gz

-rw-r--r-- 1 root root 234507 Nov 18 22:38 crsData_rac1.tar.gz

-rw-r--r-- 1 root root 8000 Nov 18 22:38 ocrData_rac1.tar.gz

-rw-r--r-- 1 root root 81851 Nov 18 22:38 oraData_rac1.tar.gz

It is very convenient to package the diagnostic information in batches by using the diagcollection.pl script provided by Oracle. The tedious process of collecting fault information is simplified.

If you need to submit diagnostic information to Oracle technical support personnel, using this method will be more efficient.

3. Use the cluvfy tool

[grid@rac1 ~] $cluvfy-help

USAGE:

Cluvfy [- help |-version]

Cluvfy stage {- list |-help}

Cluvfy stage {- pre |-post} [- verbose]

Cluvfy comp {- list |-help}

Cluvfy comp [- verbose]

For example

[grid@rac1] $cluvfy comp crs-n all-verbose

Verifying CRS integrity

Checking CRS integrity...

Clusterware version consistency passed

The Oracle Clusterware is healthy on node "rac2"

The Oracle Clusterware is healthy on node "rac1"

CRS integrity check passed

Verification of CRS integrity was successful.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.