Oracle 10g on windows will suddenly hang and user connections will not connect

I have the weirdest thing....I don't think anybody will solve the issue, but I am looking for a place to start. I have an Oracle 10g instance on Windows 2003 server. The database has been working fine for a while. Recently, though the database will just appear to hang, the services are all running just fine, and TNSPING works to the database, however when the application tries to connect, it will timeout. When I try to use SQLplus /nolog to connect for testing I don't get any indication that the database is down, however I never the the "connected" output that I normally get when I connect. Nor do I get the "connected to an idle instance" like I have in the past when then app times out. I fix this by restarting the oracle services through the window services.msc applet. Where can I even start looking to fix this issue?

Thanks experts!
LVL 1
sqlagent007Asked:
Who is Participating?
 
Shaju KumbalathDeputy General Manager - ITCommented:
u can check alertlog,listerner log for any trace files generated.Also check event viewer for any application or system errors.
 
0
 
Shaju KumbalathDeputy General Manager - ITCommented:
try
oradim -delete -sid sidname

recreate
oradim -new -sid sidname
0
 
sqlagent007Author Commented:
Is there any logging I can do to see what triggers this issue?
0
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.

All Courses

From novice to tech pro — start learning today.