Below is just an example on how to use ADRCI to collect incident packages for Oracle Database Diagnosis.
(oracle)$ adrci
ADRCI: Release 12.1.0.2.0 - Production on Tue Jun 30 15:10:15 2015
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/oracle" adrci> show home
ADR Homes:
diag/asm/+asm/+ASM1
diag/tnslsnr/dm01db01/listener
diag/tnslsnr/dm01db01/listener_scan1
diag/tnslsnr/dm01db01/listener_scan2
diag/tnslsnr/dm01db01/listener_scan3
diag/tnslsnr/dm01db01/mgmtlsnr
diag/rdbms/_mgmtdb/-MGMTDB
diag/rdbms/db/DB1
diag/crs/dm01db01/crs
diag/clients/user_oracle/host_2126158249_82
diag/clients/user_oracle/host_2126158249_80
diag/clients/user_oracle/host_2126158249_11
diag/asmtool/user_oracle/host_2126158249_82
adrci> set homepath diag/rdbms/db/DB1 adrci> show problem
ADR Home = /u01/app/oracle/diag/rdbms/db/DB1:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
1 ORA 600 [qernsRowP] 9625 2015-06-24 18:54:42.139000 +08:00
3 ORA 600 [15851] 33212 2015-06-29 22:58:54.142000 +08:00
2 ORA 600 [rworupo.1] 33068 2015-06-30 11:56:29.847000 +08:00
3 rows fetched adrci> ips pack problem 2 in /tmp
Generated package 1 in file /tmp/ORA600rwo_20150630151104_COM_1.zip, mode complete
No comments:
Post a Comment