您好,登錄后才能下訂單哦!
環境信息:
[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 <none>
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,沒有相關信息,后續繼續關注;
免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。