Friday, March 12, 2010

oradiag_oracle - Oracle 11gR2 - Disabling the ADR

Voltei aqui!

Fazendo a limpeza do filesystem de um  servidor Oracle me deparei coma seguinte situação :

[oracle@myserver oracle]$ du -sch *
360M admin
5.8M cfgtoollogs
8.0K checkpoints
1.2G diag
988K import_ONLINE.log
16K oraarch
8.9G oradiag_oracle
4.5G product
15G total
[oracle@amhston1 oracle]$ 



8.9 GB de arquivos sendo que a maioria são arquivos de TRACE.

.../oradiag_oracle/diag/clients/user_oracle/host_919093865_76
[oracle@myserver host_919093865_76]$ du -sch *
2.3M alert
8.0K cdump
8.0K incident
8.0K incpkg
24K lck
296K metadata
8.0K stage
8.0K sweep
8.9G trace
8.9G total


Porcurando no metalink,já que no 11gR2 muitas coisas mudaram,me deparei com a nota 
ID 454927.1 .

Vamos executar os passos sugeridos na nota para desabilitar estes traces,já que estou com pouco espaço no flesystem.

adrci

ADRCI: Release 11.2.0.1.0 - Production on Fri Mar 12 11:00:19 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

ADR base = "/opt/oracle/oradiag_oracle"
adrci> show base -product client
ADR base is "/opt/oracle/oradiag_oracle"
adrci>  set base /opt/oracle/oradiag_oracle
adrci> exit


Vendo o trace file :

 more /opt/oracle/oradiag_oracle/diag/clients/user_oracle/host_919093865_76/trace/ora_13830_47831278068960.trc
Trace file /opt/oracle/oradiag_oracle/diag/clients/user_oracle/host_919093865_76/trace/ora_13830_47831278068960.trc
2010-03-11 15:40:09.488543 : --- TRACE CONFIGURATION INFORMATION FOLLOWS ---
2010-03-11 15:40:09.490799 : New trace stream is /opt/oracle/oradiag_oracle/diag/clients/user_oracle/host_919093865_76/trace/ora_13830_47831278068960.trc
2010-03-11 15:40:09.490827 : New trace level is 16
2010-03-11 15:40:09.490842 : --- TRACE CONFIGURATION INFORMATION ENDS ---
2010-03-11 15:40:09.490862 : --- PARAMETER SOURCE INFORMATION FOLLOWS ---
2010-03-11 15:40:09.490881 : Attempted load of system pfile source /opt/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora
2010-03-11 15:40:09.490895 : Parameter source loaded successfully
2010-03-11 15:40:09.490910 : 
2010-03-11 15:40:09.490924 : Attempted load of local pfile source /home/oracle/.sqlnet.ora
2010-03-11 15:40:09.490937 : Parameter source was not loaded
2010-03-11 15:40:09.490950 : 
2010-03-11 15:40:09.490963 :  -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
2010-03-11 15:40:09.490992 : Successful parameter table load
2010-03-11 15:40:09.491010 :  -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
2010-03-11 15:40:09.491029 :   CE_UNIQUE_CLIENT = ON
2010-03-11 15:40:09.491044 :   ADR_BASE = /opt/oracle
2010-03-11 15:40:09.491057 :   NAMES.DIRECTORY_PATH = (TNSNAMES, EZCONNECT)
2010-03-11 15:40:09.491071 :   TRACE_DIRECTORY_CLIENT = /home/oracle/temp
2010-03-11 15:40:09.491084 :   TRACE_TIMESTAMP_CLIENT = ON
2010-03-11 15:40:09.491097 :   TRACE_LEVEL_CLIENT = 16
2010-03-11 15:40:09.491110 :   TRACE_FILE_CLIENT = SQLNetTrace
2010-03-11 15:40:09.491123 : --- PARAMETER SOURCE INFORMATION ENDS ---
2010-03-11 15:40:09.491139 : --- LOG CONFIGURATION INFORMATION FOLLOWS ---
2010-03-11 15:40:09.491180 : Log stream will be "/opt/oracle/oradiag_oracle/diag/clients/user_oracle/host_919093865_76/alert/log.xml"
2010-03-11 15:40:09.491199 : Log stream validation not requested
2010-03-11 15:40:09.491213 : --- LOG CONFIGURATION INFORMATION ENDS ---

Tem a possibilidade de fazer um purge dos arquivos.
Neste caso fiz assim :

[oracle@myserver oradiag_oracle]$ adrci

ADRCI: Release 11.2.0.1.0 - Production on Fri Mar 12 12:55:48 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

ADR base = "/opt/oracle/oradiag_oracle"
adrci> purge -age 10 -type trace
adrci> exit
[oracle@myserver oradiag_oracle]$ cd diag/clients/user_oracle/host_919093865_76/
[oracle@myserver host_919093865_76]$ du -sch *
2.3M alert
8.0K cdump
8.0K incident
8.0K incpkg
24K lck
296K metadata
8.0K stage
8.0K sweep
4.3M trace
6.9M total
[oracle@amhston1 host_919093865_76]$ 


Ou  no sqlnet.ora do client e inserindo o parametro DIAG_ADR__ENABLED=OFF .

Doc para help :

http://download.oracle.com/docs/cd/E11882_01/network.112/e10836/trouble.htm#NETAG1524

Abs,

Julio Cesar Correa

No comments: