Re: Oracle 10g XE service disappears

From: Jeff C <backseatdba_at_gmail.com>
Date: Thu, 14 Nov 2013 15:43:55 -0800
Message-ID: <CAKsxbLpDfdXTr8OMZPPsKLYEQ1aPYb3gxETFvQorM=azcz2W6w_at_mail.gmail.com>

Sorry we are running Windows XP. Thanks for that info.

On Thu, Nov 14, 2013 at 3:32 PM, De DBA <dedba_at_tpg.com.au> wrote:

> You don't mention the version of Windows.. At first glance, I would
> suspect that the process memory is exhausted which causes the oracle
> process to crash. Remember that unlike Unix platforms, on Windows oracle
> runs as a single process and all "processes" related to the instance are
> really threads within that process address space. This limits the combined
> oracle processes address space to 3GB (2GB user mode, 1GB kernel mode) on
> older (32-bit) Windows platforms, regardless of how much memory is
> installed. I could imagine that frequent reloading causes APEX to use a lot
> of memory, and that limit may be reached. Perhaps the eventlog shows
> entries from the Windows exec referring to an application popup or similar?
>
> Cheers,
> Tony
>
>
> On 14/11/13 08:06, Jeff C wrote:
>
>> We are running an Oracle 10g XE instance which has worked fine for years
>> but we recently started using Apex with it, upgraded to Apex 4.2. There
>> have been two instance in the last week where the Windows server for Oracle
>> has just stopped running, the Oracle processes is gone. The alert logs
>> have not 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 cause 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?
>>
>> Thanks.
>>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Nov 15 2013 - 00:43:55 CET