RE: Windows & Oracle Issue

From: Kellyn Pot'Vin-Gorman <dbakevlar_at_gmail.com>
Date: Tue, 29 Mar 2016 20:50:14 -0600
Message-ID: <CAN6wuX0BytknHnqj_3bVSbz3vErTJCcRvrAVrO25=yo=S31d1A_at_mail.gmail.com>

Windows resource issues are trapped in the event logs. Please inspect the Event Ciewer under the System Tab for the time of the outage and it should correspond with the application log that trapped the Oracle Service daemon going down.

Kellyn
On Mar 29, 2016 8:19 PM, "Chitale, Hemant K" <Hemant-K.Chitale_at_sc.com> wrote:

> I would suspect that you are running out of Memory and CPU resources.
>
>
>
> Hemant K Chitale
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Balwanth Bobilli
> *Sent:* Wednesday, March 30, 2016 2:17 AM
> *To:* oracle-l_at_freelists.org
> *Subject:* Windows & Oracle Issue
>
>
>
> Product Oracle Database - Enterprise Edition
>
> Product Version:12.1.0.2
>
> Operating System :Microsoft Windows x64 (64-bit)
>
> OS Version: 2012 R2
>
>
>
> There are 80 SIDS sitting in one server and each as their own listener..
> Same setup in built in multiple servers… Random Databases go down without
> knowledge, All we need to do is restart the database and then it behaves
> well. It is production box and happening frequently…Moreover, there are
> only three windows scheduler jobs and we do not see any failure in it and
> those are small scripts.. Tail of the alert log of one DB, Can anyone say
> me how to find the root cause? It will be really helpful
>
>
>
>
>
> Suspending MMON action 'CLI AutoPartition' for 82800 seconds
> Mon Mar 28 07:47:30 2016
> Suspending MMON action 'tablespace alert monitor' for 82800 seconds
> Mon Mar 28 07:53:00 2016
> Suspending MMON action 'Cleanup of unpinned KGL handles' for 82800 seconds
> Mon Mar 28 07:58:37 2016
> Suspending MMON action 'flushing workload information for optimizer' for
> 82800 seconds
> Mon Mar 28 08:04:10 2016
> Suspending MMON action 'KSXM Advance DML Frequencies' for 82800 seconds
> Mon Mar 28 08:24:20 2016
> Suspending MMON action 'undo usage' for 82800 seconds
> Mon Mar 28 09:45:40 2016
> Suspending MMON action 'autotask status check' for 82800 seconds
> Mon Mar 28 11:27:23 2016
> Starting ORACLE instance (normal) (OS id: 90240)
> Mon Mar 28 11:27:23 2016
> CLI notifier numLatches:131 maxDescs:5068
> Mon Mar 28 11:27:23 2016
> Specified value of sga_max_size is too small, bumping to 3992977408
> SGA Local memory support enabled
> LICENSE_MAX_SESSION = 0
>
>
>
> Thanks,
>
> Balwanth(Bob)
>
> Oracle Database Administrator
>
> [image: 1]
>
> Balwanth.bobilli_at_rackspace.com
>
> 1-512-874-1764
>
>
>
> This email and any attachments are confidential and may also be
> privileged. If you are not the intended recipient, please delete all copies
> and notify the sender immediately. You may wish to refer to the
> incorporation details of Standard Chartered PLC, Standard Chartered Bank
> and their subsidiaries at https://www.sc.com/en/incorporation-details.html
>

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

Received on Wed Mar 30 2016 - 04:50:14 CEST