Dear gurus,
saya mendapatkan error di atas pada alert log di node 1 RAC production
database. karena error tersebut saya tidak bisa konek ke database dari node
1 (dari node 2 tidak masalah).
mohon pencerahan, saya sempet ambil AWR di node 1 pada waktu database ini
hang. berikut yang terdapat di Top 5 Timed Events :
Top 5 Timed Events
EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class CPU time 121 88.1
reliable message 280 17 59 12.1Other SGA: allocation forcing component
growth 1,140 11 10 8.1Other Streams AQ: qmn coordinator waiting for slave to
start 2 10 4,883 7.1Other control file sequential read 10,732 3 0 2.1System
I/O
apa yang menyebabkan database ini error ? ada yg bisa sharing pengalaman
nya. berikut yg ada di alert log,
ue Jul 13 12:18:09 2010
Errors in file /u01/oracle/admin/proddb/bdump/proddb1_j000_417970.trc:
ORA-12012: error on auto execute of job 42781
ORA-27468: "EXFSYS.RLM$SCHDNEGACTION" is locked by another process
There are 1051 memory allocation errors for object-level stat
in the last 15 minutes
Tue Jul 13 13:16:02 2010
Errors in file /u01/oracle/admin/proddb/bdump/proddb1_j000_704968.trc:
ORA-12012: error on auto execute of job 42781
ORA-27468: "EXFSYS.RLM$SCHDNEGACTION" is locked by another process
There is 1 memory allocation error for object-level stat
in the last 15 minutes
Tue Jul 13 14:13:34 2010
Errors in file /u01/oracle/admin/proddb/bdump/proddb1_j000_704968.trc:
ORA-12012: error on auto execute of job 42781
ORA-27468: "EXFSYS.RLM$SCHDNEGACTION" is locked by another process
There are 397 memory allocation errors for object-level stat
in the last 15 minutes
Tue Jul 13 14:36:56 2010
WARNING: ran out of shared pool for GES enqueue object.
Tue Jul 13 14:47:01 2010
WARNING: ran out of shared pool for GES enqueue object.
There are 7 memory allocation errors for object-level stat
in the last 15 minutes
Tue Jul 13 14:57:00 2010
Errors in file /u01/oracle/admin/proddb/bdump/proddb1_j000_704968.trc:
ORA-12012: error on auto execute of job 42780
ORA-27468: "EXFSYS.RLM$EVTCLEANUP" is locked by another process
Tue Jul 13 14:58:33 2010
WARNING: ran out of shared pool for GES enqueue object.
Tue Jul 13 14:58:33 2010
Trace dumping is performing id=[cdmp_20100713145836]
Tue Jul 13 14:58:55 2010
Errors in file /u01/oracle/admin/proddb/bdump/proddb1_j000_704968.trc:
ORA-12012: error on auto execute of job 2
ORA-04031: unable to allocate 3896 bytes of shared memory ("shared
pool","select sysdate + 1 / (24 * 6...","sga heap(1,0)","kglsim object
batch")
Tue Jul 13 14:58:55 2010
Errors in file /u01/oracle/admin/proddb/bdump/proddb1_j000_704968.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 3896 bytes of shared memory ("shared
pool","select sysdate+(2)/(24*60) f...","sga heap(1,0)","kglsim object
batch")
ORA-12012: error on auto execute of job 2
ORA-04031: unable to allocate 3896 bytes of shared memory ("shared
pool","select sysdate + 1 / (24 * 6...","sga heap(1,0)","kglsim object
batch")
Tue Jul 13 14:59:04 2010
WARNING: ran out of shared pool for GES enqueue object.
Tue Jul 13 14:59:35 2010
WARNING: ran out of shared pool for GES enqueue object.
Thanks,
--
Best Regards,
Andes
[Non-text portions of this message have been removed]
