O que o ADRCI pode me ajudar no meu dia a dia ?
Introduzido no Oracle 11.1.0.6 o ADRCI (Automatic Diagnostic Repository) é uma ferramenta desenvolvida pela própria Oracle que ajuda o DBA a gerenciar os erros que são gerados pelo o banco de dados. Além de visualizar os erros, podemos até mesmo definir uma janela de expurgo de traces sem a necessidade de criarmos um script na crontab ou job interno do Oracle.
Para utiliza-lo não há segredo, ele já vem instalado, basta executar:
[oracle@marte ~]$ adrci
ADRCI: Release 12.1.0.2.0 - Production on Mon Oct 19 17:52:17 2015
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/oracle"
Com as variáveis exportadas ele irá se basear no seu ORACLE_BASE para encontrar ORACLE_HOMES que possua utilizar:
adrci> show homes
ADR Homes:
diag/clients/user_oracle/host_1710563632_82
diag/rdbms/orclp/ORCLP
diag/tnslsnr/marte/listener
diag/tnslsnr/marte/listener_02
Selecione o home desejado:
adrci> set home diag/rdbms/orclp/ORCLP
O comando show alert faz o mesmo que um vi alert_ORCLP.log faria:
adrci> show alert
ADR Home = /u01/app/oracle/diag/rdbms/orclp/ORCLP:
*************************************************************************
Output the results to file: /tmp/alert_2840_14010_ORCLP_1.ado
2015-10-03 10:54:53.287000 -03:00
Starting ORACLE instance (normal) (OS id: 2615)
CLI notifier numLatches:3 maxDescs:519
**********************************************************************
Dump of system resources acquired for SHARED GLOBAL AREA (SGA)
Per process system memlock (soft) limit = 128G
Expected per process system memlock (soft) limit to lock
SHARED GLOBAL AREA (SGA) into memory: 468M
Mostra as últimas 20 linhas do alert.log
adrci> show alert -tail 20
2015-10-19 17:53:51.874000 -02:00
TNS-00513: Destination host unreachable
nt secondary err code: 113
nt OS err code: 0
2015-10-19 17:53:54.879000 -02:00
***********************************************************************
Fatal NI connect error 12543, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=saturno.localdomain)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ORCLSTB)(UR=A)(CID=(PROGRAM=oracle)(HOST=marte.localdomain)(USER=oracle))))
VERSION INFORMATION:
TNS for Linux: Version 12.1.0.2.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 12.1.0.2.0 - Production
Time: 19-OCT-2015 17:53:54
Tracing not turned on.
Tns error struct:
ns main err code: 12543
TNS-12543: TNS:destination host unreachable
ns secondary err code: 12560
nt main err code: 513
TNS-00513: Destination host unreachable
nt secondary err code: 113
nt OS err code: 0
2015-10-19 17:53:57.885000 -02:00
***********************************************************************
Fatal NI connect error 12543, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=saturno.localdomain)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ORCLSTB)(UR=A)(CID=(PROGRAM=oracle)(HOST=marte.localdomain)(USER=oracle))))
VERSION INFORMATION:
TNS for Linux: Version 12.1.0.2.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 12.1.0.2.0 - Production
Time: 19-OCT-2015 17:53:57
Tracing not turned on.
Tns error struct:
ns main err code: 12543
TNS-12543: TNS:destination host unreachable
ns secondary err code: 12560
nt main err code: 513
TNS-00513: Destination host unreachable
nt secondary err code: 113
nt OS err code: 0
Error 12543 received logging on to the standby
Executa um “loop” no alert.log aguardando novas entradas:
adrci> show alert -tail -f
2015-10-19 17:59:06.936000 -02:00
ns main err code: 12543
TNS-12543: TNS:destination host unreachable
ns secondary err code: 12560
nt main err code: 513
TNS-00513: Destination host unreachable
nt secondary err code: 113
nt OS err code: 0
2015-10-19 17:59:09.942000 -02:00
***********************************************************************
Fatal NI connect error 12543, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=saturno.localdomain)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ORCLSTB)(UR=A)(CID=(PROGRAM=oracle)(HOST=marte.localdomain)(USER=oracle))))
VERSION INFORMATION:
TNS for Linux: Version 12.1.0.2.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 12.1.0.2.0 - Production
Time: 19-OCT-2015 17:59:09
Tracing not turned on.
Tns error struct:
ns main err code: 12543
TNS-12543: TNS:destination host unreachable
ns secondary err code: 12560
nt main err code: 513
TNS-00513: Destination host unreachable
nt secondary err code: 113
nt OS err code: 0
Error 12543 received logging on to the standby
Procura uma entrada com base em uma string
adrci> show alert -p "message_text like '%ORA-600%'"
ADR Home = /u01/app/oracle/diag/rdbms/orclp/ORCLP:
*************************************************************************
No alert log in selected home
adrci> show alert -p "message_text like '%ERRO%'"
ADR Home = /u01/app/oracle/diag/rdbms/orclp/ORCLP:
*************************************************************************
Output the results to file: /tmp/alert_2840_14010_ORCLP_3.ado
2015-10-03 10:54:53.294000 -03:00
PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)
2015-10-03 12:06:24.990000 -03:00
PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)
2015-10-03 13:00:18.752000 -03:00
PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)
2015-10-03 16:21:58.019000 -03:00
PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)
2015-10-05 11:25:55.411000 -03:00
Ver os incidentes gerados no banco de dados:
adrci> show incident
ADR Home = /u01/app/oracle/diag/rdbms/orclp/ORCLP:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
185 ORA 4031 2015-10-03 11:19:12.449000 -03:00
153 ORA 4031 2015-10-03 11:19:13.337000 -03:00
313 ORA 4031 2015-10-03 11:19:20.097000 -03:00
305 ORA 4031 2015-10-03 11:19:21.792000 -03:00
186 ORA 4031 2015-10-03 11:19:22.096000 -03:00
127300 ORA 700 [kskvmstatact: excessive swapping observed] 2015-10-19 07:06:14.352000 -02:00
129700 ORA 700 [kskvmstatact: excessive swapping observed] 2015-10-19 08:56:26.789000 -02:00
7 rows fetched
Mostra os incidentes em modo BRIEF
adrci> show incident -mode brief
ADR Home = /u01/app/oracle/diag/rdbms/orclp/ORCLP:
*************************************************************************
**********************************************************
INCIDENT INFO RECORD 1
**********************************************************
INCIDENT_ID 313
STATUS ready
CREATE_TIME 2015-10-03 11:19:20.097000 -03:00
PROBLEM_ID 1
CLOSE_TIME <NULL>
FLOOD_CONTROLLED none
ERROR_FACILITY ORA
ERROR_NUMBER 4031
ERROR_ARG1 12312
ERROR_ARG2 shared pool
ERROR_ARG3 unknown object
ERROR_ARG4 KKSSP^57
ERROR_ARG5 kglseshtTable
ERROR_ARG6 <NULL>
ERROR_ARG7 <NULL>
ERROR_ARG8 <NULL>
ERROR_ARG9 <NULL>
ERROR_ARG10 <NULL>
ERROR_ARG11 <NULL>
ERROR_ARG12 <NULL>
SIGNALLING_COMPONENT KGH
SIGNALLING_SUBCOMPONENT <NULL>
SUSPECT_COMPONENT <NULL>
SUSPECT_SUBCOMPONENT <NULL>
ECID <NULL>
IMPACTS 0
**********************************************************
INCIDENT INFO RECORD 2
**********************************************************
INCIDENT_ID 305
STATUS ready
CREATE_TIME 2015-10-03 11:19:21.792000 -03:00
PROBLEM_ID 1
CLOSE_TIME <NULL>
FLOOD_CONTROLLED none
ERROR_FACILITY ORA
ERROR_NUMBER 4031
ERROR_ARG1 40
ERROR_ARG2 shared pool
ERROR_ARG3 java/util/Hashtable$1
ERROR_ARG4 KGLH0^6529442c
ERROR_ARG5 kglHeapInitialize:temp
ERROR_ARG6 <NULL>
ERROR_ARG7 <NULL>
ERROR_ARG8 <NULL>
ERROR_ARG9 <NULL>
ERROR_ARG10 <NULL>
ERROR_ARG11 <NULL>
ERROR_ARG12 <NULL>
SIGNALLING_COMPONENT KGH
SIGNALLING_SUBCOMPONENT <NULL>
SUSPECT_COMPONENT <NULL>
SUSPECT_SUBCOMPONENT <NULL>
ECID <NULL>
IMPACTS 0
Mostra os incidentes em modo detalhado
adrci> show incident -mode detail
**********************************************************
INCIDENT INFO RECORD 34
**********************************************************
INCIDENT_ID 153
STATUS ready
CREATE_TIME 2015-10-03 11:19:13.337000 -03:00
PROBLEM_ID 1
CLOSE_TIME <NULL>
FLOOD_CONTROLLED none
ERROR_FACILITY ORA
ERROR_NUMBER 4031
ERROR_ARG1 8480
ERROR_ARG2 shared pool
ERROR_ARG3 unknown object
ERROR_ARG4 sga heap(1,0)
ERROR_ARG5 KQR X PO
ERROR_ARG6 <NULL>
ERROR_ARG7 <NULL>
ERROR_ARG8 <NULL>
ERROR_ARG9 <NULL>
ERROR_ARG10 <NULL>
ERROR_ARG11 <NULL>
ERROR_ARG12 <NULL>
SIGNALLING_COMPONENT KGH
SIGNALLING_SUBCOMPONENT <NULL>
SUSPECT_COMPONENT <NULL>
SUSPECT_SUBCOMPONENT <NULL>
ECID <NULL>
IMPACTS 0
PROBLEM_KEY ORA 4031
FIRST_INCIDENT 185
FIRSTINC_TIME 2015-10-03 11:19:12.449000 -03:00
LAST_INCIDENT 2416
LASTINC_TIME 2015-10-03 11:33:42.558000 -03:00
IMPACT1 34668547
IMPACT2 34668546
IMPACT3 0
IMPACT4 0
KEY_NAME Client ProcId
KEY_VALUE oracle@marte.localdomain.2655_140494029107808
KEY_NAME Service
KEY_VALUE SYS$BACKGROUND
KEY_NAME ProcId
KEY_VALUE 19.1
KEY_NAME SID
KEY_VALUE 19.13037
OWNER_ID 1
INCIDENT_FILE /u01/app/oracle/diag/rdbms/orclp/ORCLP/trace/ORCLP_mmon_2655.trc
OWNER_ID 1
INCIDENT_FILE /u01/app/oracle/diag/rdbms/orclp/ORCLP/incident/incdir_153/ORCLP_mmon_2655_i153.trc
Mostra os problemas para aquele ORACLE_HOME
adrci> show problems
ADR Home = /u01/app/oracle/diag/rdbms/orclp/ORCLP:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
1 ORA 4031 2416 2015-10-03 11:33:42.558000 -03:00
2 ORA 700 [kskvmstatact: excessive swapping observed] 129700 2015-10-19 08:56:26.789000 -02:00
2 rows fetched
Mostra apenas um incidente específico em modo detalhado
adrci> show incident -mode detail -p "INCIDENT_ID=185"
ADR Home = /u01/app/oracle/diag/rdbms/orclp/ORCLP:
*************************************************************************
**********************************************************
INCIDENT INFO RECORD 1
**********************************************************
INCIDENT_ID 185
STATUS ready
CREATE_TIME 2015-10-03 11:19:12.449000 -03:00
PROBLEM_ID 1
CLOSE_TIME <NULL>
FLOOD_CONTROLLED none
ERROR_FACILITY ORA
ERROR_NUMBER 4031
ERROR_ARG1 40
ERROR_ARG2 shared pool
ERROR_ARG3 select policy#, action# from...
ERROR_ARG4 KGLH0^f05ac4e6
ERROR_ARG5 kglHeapInitialize:temp
ERROR_ARG6 <NULL>
ERROR_ARG7 <NULL>
ERROR_ARG8 <NULL>
ERROR_ARG9 <NULL>
ERROR_ARG10 <NULL>
ERROR_ARG11 <NULL>
ERROR_ARG12 <NULL>
SIGNALLING_COMPONENT KGH
SIGNALLING_SUBCOMPONENT <NULL>
SUSPECT_COMPONENT <NULL>
SUSPECT_SUBCOMPONENT <NULL>
ECID <NULL>
IMPACTS 0
PROBLEM_KEY ORA 4031
FIRST_INCIDENT 185
FIRSTINC_TIME 2015-10-03 11:19:12.449000 -03:00
LAST_INCIDENT 2416
LASTINC_TIME 2015-10-03 11:33:42.558000 -03:00
IMPACT1 34668547
IMPACT2 34668546
IMPACT3 0
IMPACT4 0
KEY_NAME ProcId
KEY_VALUE 23.8
KEY_NAME Client ProcId
KEY_VALUE oracle@marte.localdomain (TNS V1-V3).2898_140464977424992
KEY_NAME Module
KEY_VALUE sqlplus@marte.localdomain (TNS V1-V3)
KEY_NAME Service
KEY_VALUE SYS$USERS
KEY_NAME PQ
KEY_VALUE (0, 1443881948)
KEY_NAME SID
KEY_VALUE 30.39763
OWNER_ID 1
INCIDENT_FILE /u01/app/oracle/diag/rdbms/orclp/ORCLP/trace/ORCLP_ora_2898.trc
OWNER_ID 1
INCIDENT_FILE /u01/app/oracle/diag/rdbms/orclp/ORCLP/incident/incdir_185/ORCLP_ora_2898_i185.trc
1 rows fetched
Mostra o conteúdo de um trace:
adrci> show trace /u01/app/oracle/diag/rdbms/orclp/ORCLP/trace/ORCLP_ora_2898.trc
Output the results to file: /tmp/utsout_2840_140105_7.ado
/u01/app/oracle/diag/rdbms/orclp/ORCLP/trace/ORCLP_ora_2898.trc
----------------------------------------------------------
LEVEL PAYLOAD
----- ------------------------------------------------------------------------------------------------------------------------------------------------
Trace file /u01/app/oracle/diag/rdbms/orclp/ORCLP/trace/ORCLP_ora_2898.trc
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/12.1.0.2/dbhome_1
System name: Linux
Node name: marte.localdomain
Release: 3.8.13-98.4.1.el6uek.x86_64
Version: #2 SMP Wed Sep 23 18:46:01 PDT 2015
Machine: x86_64
Instance name: ORCLP
Redo thread mounted by this instance: 1
Oracle process number: 23
Unix process pid: 2898, image: oracle@marte.localdomain (TNS V1-V3)
*** 2015-10-03 11:15:55.943
*** SESSION ID:(30.39763) 2015-10-03 11:15:55.943
*** CLIENT ID:() 2015-10-03 11:15:55.943
*** SERVICE NAME:(SYS$USERS) 2015-10-03 11:15:55.943
*** MODULE NAME:(sqlplus@marte.localdomain (TNS V1-V3)) 2015-10-03 11:15:55.943
*** CLIENT DRIVER:(SQL*PLUS) 2015-10-03 11:15:55.943
*** ACTION NAME:() 2015-10-03 11:15:55.943
arguments: '-kprb' '-v' '-r' '-grant' 'PUBLIC' '-s' 'rdbms/jlib/servlet.jar'
Cria um IPS (Incident Packaging Service) com base em um incidente específico para ser usada em uma SR na Oracle.
adrci> ips create package incident 185
Created package 1 based on incident id 185, correlation level typical
Cria um IPS para todos os incidentes
adrci> ips create package
Created package 2 without any contents, correlation level typical
Cria um IPS para um determinado período, esse é útil quando ocorrem vários erros facilitando a criação do IPS rapidamente sem ter que criar um por um:
adrci> ips create package time '2015-10-10 00:00:00 -03:00' to '2015-10-19 22:00:00 -03:00'
Created package 3 based on time range 2015-10-10 00:00:00.000000 -03:00 to 2015-10-19 22:00:00.000000 -03:00, correlation level typical
Cria um IPS em um determinado diretório:
adrci> ips generate package 1 in /home/oracle
Generated package 1 in file /home/oracle/ORA4031_20151019181428_COM_1.zip, mode complete
Cria uma IPS com base em um problem key
adrci> show problem
ADR Home = /u01/app/oracle/diag/rdbms/orclp/ORCLP:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
1 ORA 4031 2416 2015-10-03 11:33:42.558000 -03:00
2 ORA 700 [kskvmstatact: excessive swapping observed] 129700 2015-10-19 08:56:26.789000 -02:00
2 rows fetched
adrci> IPS CREATE PACKAGE PROBLEMKEY "ORA 4031"
Created package 4 based on problem key ORA 4031, correlation level typical
Adiciona um incidente em uma package já criada:
adrci> ips add incident 153 package 1
Added incident 153 to package 1
Mostra a política de retenção dos traces e incidentes:
adrci> show control
ADR Home = /u01/app/oracle/diag/rdbms/orclp/ORCLP:
*************************************************************************
ADRID SHORTP_POLICY LONGP_POLICY LAST_MOD_TIME LAST_AUTOPRG_TIME LAST_MANUPRG_TIME ADRDIR_VERSION ADRSCHM_VERSION ADRSCHMV_SUMMARY ADRALERT_VERSION CREATE_TIME
-------------------- -------------------- -------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- -------------------- -------------------- -------------------- ----------------------------------------
2342799286 720 8760 2015-10-03 10:54:50.871975 -03:00 1 2 82 1 2015-10-03 10:54:50.871975 -03:00
1 rows fetched
SHOTP_POLICY: O valor defaul é de 720 horas (30 dias) e é responsável pela retenção de arquivos de trc e trm.
LONGP_POLICY: o valor defaul é 8760 (1 ano) e é responsável pela retenção de incidentes.
Caso você queira alterar a retenção:
adrci> set control (SHORTP_POLICY = 240)
adrci> set control (LONGP_POLICY = 1095)
adrci> show control
ADR Home = /u01/app/oracle/diag/rdbms/orclp/ORCLP:
*************************************************************************
ADRID SHORTP_POLICY LONGP_POLICY LAST_MOD_TIME LAST_AUTOPRG_TIME LAST_MANUPRG_TIME ADRDIR_VERSION ADRSCHM_VERSION ADRSCHMV_SUMMARY ADRALERT_VERSION CREATE_TIME
-------------------- -------------------- -------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- -------------------- -------------------- -------------------- ----------------------------------------
2342799286 240 1095 2015-10-19 18:30:20.270167 -02:00 1 2 82 1 2015-10-03 10:54:50.871975 -03:00
1 rows fetched
Expurgo manual:
adrci> purge -age 10080 -type ALERT (também exclui o log do Listener)
adrci> purge -age 10080 -type TRACE
adrci> purge -age 10080 -type incident
adrci> purge -age 10080 -type hm
adrci> purge -age 10080 -type utscdmp
adrci> purge -age 10080 -type cdump
Obs: No purge o tempo é em minutos
[oracle@marte trace]$ ls –l
...
-rw-r-----. 1 oracle oinstall 885 Oct 19 17:47 orclp_ora_2547.trc
-rw-r-----. 1 oracle oinstall 88 Oct 19 17:47 ORCLP_vktm_2555.trm
-rw-r-----. 1 oracle oinstall 1195 Oct 19 17:47 ORCLP_vktm_2555.trc
-rw-r-----. 1 oracle oinstall 106 Oct 19 17:47 ORCLP_dbw0_2573.trm
-rw-r-----. 1 oracle oinstall 964 Oct 19 17:47 ORCLP_dbw0_2573.trc
-rw-r-----. 1 oracle oinstall 192 Oct 19 17:47 ORCLP_ora_2547.trm
-rw-r-----. 1 oracle oinstall 4321 Oct 19 17:47 ORCLP_ora_2547.trc
-rw-r-----. 1 oracle oinstall 117 Oct 19 17:47 ORCLP_ckpt_2577.trm
-rw-r-----. 1 oracle oinstall 1125 Oct 19 17:47 ORCLP_ckpt_2577.trc
-rw-r-----. 1 oracle oinstall 201 Oct 19 17:47 ORCLP_ora_2598.trm
-rw-r-----. 1 oracle oinstall 1977 Oct 19 17:47 ORCLP_ora_2598.trc
-rw-r-----. 1 oracle oinstall 71 Oct 19 17:47 ORCLP_arc1_2610.trm
-rw-r-----. 1 oracle oinstall 959 Oct 19 17:47 ORCLP_arc1_2610.trc
-rw-r-----. 1 oracle oinstall 70 Oct 19 17:47 ORCLP_tt01_2618.trm
-rw-r-----. 1 oracle oinstall 940 Oct 19 17:47 ORCLP_tt01_2618.trc
-rw-r-----. 1 oracle oinstall 81 Oct 19 17:47 ORCLP_vkrm_2569.trm
-rw-r-----. 1 oracle oinstall 1119 Oct 19 17:47 ORCLP_vkrm_2569.trc
-rw-r-----. 1 oracle oinstall 132 Oct 19 17:47 ORCLP_arc0_2608.trm
-rw-r-----. 1 oracle oinstall 2066 Oct 19 17:47 ORCLP_arc0_2608.trc
-rw-r-----. 1 oracle oinstall 123 Oct 19 17:47 ORCLP_tt00_2616.trm
-rw-r-----. 1 oracle oinstall 2097 Oct 19 17:47 ORCLP_tt00_2616.trc
-rw-r-----. 1 oracle oinstall 122 Oct 19 17:48 ORCLP_aqpc_2626.trm
-rw-r-----. 1 oracle oinstall 1030 Oct 19 17:48 ORCLP_aqpc_2626.trc
-rw-r-----. 1 oracle oinstall 123 Oct 19 17:52 ORCLP_ora_2604.trm
[oracle@marte trace]$ adrci
ADRCI: Release 12.1.0.2.0 - Production on Mon Oct 19 18:35:10 2015
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/oracle"
adrci> purge -age 10 -type TRACE
adrci> exit
[oracle@marte trace]$ ls -l
total 2724
-rw-r-----. 1 oracle oinstall 2674657 Oct 19 18:40 alert_ORCLP.log
drwxr-xr-x. 2 oracle oinstall 4096 Oct 10 07:30 cdmp_20151010073008
drwxr-xr-x. 2 oracle oinstall 4096 Oct 10 07:31 cdmp_20151010073101
drwxr-xr-x. 2 oracle oinstall 4096 Oct 10 07:32 cdmp_20151010073245
drwxr-xr-x. 2 oracle oinstall 4096 Oct 10 07:35 cdmp_20151010073534
drwxr-xr-x. 2 oracle oinstall 4096 Oct 10 08:03 cdmp_20151010080322
drwxr-xr-x. 2 oracle oinstall 12288 Oct 19 07:06 cdmp_20151019070653
drwxr-xr-x. 2 oracle oinstall 12288 Oct 19 08:56 cdmp_20151019085646
-rw-r-----. 1 oracle oinstall 12350 Oct 19 18:40 ORCLP_arc2_2612.trc
-rw-r-----. 1 oracle oinstall 591 Oct 19 18:40 ORCLP_arc2_2612.trm
-rw-r-----. 1 oracle oinstall 2122 Oct 19 18:30 ORCLP_cjq0_2638.trc
-rw-r-----. 1 oracle oinstall 195 Oct 19 18:30 ORCLP_cjq0_2638.trm
-rw-r-----. 1 oracle oinstall 24042 Oct 19 18:44 ORCLP_dbrm_2567.trc
-rw-r-----. 1 oracle oinstall 1483 Oct 19 18:44 ORCLP_dbrm_2567.trm
-rw-r-----. 1 oracle oinstall 2487 Oct 19 18:43 ORCLP_mmon_2587.trc
-rw-r-----. 1 oracle oinstall 215 Oct 19 18:43 ORCLP_mmon_2587.trm
O melhor de tudo, ele não precisa que a instancia esteja no ar para ser usado:
[oracle@marte trace]$ s
SQL*Plus: Release 12.1.0.2.0 Production on Mon Oct 19 18:47:12 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@marte trace]$ adrci
ADRCI: Release 12.1.0.2.0 - Production on Mon Oct 19 18:47:39 2015
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/oracle"
adrci> show alert
ADR Home = /u01/app/oracle/diag/rdbms/orclp/ORCLP:
*************************************************************************
Output the results to file: /tmp/alert_3534_13967_ORCLP_1.ado
...
Successful close of redo thread 1
2015-10-19 18:47:22.203000 -02:00
Completed: ALTER DATABASE CLOSE NORMAL
Espero ter facilitado o seu dia a dia.
Até logo!