Saturday, January 11, 2014

Which OBIEE 10g Logs Can Be Rotated?

NQQuery.log , sawlogN.log and jhostN.log.N can be rotated.

NQQuery.log

Set the parameter USER_LOG_FILE_SIZE of User Log section on $OracleBI/Server/config/NQSConfig.INI.

sawlogN.log

Set the following parameters in $OracleBIData/web/config/logconfig.xml:

 dir="{%SADATADIR%}/web/log" filePrefix="sawlog" maxFileSizeKb="10000" filesN="10" />
 - maxFileSizeKb : Maximum log file size.
 - filesN : Number of log files.

 For example, the default total maximum log size is 10Mb x 10files = 100MB.

 jhostN.log.N

 Set the general Java logging parameters on $OracleBI/web/javahost/config/logconfig.txt.  For example:
 java.util.logging.FileHandler.pattern = /vol1/OracleBIData/web/log/javahost/jhost%u.log
 java.util.logging.FileHandler.limit = 10000000
 java.util.logging.FileHandler.count = 10

Note: you cannot rotate or limit the size of NQServer.log.  Instead delete or move it when the BI server stops.

No comments:

Post a Comment