Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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

Posted on 2009-02-23
Medium Priority
Last Modified: 2013-12-18
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!
Question by:sqlagent007
  • 2
LVL 15

Expert Comment

by:Shaju Kumbalath
ID: 23718657
oradim -delete -sid sidname

oradim -new -sid sidname

Author Comment

ID: 23722961
Is there any logging I can do to see what triggers this issue?
LVL 15

Accepted Solution

Shaju Kumbalath earned 2000 total points
ID: 23731933
u can check alertlog,listerner log for any trace files generated.Also check event viewer for any application or system errors.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question