Oracle 10g on windows will suddenly hang and user connections will not connect
Posted on 2009-02-23
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?