• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 550
  • Last Modified:

Oracle IAS maintenance

Are there any maintenance tasks for oracle ias 10g (forms and reports)? Eg. Clearing old logs or tunning etc? If yes please list them.
  • 2
1 Solution
Richard OlutolaConsultantCommented:
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.

systemsautomationAuthor Commented:
Thanks for the answer. How to rotate log using httpd.conf?
Richard OlutolaConsultantCommented:

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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now