Oracle 9i Error_log problem

[atikku]

I have Oracle 9i Database on Windows XP Pro on Pentium 4/ 256MB RAM machine.
I have a peculiar problem. The error_log file in c:/Oracle/ora92/apache/apache/errorlog keeps increasing in size rapidly, until my whole hard disc of 37GB gets used up. The first time I had this problem, I thought it was some virus, then I traced it to this file. Now I replace this file with a blank error_log file to keep the size down. Can anyone tell me what the cause and solution of this problem is.
Help appreciated!

 

[sem]

So what errors does it contain?

Regards, Dima

 

[atikku]

I am not able to open this error_log file as it is always being updated and is locked. My problem is that this file balloons up to 35GB !! until I get a system error saying that I all my memory is used up.

Angie

 

[sem]

Is it locked for reading also? I should say that amount of memory is quite small for Oracle with web sever. I'd recommend you to stop your database and web server, delete this file and start them again. Then you may view that file.

Regards, Dima

 

[sjgriffiths]

The error log file contains the following:-

[Tue Jul 29 19:14:45 2003] [notice] FastCGI: process manager initialized
[Tue Jul 29 19:14:46 2003] [warn] FastCGI: server "c:/oracle/ora92/bin/isqlplus"
started (pid 440)
[Tue Jul 29 19:14:46 2003] [warn] FastCGI: server "c:/oracle/ora92/bin/isqlplus"
(pid 440) terminated with exit with status '3373184'
[Tue Jul 29 19:14:50 2003] [warn] FastCGI: server "c:/oracle/ora92/bin/isqlplus"
restarted (pid 2792)
[Tue Jul 29 19:14:53 2003] [warn] FastCGI: server "c:/oracle/ora92/bin/isqlplus"
(pid 2792) terminated with exit with status '3373184'

etc, etc for 37Gb or 9 in my case. I found out the contents, but not the solution yet, by stopping the apache server, deleting the log file, starting and stopping the server very quickly, and then looking at the log file using notebook, or even MSDOS! by moreing the file. Anyone have any ideas now please, because I can't really get going until I solve this problem.

TIA, Stephen

 

[atikku]

I still dont know what causes it, but since I was just using the Oracle database and not the web server, my only problem was that this errorlog was using up whole of my hard disc space. I made the error_log file read only and for me the problem seems to be fixed up.

Annie

 

[sem]

Why don't you just STOP Apache and don't start it again? I'm also sure you may prevent Apache from starting isqlplus by editing httpd.conf.

Regards, Dima

 

[sjgriffiths]

I appreciate that stopping the apache server clears the problem, but the problems shouldn't exist. Good on you Oracle! What does isqlplus do?, and should it be running so that the error doesn't occur. All I've done is a clean install of the Oracle database, and the machine falls over, unless I take action. Not a good start to using Oracle. If I edit the httpd.conf file, it has no mention of isqlplus. That is is in the oracle_apache.conf file and seems to be commented out! Over to an Oracle expert to help a beginner please,

Stephen

 

[sem]

AFAIK isqlplus provides sql*plus functionality over the Web. I found similar case when the problem was with duplicate entries of isqlplus.conf. Check httpd.conf file with all included ones.

Regards, Dima