Hi I am running an Oracle 10g XE instance on Windows XP which has worked fine for years until we recently started using Apex 4.2 with it. There have been two instance in the last week where the Windows service for Oracle has just stopped running, the Oracle processes is gone. The alert logs have no reports of errors, it is like the database is working and then all of a sudden nothing. The Windows Event Viewer also has nothing to report. Both times that it happened users were frequently refreshing the Apex page then all of a sudden the page doesn't load because Oracle is down. Oh and a lot of the data that is being shown in Apex is coming through a database link to a SQL Server Express instance if matters.
Anybody have any help on how to troubleshoot this issue?
>> the Windows service for Oracle has just stopped running
Well, sure sounds like something is crashing the instance.
But if you're not even getting alert log entries, there's not much to go on. For a Windows hosted instance, that service has to be running, the instance will not get through a startup without it.