Wednesday, April 29, 2009

How to rename the access log file of the Oracle HTTP Server to include the date of the day it is created in?

We can rename the access log file of the Oracle HTTP Server to include the date of the day it is created in. Follow the below step to do it.

- For the 9iAS 1.0.2.x
1- Stop the HTTP Server2- Make a backup of $ORACLE_HOME/Apache/Apache/conf/httpd.conf:3- Open the file httpd.conf and search for something like the following line:
CustomLog "D:\oracle\FRM_REP_904\Apache\Apache\bin\rotatelogs logs/access_log 43200" common
where ORACLE_HOME=D:\oracle\FRM_REP_904
4 - Modify the httpd.conf file like this example; this will create a new access_log every 24 hours- 86400 seconds:
CustomLog "D:\oracle\FRM_REP_904\Apache\Apache\bin\rotatelogs logs/access_log 43200" common
CustomLog "D:\oracle\FRM_REP_904\Apache\Apache\bin\rotatelogs logs/access_log.%d%m%Y 86400"common
5 - Save the httpd.conf file6 - Start the HTTPServer again

II - For the 9iAS 9.0.2.x
1- Stop the HTTP Server:$ORACLE_HOME/dcm/bin/dcmctl stop -ct ohs -v -d
2- Make a backup of $ORACLE_HOME/Apache/Apache/conf/httpd.conf:
3- Open the file httpd.conf and search for something like the following line:
CustomLog "D:\oracle\FRM_REP_904\Apache\Apache\bin\rotatelogs logs/access_log 43200" common
where ORACLE_HOME=D:\oracle\FRM_REP_904
4 - Modify the httpd.conf file like this example; this will create a new access_log every 24 hours- 86400 seconds:
CustomLog "D:\oracle\FRM_REP_904\Apache\Apache\bin\rotatelogs logs/access_log 43200" common
CustomLog "D:\oracle\FRM_REP_904\Apache\Apache\bin\rotatelogs logs/access_log.%d%m%Y 86400"common
5 - Save the httpd.conf file
6- Apply the changes to the DCM Repository:$ORACLE_HOME/dcm/bin/dcmctl updateConfig -ct ohs -v -d
7- Start the HTTPServer again:$ORACLE_HOME/dcm/bin/dcmctl start -ct ohs -v -d

III For AS 10g , 9.0.4.x - 10.1.x
1- Stop the HTTP Server2- Make a backup of $ORACLE_HOME/Apache/Apache/conf/httpd.conf:
3- Open the file httpd.conf and search for something like the following line:
CustomLog "D:\oracle\FRM_REP_904\Apache\Apache\bin\rotatelogs logs/access_log 43200" common
where ORACLE_HOME=D:\oracle\FRM_REP_904
4 - Modify the httpd.conf file like this example; this will create a new access_log every 24 hours- 86400 seconds:
CustomLog "D:\oracle\FRM_REP_904\Apache\Apache\bin\rotatelogs logs/access_log 43200" common
CustomLog "D:\oracle\FRM_REP_904\Apache\Apache\bin\rotatelogs logs/access_log.%d%m%Y 86400"common
5 - Save the httpd.conf file
6- Apply the changes to the DCM Repository:$ORACLE_HOME/dcm/bin/dcmctl updateConfig -ct ohs -v -d
7- Start the HTTPServer again


Note: For the 9.0.2.x - 10.1.x , you can use the EM WebPage to change the httpd.conf file then you will no longer need to run the "dcmctl updateconfig" command.

1 comment:

Unknown said...

let me share my experience with regard to the service of sql server data recovery, it automatically eliminates data corruption issues in selected databases