alertlog.log

[root@centos7 trace]# cat alert_A001.log
Mon Aug 22 15:48:28 2016
Starting ORACLE instance (normal) (OS id: 32572)
Mon Aug 22 15:48:28 2016
CLI notifier numLatches:3 maxDescs:1674
Mon Aug 22 15:48:28 2016
**********************************************************************
Mon Aug 22 15:48:28 2016
Dump of system resources acquired for SHARED GLOBAL AREA (SGA)

Mon Aug 22 15:48:28 2016
 Per process system memlock (soft) limit = 64K
Mon Aug 22 15:48:28 2016
 Expected per process system memlock (soft) limit to lock
 SHARED GLOBAL AREA (SGA) into memory: 19G
Mon Aug 22 15:48:28 2016
 Available system pagesizes:
  4K, 2048K
Mon Aug 22 15:48:28 2016
 Supported system pagesize(s):
Mon Aug 22 15:48:28 2016
  PAGESIZE  AVAILABLE_PAGES  EXPECTED_PAGES  ALLOCATED_PAGES  ERROR(s)
Mon Aug 22 15:48:28 2016
        4K       Configured               6         4947974        NONE
Mon Aug 22 15:48:28 2016
     2048K             1765            9665               0        NONE
Mon Aug 22 15:48:28 2016
RECOMMENDATION:
Mon Aug 22 15:48:28 2016
 1. For optimal performance, configure system with expected number
 of pages for every supported system pagesize prior to the next
 instance restart operation.
Mon Aug 22 15:48:28 2016
 2. Increase per process memlock (soft) limit to at least 19GB
 to lock 100% of SHARED GLOBAL AREA (SGA) pages into physical memory
Mon Aug 22 15:48:28 2016
**********************************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 2
Number of processor cores in the system is 2
Number of processor sockets in the system is 1
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/oracle/product/12/d
bs/arch
Autotune of undo retention is turned on.
IMODE=BR
ILAT =167
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is local (mode 0x1; from cluster type)
NOTE: Using default ASM root directory ASM
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt
ions.
ORACLE_HOME = /u01/app/oracle/product/12
System name:    Linux
Node name:      centos7
Release:        2.6.32-642.3.1.el6.x86_64
Version:        #1 SMP Tue Jul 12 18:30:56 UTC 2016
Machine:        x86_64
Using parameter settings in client-side pfile /u01/app/oracle/product/12/dbs/ini
tA001.ora on machine centos7
System parameters with non-default values:
  processes                = 1000
  sessions                 = 1522
  sga_target               = 19328M
  control_files            = "/data/oradata/A001/control01.ctl"
  control_files            = "/data/oradata/A001/control02.ctl"
  db_block_size            = 8192
  compatible               = "12.1.0.2.0"
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=A001XDB)"
  audit_file_dest          = "/u01/app/oracle/admin/A001/adump"
  audit_trail              = "DB"
  db_name                  = "A001"
  open_cursors             = 300
  pga_aggregate_target     = 6431M
  diagnostic_dest          = "/u01/app/oracle"
NOTE: remote asm mode is local (mode 0x1; from cluster type)
Starting background process PMON
Starting background process PSP0
Mon Aug 22 15:48:38 2016
PMON started with pid=2, OS id=32575
Mon Aug 22 15:48:39 2016
PSP0 started with pid=3, OS id=32577
Starting background process VKTM
Starting background process GEN0
Mon Aug 22 15:48:40 2016
VKTM started with pid=4, OS id=32579 at elevated (RT) priority
Mon Aug 22 15:48:40 2016
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Starting background process MMAN
Mon Aug 22 15:48:43 2016
GEN0 started with pid=5, OS id=32583
Mon Aug 22 15:48:45 2016
MMAN started with pid=6, OS id=32585
Starting background process DIAG
Starting background process DBRM
Mon Aug 22 15:48:53 2016
DIAG started with pid=8, OS id=32589
Mon Aug 22 15:48:57 2016
Warning: VKTM detected a time drift.
Time drifts can result in an unexpected behavior such as time-outs. Please check
 trace file for more details.
Mon Aug 22 15:49:01 2016
DBRM started with pid=9, OS id=32591
Starting background process VKRM
Mon Aug 22 15:49:06 2016
VKRM started with pid=10, OS id=32593
Starting background process DIA0
Mon Aug 22 15:49:13 2016
DIA0 started with pid=11, OS id=32595
Starting background process DBW0
Mon Aug 22 15:49:20 2016
DBW0 started with pid=12, OS id=32597
Starting background process LGWR
Mon Aug 22 15:49:25 2016
LGWR started with pid=13, OS id=32599
Starting background process CKPT
Mon Aug 22 15:49:32 2016
CKPT started with pid=14, OS id=32601
Mon Aug 22 15:49:40 2016
Using default pga_aggregate_limit of 12862 MB
Starting background process SMON
Mon Aug 22 15:49:50 2016
SMON started with pid=16, OS id=32605
Starting background process RECO
Starting background process LREG
Mon Aug 22 15:50:11 2016
RECO started with pid=18, OS id=32613
Mon Aug 22 15:50:22 2016
LREG started with pid=19, OS id=32615
Starting background process PXMN
Starting background process MMON
Mon Aug 22 15:50:29 2016
PXMN started with pid=20, OS id=32617
Mon Aug 22 15:50:29 2016
MMON started with pid=7, OS id=32619
Starting background process MMNL
Mon Aug 22 15:50:29 2016
MMNL started with pid=21, OS id=32621
Mon Aug 22 15:50:30 2016
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL
=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/oracle
Mon Aug 22 15:51:28 2016
create database A001 user system identified by  user sys identified by  maxdataf
iles 100 maxinstances 8 character set AL32UTF8 national character set AL16UTF16
maxlogfiles 16 maxlogmembers 3 maxloghistory 1 noarchivelog  extent management l
ocal logfile group 1 '/data/oradata/A001/redo01.log' size 500M , group 2 '/data/
oradata/A001/redo02.log' size 500M , group 3 '/data/oradata/A001/redo03.log' siz
e 500M  datafile '/data/oradata/A001/system01.dbf' size 2000M reuse autoextend o
n maxsize unlimited sysaux datafile '/data/oradata/A001/sysaux01.dbf' size 2000M
 reuse autoextend on maxsize unlimited  default temporary tablespace TEMP tempfi
le '/data/oradata/A001/temp01.dbf' size 1000M reuse
  undo tablespace UNDOTBS1 datafile '/data/oradata/A001/undotbs01.dbf' size 3000
M reuse
Mon Aug 22 15:51:50 2016
Database mounted in Exclusive Mode
Lost write protection disabled
Mon Aug 22 15:52:04 2016
Successful mount of redo thread 1, with mount id 2464079824
Mon Aug 22 15:52:05 2016
Ping without log force is disabled
.
Buffer Cache Full DB Caching mode changing from FULL CACHING DISABLED to FULL CA
CHING ENABLED
Database SCN compatibility initialized to 1
Starting background process TMON
Mon Aug 22 15:52:05 2016
TMON started with pid=24, OS id=32636
Mon Aug 22 15:52:05 2016
Assigning activation ID 2464079824 (0x92dedfd0)
Thread 1 opened at log sequence 1
  Current log# 1 seq# 1 mem# 0: /data/oradata/A001/redo01.log
Successful open of redo thread 1
Mon Aug 22 15:52:06 2016
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Aug 22 15:52:07 2016
processing ?/rdbms/admin/dcore.bsq
Mon Aug 22 15:52:07 2016
SMON: enabling cache recovery
create tablespace SYSTEM datafile  '/data/oradata/A001/system01.dbf' size 2000M
reuse autoextend on maxsize unlimited
  EXTENT MANAGEMENT LOCAL online
Completed: create tablespace SYSTEM datafile  '/data/oradata/A001/system01.dbf'
size 2000M reuse autoextend on maxsize unlimited
  EXTENT MANAGEMENT LOCAL online
create rollback segment SYSTEM tablespace SYSTEM
  storage (initial 50K next 50K)
Mon Aug 22 15:52:30 2016
UNDO_SEG_CRT: Could not find usn tail
Completed: create rollback segment SYSTEM tablespace SYSTEM
  storage (initial 50K next 50K)
Mon Aug 22 15:53:31 2016
Caching undo dictionary info: used hint for object index=0
Caching undo dictionary info: used hint for object index=1
Caching undo dictionary info: used hint for object index=2
Caching undo dictionary info: used hint for object index=3
Caching undo dictionary info: used hint for object index=4
Undo initialization finished serial:0 start:2237694 end:2237754 diff:60 ms (0.1
seconds)
alter tablespace system force logging
Completed: alter tablespace system force logging
Mon Aug 22 15:56:22 2016
processing ?/rdbms/admin/dsqlddl.bsq
Mon Aug 22 15:57:34 2016
processing ?/rdbms/admin/dmanage.bsq
CREATE TABLESPACE sysaux DATAFILE  '/data/oradata/A001/sysaux01.dbf' size 2000M
reuse autoextend on maxsize unlimited
  EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE FORCE LOGGING
Completed: CREATE TABLESPACE sysaux DATAFILE  '/data/oradata/A001/sysaux01.dbf'
size 2000M reuse autoextend on maxsize unlimited
  EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE FORCE LOGGING
alter tablespace system default compress for all operations
Completed: alter tablespace system default compress for all operations
alter tablespace sysaux default compress for all operations
Completed: alter tablespace sysaux default compress for all operations
Mon Aug 22 15:57:51 2016
processing ?/rdbms/admin/dplsql.bsq
Mon Aug 22 16:00:17 2016
processing ?/rdbms/admin/dtxnspc.bsq
CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE  '/data/oradata/A001/undotbs01.dbf' siz
e 3000M reuse

Mon Aug 22 16:01:01 2016
[32626] Successfully onlined Undo Tablespace 2.
Completed: CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE  '/data/oradata/A001/undotbs
01.dbf' size 3000M reuse

CREATE TEMPORARY TABLESPACE TEMP TEMPFILE  '/data/oradata/A001/temp01.dbf' size
1000M reuse

Completed: CREATE TEMPORARY TABLESPACE TEMP TEMPFILE  '/data/oradata/A001/temp01
.dbf' size 1000M reuse

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
ALTER DATABASE DEFAULT TABLESPACE SYSTEM
Completed: ALTER DATABASE DEFAULT TABLESPACE SYSTEM
processing ?/rdbms/admin/dfmap.bsq
processing ?/rdbms/admin/denv.bsq
Mon Aug 22 16:01:47 2016
processing ?/rdbms/admin/drac.bsq
Mon Aug 22 16:03:00 2016
processing ?/rdbms/admin/dsec.bsq
Mon Aug 22 16:03:16 2016
WARNING: Heavy swapping observed on system in last 5 mins.
pct of memory swapped in [3.78%] pct of memory swapped out [2.34%].
Please make sure there is no memory pressure and the SGA and PGA
are configured correctly. Look at DBRM trace file for more details.
Errors in file /u01/app/oracle/diag/rdbms/a001/A001/trace/A001_dbrm_32591.trc  (
incident=73):
ORA-00700: soft internal error, arguments: [kskvmstatact: excessive swapping obs
erved], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/a001/A001/incident/incdir_73/A00
1_dbrm_32591_i73.trc
Mon Aug 22 16:04:12 2016
Dumping diagnostic data in directory=[cdmp_20160822160412], requested by (instan
ce=1, osid=32591 (DBRM)), summary=[incident=73].
Mon Aug 22 16:04:33 2016
Sweep [inc][73]: completed
Sweep [inc2][73]: completed
Mon Aug 22 16:11:44 2016
processing ?/rdbms/admin/doptim.bsq
Mon Aug 22 16:12:41 2016
processing ?/rdbms/admin/dobj.bsq
Mon Aug 22 16:14:14 2016
processing ?/rdbms/admin/djava.bsq
processing ?/rdbms/admin/dpart.bsq
Mon Aug 22 16:14:39 2016
processing ?/rdbms/admin/drep.bsq
[root@centos7 trace]#