oracle 11g adrci 工具使用方法
oracle 11g adrci 是11g 以后才能的新功能
[oracle@rac1 ~]$ adrci
ADRCI: Release 11.2.0.4.0 - Production on Mon Nov 17 16:12:36 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
ADR base = "/home/oracle"
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
adrci> show alert -p "message_text like '%ORA-%'" --显示ORA 错误代码
Choose the alert log from the following homes to view:
1: diag/clients/user_oracle/host_1874443374_80
2: diag/rdbms/racdb/racdb1
Q: to quit
Please select option: 2
Output the results to file: /tmp/alert_8297_30860_racdb1_1.ado
2014-10-23 15:17:03.086000 +08:00
ORA-1653: unable to extend table SYS.PTEST by 128 in tablespace PTEST
2014-10-25 10:54:34.288000 +08:00
Errors in file /home/oracle/diag/rdbms/racdb/racdb1/trace/racdb1_asmb_4861.trc:
ORA-15064: communication failure with ASM instance
ORA-03113: end-of-file on communication channel
Process ID:
Session ID: 35 Serial number: 3
Errors in file /home/oracle/diag/rdbms/racdb/racdb1/trace/racdb1_asmb_4861.trc:
ORA-15064: communication failure with ASM instance
ORA-03113: end-of-file on communication channel
Process ID:
Session ID: 35 Serial number: 3
adrci> show incident -all
ADR Home = /home/oracle/diag/clients/user_oracle/host_1874443374_80:
*************************************************************************
0 rows fetched
ADR Home = /home/oracle/diag/rdbms/racdb/racdb1:
*************************************************************************
0 rows fetched
免责声明:
① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的,并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据,供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。
② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341