| web site probelm using oracle 10g [message #178746] |
Thu, 22 June 2006 07:43  |
rahulvasanth
Messages: 34
Registered: January 2006
|
Member |
|
|
Hi
I have developed a web site which has already gone live. It worked fine for first few days. But now I m facing a new issue.
After every 6 - 8 hrs, the web site crashes because it is not getting data from the DB. I m using Oracle 10g as the backend DB.
If I refresh the web app, the it starts working again. Has any one faced a similar problem ? Why is the web site losing the connection with the DB after every 6- 8 hrs. My guess is , it is something to do with the DB connection.
Can anyone help me out on this ?
Thanking in advance
|
|
|
|
| Re: web site probelm using oracle 10g [message #178749 is a reply to message #178746] |
Thu, 22 June 2006 07:49  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>> If I refresh the web app, the it starts working again
What do you mean by that?
>>Why is the web site losing the connection with the DB after every 6- 8 hrs
Do you want your web-app to be "connected" to the database 24x7?
Why? Should'nt it be like, whenever you need something (in webapp) to be done in backend, web app should connect.
May be you have some session timeout or idle time defined.
Did you check the database log?
[Updated on: Thu, 22 June 2006 07:50] Report message to a moderator |
|
|
|
| Re: web site probelm using oracle 10g [message #178751 is a reply to message #178749] |
Thu, 22 June 2006 07:58 |
rahulvasanth
Messages: 34
Registered: January 2006
|
Member |
|
|
|
No, the web app is not connected 24 x 7 to the DB. But as the number of hits to the site increases, the web site goes down because it is not getting the dat from the DB. I have checked everything. But I could not locate the fault.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
