Oracle IAS maintenance

Posted on 2009-12-23
Medium Priority
Last Modified: 2013-12-01
Are there any maintenance tasks for oracle ias 10g (forms and reports)? Eg. Clearing old logs or tunning etc? If yes please list them.
Question by:systemsautomation
  • 2
LVL 16

Expert Comment

by:Richard Olutola
ID: 26158544
As far as tuning is concerned, I'll let users say there is something wrong before worrying about that.

As for logs, ensure you rotate logs using httpd.conf
Then clean old logs in

$ORACLE_HOME/Apache/Apache/logs in both Identity Management tier and Middle-Tier

Also, clean logs in $ORACLE_HOME/webcache/logs

Finally, ensure you check the state of /tmp folder. This can fill up and stop middle-tier components from functioning until cleared.


Author Comment

ID: 26158633
Thanks for the answer. How to rotate log using httpd.conf?
LVL 16

Accepted Solution

Richard Olutola earned 2000 total points
ID: 26158701

Log Rotation      

On even a moderately busy server, the quantity of     information stored in the log files is very large. The access     log file typically grows 1 MB or more per 10,000 requests. It     will consequently be necessary to periodically rotate the log     files by moving or deleting the existing logs. This cannot be     done while the server is running, because Apache will continue     writing to the old log file as long as it holds the file open.     Instead, the server must be restarted after the log files are     moved or deleted so that it will open new log files.      
By using a graceful restart, the server can be     instructed to open new log files without losing any existing or     pending connections from clients. However, in order to     accomplish this, the server must continue to write to the old     log files while it finishes serving old requests. It is     therefore necessary to wait for some time after the restart     before doing any processing on the log files. A typical     scenario that simply rotates the logs and compresses the old     logs to save space is:            
    mv access_log access_log.old
           mv error_log error_log.old
           apachectl graceful
           sleep 600
           gzip access_log.old error_log.old          

Another way to perform log rotation is using piped logs as discussed in the next     section.          

Piped Logs      
Apache httpd is capable of writing error and access log     files through a pipe to another process, rather than directly     to a file. This capability dramatically increases the     flexibility of logging, without adding code to the main server.     In order to write logs to a pipe, simply replace the filename     with the pipe character "|", followed by the name     of the executable which should accept log entries on its     standard input. Apache will start the piped-log process when     the server starts, and will restart it if it crashes while the     server is running. (This last feature is why we can refer to     this technique as "reliable piped logging".)      
Piped log processes are spawned by the parent Apache httpd     process, and inherit the userid of that process. This means     that piped log programs usually run as root. It is therefore     very important to keep the programs simple and secure.      

Some simple examples using piped logs:            
# compressed logs
        CustomLog "|/usr/bin/gzip -c >>       /var/log/access_log.gz" common
        # almost-real-time name resolution
        CustomLog "|/usr/local/apache/bin/logresolve >>       /var/log/access_log" common          

Notice that quotes are used to enclose the entire command     that will be called for the pipe. Although these examples are     for the access log, the same technique can be used for the     error log.      
One important use of piped logs is to allow log rotation     without having to restart the server. The Apache HTTP Server     includes a simple program called rotatelogs for this     purpose.
For example, to rotate the logs every 24 hours, you     can use:            
CustomLog "|/usr/local/apache/bin/rotatelogs       /var/log/access_log 86400" common          

A similar, but much more flexible log rotation program     called cronolog     is available at an external site.      
As with conditional logging, piped logs are a very powerful     tool, but they should not be used where a simpler solution like     off-line post-processing is available.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.
Suggested Courses
Course of the Month16 days, 20 hours left to enroll

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question