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

Posted on 2009-02-23
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
    LVL 15

    Expert Comment

    by:Shaju Kumbalath
    oradim -delete -sid sidname

    oradim -new -sid sidname
    LVL 1

    Author Comment

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

    Accepted Solution

    u can check alertlog,listerner log for any trace files generated.Also check event viewer for any application or system errors.

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now