溫馨提示×

溫馨提示×

您好,登錄后才能下訂單哦!

密碼登錄×
登錄注冊×
其他方式登錄
點擊 登錄注冊 即表示同意《億速云用戶服務條款》

oracle 11g adrci 工具使用方法

發布時間:2020-08-15 01:06:22 來源:ITPUB博客 閱讀:306 作者:burphy 欄目:關系型數據庫

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




向AI問一下細節

免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。

AI

亚洲午夜精品一区二区_中文无码日韩欧免_久久香蕉精品视频_欧美主播一区二区三区美女