Windows & Oracle Issue
Date: Tue, 29 Mar 2016 18:16:42 +0000
Message-ID: <705afa5404a24aeca37179c584f53baf_at_544124-OEXCH02.ror-uc.rackspace.com>
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
[1]
Balwanth.bobilli_at_rackspace.com<mailto:Balwanth.bobilli_at_rackspace.com>
1-512-874-1764
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 29 2016 - 20:16:42 CEST