這個(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
[ [-tail [num] [-f]] | [-file ] ]
Purpose: Show alert messages.
Options:
[-p
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