Home > database >  Beg god to look at, the database down often can't find the reason
Beg god to look at, the database down often can't find the reason

Time:09-22

Linux host, a total of 16 nuclear 32 g, down at 4:00 PM whole machine time, will kill off the remote connection, database to reply,,, met several times before the
The process and job_queue_processes should be enough

Alert log as below attachment alert. The log

Thu Jul 19 15:59:33 2018
LGWR: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3135)
LGWR: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
Error 3135 for archive log file to 3 'uni - db - 2'
LGWR: Error 1041 disconnecting from destination LOG_ARCHIVE_DEST_2 standby host 'uni - db - 2'
Thu Jul 19 16:00:12 2018
The Process m000 died, see its trace file
Thu Jul 19 16:00:19 2018
The Process J000 died, see its trace file
Kkjcre1p: unable to spawn jobq slave process
Errors in the file/oracle/product/diag/RDBMS/DBNMS DBNMS/trace/dbnms_cjq0_23793 TRC:

Thu Jul 19 16:01:14 2018
The Process m000 died, see its trace file
Thu Jul 19 16:01:15 2018
WARNING: Heavy swapping observed on the system in the last 5 mins.
PCT of memory swapped in PCT [1.48%] of memory swapped out [3.62%].
Do make sure there is no memory pressure and the SGA and PGA
Are configured correctly. Look at DBRMS trace file for more details.
The Process J000 died, see its trace file
Kkjcre1p: unable to spawn jobq slave process
Errors in the file/oracle/product/diag/RDBMS/DBNMS DBNMS/trace/dbnms_cjq0_23793 TRC:
The Process J000 died, see its trace file
Kkjcre1p: unable to spawn jobq slave process
Errors in the file/oracle/product/diag/RDBMS/DBNMS DBNMS/trace/dbnms_cjq0_23793 TRC:

Thu Jul 19 16:05:04 2018
Starting ORACLE instance (normal)
Thu Jul 19 16:06:05 2018
Opiodr aborting process unknown ospid (21211) as a result of ORA - 609
Thu Jul 19 16:06:26 2018
Thread 1 always the allocate new log, a sequence of 36439
Private strand flush the not complete
Current log# seq# 36438 mem# 0:3/oradata1 DBNMS/redo03 log
LGWR: Failed to archive the log 3 thread 1 sequence, 36438 (3135)
Destination LOG_ARCHIVE_DEST_2 is UNSYNCHRONIZED
Thread 1 advanced to log sequence 36439 (LGWR switch)
Current log# 5 seq# 36439 mem# 0:/oradata1 DBNMS/redo05 log
Thu Jul 19 16:06:32 2018
Archived Log entry for the thread with a 37943 added 36438 ID 0, 1 sequence x31cb5ee3 dest 1:
Thu Jul 19 16:06:44 2018
Thread 1 always the allocate new log, a sequence of 36440
Private strand flush the not complete
Current log# 5 seq# 36439 mem# 0:/oradata1 DBNMS/redo05 log
LGWR: Standby redo logfile selected for thread 1 sequence 36440 for destination LOG_ARCHIVE_DEST_2
Thread 1 advanced to log sequence 36440 (LGWR switch)
Current log# 4 seq# mem# 0:36440/oradata1 DBNMS/redo04 log
Thu Jul 19 22:00:00 2018
Setting the Resource Manager to plan the SCHEDULER x318c [0] : DEFAULT_MAINTENANCE_PLAN via the SCHEDULER window
Setting the Resource Manager plan DEFAULT_MAINTENANCE_PLAN via the parameter
Thu Jul 19 22:00:00 2018
Starting background process VKRM
Thu Jul 19 22:00:00 2018
VKRM started with pid=105, OS id=15513
Thu Jul 19 22:00:10 2018
The Begin automatic SQL Tuning Advisor run for special Tuning task "SYS_AUTO_SQL_TUNING_TASK
"Thu Jul 19 22:00:45 2018
TABLE SYS. WRI $_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P90004 (918) VALUES LESS THAN (TO_DATE (' 10:10:20 2018-07-19 ', 'SYYYY - MM - DD HH24: MI: SS', 'NLS_CALENDAR=the GREGORIAN))
TABLE SYS. WRI $_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P90007 (918) VALUES LESS THAN (TO_DATE (' 10:10:23 2018-07-19 ', 'SYYYY - MM - DD HH24: MI: SS', 'NLS_CALENDAR=the GREGORIAN))
Thu Jul 19 22:04:54 2018
Thread 1 always the allocate new log, a sequence of 36463
Private strand flush the not complete
Current log# 2 seq# 36462 mem# 0:/oradata1 DBNMS/redo02 log
LGWR: Standby redo logfile selected for thread 1 sequence 36463 for destination LOG_ARCHIVE_DEST_2
Thread 1 advanced to log sequence 36463 (LGWR switch)
Current log# seq# 36463 mem# 0:3/oradata1 DBNMS/redo03 log
Thu Jul 19 22:05:06 2018
Archived Log entry for the thread with a 37992 added 36462 ID 0, 1 sequence x31cb5ee3 dest 1:
Thu Jul 19 22:13:45 2018
End automatic SQL Tuning Advisor run for special Tuning task "SYS_AUTO_SQL_TUNING_TASK
"Thu Jul 19 22:19:07 2018
Thread 1 always the allocate new log, a sequence of 36464
Private strand flush the not complete
Current log# seq# 36463 mem# 0:3/oradata1 DBNMS/redo03 log
LGWR: Standby redo logfile selected for thread 1 sequence 36464 for destination LOG_ARCHIVE_DEST_2
Thread 1 advanced to log sequence 36464 (LGWR switch)
Current log# 5 seq# 36464 mem# 0:/oradata1 DBNMS/redo05 log
Thu Jul 19 22:19:14 2018
Archived Log entry for the thread with a 37994 added 36463 ID 0, 1 sequence x31cb5ee3 dest 1:
=================================================================
Trace file/oracle/product/diag/RDBMS/DBNMS DBNMS/Trace/dbnms_cjq0_23793 TRC
Oracle Database 11 g Enterprise Edition Release 11.2.0.4.0-64 - bit Production
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
  • Related