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