Re: Windows & Oracle Issue

there were many useful responses, I'm also under the impression that you have overcommitted your system resources. But I just would like to add a suggestion how to generally find out why clusterware starts/stops services. Your DIAG/.../trace directory contains a bunch of useful files: ocssd.trc (general cluster concern/activities, disk and network heartbeat, etc.) crsd.trc (starting/stopping services like listeners and databases) oraagent_crs.trc / orarootagent_crs.trc (output of scripts and processes when started/stopped on behalf of the crs-centric agents).

As I said, just a general information, maybe useful when wondering what OCW does.

-- 
Martin Klier | Performing Databases GmbH 
Managing Partner | Senior DB Consultant 
Oracle ACE 

martin.klier_at_performing-db.com | http://www.performing-databases.com 



> Von: "Balwanth Bobilli" <Balwanth.Bobilli_at_rackspace.com>

> An: oracle-l_at_freelists.org

> Gesendet: Dienstag, 29. März 2016 20:16:42

> Betreff: 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




> Balwanth.bobilli_at_rackspace.com




> 1-512-874-1764


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