Oracle IAS maintenance

Posted on 2009-12-23
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
    LVL 16

    Expert Comment

    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

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

    Accepted Solution


    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Suggested Solutions

    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    This post first appeared at Oracleinaction  ( 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…
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
    This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now