Shulou(Shulou.com)06/01 Report--

Oracle 11g adrci is a new feature after 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-%'"-displays the ORA error code

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 1714 03.086000 + 08:00

ORA-1653: unable to extend table SYS.PTEST by 128 in tablespace PTEST

2014-10-25 10 54 purl 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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.