资讯

精准传达 • 有效沟通

从品牌网站建设到网络营销策划,从策略到执行的一站式服务

oracle11gadrci工具使用方法-创新互联

oracle 11g adrci  是11g 以后才能的新功能
[oracle@rac1 ~]$ adrci

创新互联公司专注于企业营销型网站建设、网站重做改版、南县网站定制设计、自适应品牌网站建设、H5页面制作商城网站建设、集团公司官网建设、成都外贸网站建设公司、高端网站制作、响应式网页设计等建站业务,价格优惠性价比高,为南县等各大城市提供网站开发制作服务。

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


当前题目:oracle11gadrci工具使用方法-创新互联
网站链接:http://cdkjz.cn/article/cccdcc.html
多年建站经验

多一份参考,总有益处

联系快上网,免费获得专属《策划方案》及报价

咨询相关问题或预约面谈,可以通过以下方式与我们联系

大客户专线   成都:13518219792   座机:028-86922220