| Server hanging frequently [message #152760] |
Mon, 26 December 2005 23:42  |
sarfraz_attari
Messages: 123
Registered: July 2005
|
Senior Member |
|
|
We are using oracle 9i database on Linux 7.3.
Sometimes we are facing one strange problem, we can not connect to server through telnet from any client but we can ping the server from same client and when we are trying to connect any schema it is not allowing us to connect but the user already connected can work.
can anyone tell me the solution of this problem
currently we are restarting the server and it solve the problem
and we are facing this problem once in a week
Thanks
Sarfraz
|
|
|
|
| Re: Server hanging frequently [message #152860 is a reply to message #152760] |
Tue, 27 December 2005 05:39  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
I think some dead connection are still their so you have to kill the dead connection of the database because of this dead connection when you try new connection it is not allowing you. & when you restart the server all resource and dead connection are free thats why after restarting server u are able to connect to the Database.
Also check the network setting between your client machine and server machine.
Check number of user of your database maximum 150 for dedicated server. and if user is more than 150 then it must be in MTS mode.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
