Oracle12.2Heavyswapping数据库自动关闭
环境信息:
创新互联建站专业为企业提供大渡口网站建设、大渡口做网站、大渡口网站设计、大渡口网站制作等企业网站建设、网页设计与制作、大渡口企业网站模板建站服务,十年大渡口做网站经验,不只是建网站,更提供有价值的思路和整体网络服务。
[root@oralinux7p5 ~]# free
total used free shared buff/cache available
Mem: 3781940 646936 2357604 1804 777400 3056192
Swap: 9437180 586452 8850728
Trace file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_dbrm_28582.trc
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Build label: RDBMS_12.2.0.1.0_LINUX.X64_170125
ORACLE_HOME: /u01/app/oracle/product/12.2.0/dbhome_1
System name: Linux
Node name: oralinux7p5
Release: 4.1.12-112.16.4.el7uek.x86_64
Version: #2 SMP Mon Mar 12 23:57:12 PDT 2018
Machine: x86_64
Instance name: orcl
Redo thread mounted by this instance: 0
Oracle process number: 14
Unix process pid: 28582, image: oracle@oralinux7p5 (DBRM)
问题表现:
导入DMP文件时,alert日志提示:
PL/SQL: Statement ignored
2018-09-26T16:57:58.233928+08:00
WARNING: Heavy swapping observed on system in last 5 mins.
Heavy swapping can lead to timeouts, poor performance, and instance eviction.
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_dbrm_3178.trc (incident=36114):
ORA-00700: soft internal error, arguments: [kskvmstatact: excessive swapping observed], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_36114/orcl_dbrm_3178_i36114.trc
2018-09-26T16:58:01.348446+08:00
Dumping diagnostic data in directory=[cdmp_20180926165801], requested by (instance=1, osid=3178 (DBRM)), summary=[incident=36114].
………………………………………………
………………………………………………
2018-09-26T17:03:40.929681+08:00
Shutting down instance (immediate) (OS id: 23037)
Stopping background process SMCO
2018-09-26T17:03:42.789507+08:00
Shutting down instance: further logons disabled
2018-09-26T17:03:44.027733+08:00
Stopping background process CJQ0
2018-09-26T17:03:44.053983+08:00
Stopping background process MMNL
2018-09-26T17:03:45.054174+08:00
Stopping background process MMON
2018-09-26T17:03:46.055283+08:00
License high water mark = 28
2018-09-26T17:03:46.076574+08:00
OS process OFSD (ospid 3174) idle for 30 seconds, exiting
2018-09-26T17:03:46.218176+08:00
Dispatchers and shared servers shutdown
2018-09-26T17:03:48.233021+08:00
ALTER DATABASE CLOSE NORMAL
2018-09-26T17:03:48.461838+08:00
Stopping Emon pool
Stopping Emon pool
2018-09-26T17:03:49.667379+08:00
Shutting down archive processes
2018-09-26T17:03:49.679317+08:00
TT00: Gap Manager exiting (PID:3241)
2018-09-26T17:03:50.668074+08:00
Archiving is disabled
2018-09-26T17:03:50.691130+08:00
Thread 1 closed at log sequence 88
Successful close of redo thread 1
2018-09-26T17:03:51.334888+08:00
Completed: ALTER DATABASE CLOSE NORMAL
ALTER DATABASE DISMOUNT
Shutting down archive processes
Archiving is disabled
Completed: ALTER DATABASE DISMOUNT
2018-09-26T17:03:52.388448+08:00
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
2018-09-26T17:03:53.424516+08:00
JIT: pid 23037 requesting stop
2018-09-26T17:03:54.425072+08:00
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
2018-09-26T17:03:54.445832+08:00
Stopping background process VKTM
2018-09-26T17:03:54.481661+08:00
JIT: pid 23037 requesting stop
2018-09-26T17:03:58.583064+08:00
Instance shutdown complete (OS id: 23037)
[oracle@oralinux7p5 trace]$
原因:
查metalink,没有相关信息,后续继续关注;
文章名称:Oracle12.2Heavyswapping数据库自动关闭
文章链接:http://azwzsj.com/article/gcocce.html