這個(gè)命令可以查看報(bào)錯(cuò)信息和日志，伴隨著11g trace目錄換位置之后一起提供給我們的。這個(gè)工具不僅能像vi一樣對(duì)日志進(jìn)行編輯。還能

1 認(rèn)識(shí)adrci

這個(gè)命令可以查看報(bào)錯(cuò)信息和日志，伴隨著11g trace目錄換位置之后一起提供給我們的。這個(gè)工具不僅能像vi一樣對(duì)日志進(jìn)行編輯。還能像tail -f 一樣查看日志文件。

而且可以跨平臺(tái)，在windows上也可以使用。

--------------------------------------分割線 --------------------------------------

在CentOS 6.4下安裝Oracle 11gR2(x)

Oracle 11gR2 在VMWare虛擬機(jī)中安裝步驟

Debian 下 安裝 Oracle 11g XE R2

--------------------------------------分割線 --------------------------------------

下面演示幾種adrci的常用用法。

1.1 查看命令位置

$ which adrci

/u01/app/oracle/product/11.2.0/dbhome_1/bin/adrci

1.2 為命令設(shè)置別名

rlwrap工具可以上下翻動(dòng)自己剛才執(zhí)行的命令

$ grep adrci .bash_profile

alias adrci='rlwrap adrci'

1.3 查看help

$ adrci -help

Syntax:

adrci [-help] [script=script_filename]

[exec = "one_command [;one_command;...]"]

Options Description (Default)

-----------------------------------------------------------------

script script file name (None)

help help on the command options (None)

exec exec a set of commands (None)

-----------------------------------------------------------------

從help可以看出他的語(yǔ)法可以是類(lèi)似下面這樣的：

1.3.1 直接執(zhí)行命令

$ adrci exec="show alert"

1.3.2 指定腳本命令

$ cat /tmp/abc.txt

show alert

$ adrci script = /tmp/abc.txt

$ adrci

ADRCI: Release 11.2.0.3.0 - Production on Fri Jun 6 11:45:39 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

ADR base = "/u01/app/oracle"

adrci>

2 使用adrci

2.1 查看help

adrci> help

HELP [topic]

Available Topics:

CREATE REPORT

ECHO

EXIT

HELP

HOST

IPS

PURGE

RUN

SET BASE

SET BROWSER

SET CONTROL

SET ECHO

SET EDITOR

SET HOMES | HOME | HOMEPATH

SET TERMOUT

SHOW ALERT

SHOW BASE

SHOW CONTROL

SHOW HM_RUN

SHOW HOMES | HOME | HOMEPATH

SHOW INCDIR

SHOW INCIDENT

SHOW PROBLEM

SHOW REPORT

SHOW TRACEFILE

SPOOL

There are other commands intended to be used directly by Oracle, type

"HELP EXTENDED" to see the list

2.2 查看home

從help中可以看出，show 后面可以接home homes homepath 這三個(gè)參數(shù)，也就是說(shuō)這三個(gè)參數(shù)其實(shí)顯示了同一個(gè)內(nèi)容。

注：這里的home并不是$ORACLE_HOME

adrci> show home

ADR Homes:

diag/rdbms/orcl/orcl

diag/asm/+asm/+ASM

diag/tnslsnr/oracle11g/listener

adrci> show homes

ADR Homes:

diag/rdbms/orcl/orcl

diag/asm/+asm/+ASM

diag/tnslsnr/oracle11g/listener

adrci> show homepath

ADR Homes:

diag/rdbms/orcl/orcl

diag/asm/+asm/+ASM

diag/tnslsnr/oracle11g/listener

2.3 列出home下面的日志(show alert)

像這種show alert 的方式可以理解為使用vi打開(kāi)日志文件。

adrci> help show alert

Usage: SHOW ALERT [-p ] [-term]

[ [-tail [num] [-f]] | [-file ] ]

Purpose: Show alert messages.

Options:

[-p ]: The predicate string must be double quoted.

The fields in the predicate are the fields:

ORIGINATING_TIMESTAMP timestamp

NORMALIZED_TIMESTAMP timestamp

ORGANIZATION_ID text(65)

COMPONENT_ID text(65)

HOST_ID text(65)

HOST_ADDRESS text(17)

MESSAGE_TYPE number

MESSAGE_LEVEL number

MESSAGE_ID text(65)

MESSAGE_GROUP text(65)

CLIENT_ID text(65)

MODULE_ID text(65)

PROCESS_ID text(33)

THREAD_ID text(65)

USER_ID text(65)

INSTANCE_ID text(65)

DETAILED_LOCATION text(161)

UPSTREAM_COMP_ID text(101)

DOWNSTREAM_COMP_ID text(101)

EXECUTION_CONTEXT_ID text(101)

EXECUTION_CONTEXT_SEQUENCE number

ERROR_INSTANCE_ID number

ERROR_INSTANCE_SEQUENCE number

MESSAGE_TEXT text(2049)

MESSAGE_ARGUMENTS text(129)

SUPPLEMENTAL_ATTRIBUTES text(129)

SUPPLEMENTAL_DETAILS text(129)

PROBLEM_KEY text(65)

[-tail [num] [-f]]: Output last part of the alert messages and

output latest messages as the alert log grows. If num is not specified,

the last 10 messages are displayed. If "-f" is specified, new data

will append at the end as new alert messages are generated.

[-term]: Direct results to terminal. If this option is not specified,

the results will be open in an editor.

By default, it will open in emacs, but "set editor" can be used

to set other editors.

[-file ]: Allow users to specify an alert file which

may not be in ADR. must be specified with full path.

Note that this option cannot be used with the -tail option

Examples:

show alert

show alert -p "message_text like '%incident%'"

show alert -tail 20

2.3.1 查看所有目錄中的日志

adrci> show alert

Choose the alert log from the following homes to view:

1: diag/rdbms/orcl/orcl

2: diag/asm/+asm/+ASM

3: diag/tnslsnr/oracle11g/listener

Q: to quit

Please select option:

2.3.2 查看自定義目錄下的日志

這個(gè)時(shí)候有4個(gè)選項(xiàng)可以供我們選擇，，分別是數(shù)據(jù)庫(kù)，asm，的日志文件。同樣也可以設(shè)置單獨(dú)的home，比如

adrci> set home diag/rdbms/orcl/orcl

adrci> show alert //類(lèi)似vi編輯意義昂

2.3.3 動(dòng)態(tài)查看定義目錄下的日志

一定要先設(shè)置目錄，不然不能查看，會(huì)得到以下錯(cuò)誤，所以應(yīng)該先設(shè)置home

adrci> show alert -tail -f

DIA-48449: Tail alert can only apply to single ADR home

adrci> sethome diag/rdbms/orcl/orcl

adrci> show alert -tail -f

用ctrl - c 方式可以退出動(dòng)態(tài)查看

這個(gè)命令有點(diǎn)熟悉，類(lèi)似于Linux中的“tail -f 文件名”，這里的“show alert -tail -”f 同樣適用于Windows

2.3.4 查看alert日志中包含ORA-的字符串

這個(gè)語(yǔ)法可以查看幫助（前面有列出），其中-p參數(shù)可以跟基于XXX的信息，比如下面是基于包含ORA- 的信息

adrci> show alert -p "MESSAGE_TEXT like '%ORA-%'"

更多詳情見(jiàn)請(qǐng)繼續(xù)閱讀下一頁(yè)的精彩內(nèi)容：

聲明：本網(wǎng)頁(yè)內(nèi)容旨在傳播知識(shí)，若有侵權(quán)等問(wèn)題請(qǐng)及時(shí)與本網(wǎng)聯(lián)系，我們將在第一時(shí)間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com