11.2.0.4 DB instance start alert for single instance

Fri Jan 03:11:17 2015DIAG started with pid=19, OS id=6031 dumping diagnostic data in directory=[cdmp_20150109031118], R Equested by (instance=1, osid=2456 (CJQ0)), summary=[incident=45657]. Mon Feb 01:51:09 2015Adjusting The default value of parameter Parallel_max_serversfrom due to the value of P Arameter processes (---) > Auto adjust parallel_max_servers parameters starting ORACLE instance (normal) ************************ Large Pages Information *******************per process system memlock (soft) limit = KB Total Shared Global region in L Arge Pages = 0 KB (0%)  Large pages used by this instance:0 (0 KB) Large pages unused system wide = 0 (0 KB) Large Pages configured system wide = 0 (0 KB) Large Page size = 2048 KB Recommendation:---> Recommended settings total System Global area size is 1026 MB. For optimal performance, prior to the next instance restart:1. Increase the number of unused large pages by at least 5 Page size 2048 KB, total size 1026 MB) system wide to get 100% of the SystEm Global area allocated with large pages 2. Large pages is automatically locked into physical memory. Increase the Per process Memlock (soft) limit to on least 1034 MB to lock 100% System Global area ' s large pages into Physi Cal Memory********************************************************************license_max_session = 0LICENSE_ Sessions_warning = 0Initial Number of CPU is 4---> CPU at startup cell communication is configured to use 0 interface (s): CEL L IP affinity Details:numa Status:non-numa System---> NUMA information at startup Cellaffinity.ora Status:n/acell Communication Would use 1 IP group (s): GRP 0:picked latch-free SCN scheme 3Using log_archive_dest_1 parameter default value as/u02/a Pp/oracle/product/11.2.0.4/db_1/dbs/archautotune of undo retention is turned on. Imode=brilat =27license_max_users = 0SYS auditing is disabledstarting up:oracle Database 11g Enterprise Edition Release 11 .2.0.4.0-64bit Productionwith The partitioning, OLAP, Data Mining and Real application TestinG Options. Oracle_home =/u02/app/oracle/product/11.2.0.4/db_1system Name:linuxnode name:rhel63singlerelease:2.6.32-279. el6.x86_64--->linux kernel version: #1 SMP Wed June 18:24:36 EDT 2012machine:x86_64 VMS name:vmware version:6---> Master Machine is VM virtual machine, version of VM virtual machine using parameter settings in Server-side spfile/u02/app/oracle/product/11.2.0.4/db_1/dbs/ Spfiletest.orasystem parameters with Non-default values:---> Previous row is the location of the read SPFile file at startup processes = SG A_max_size = 1G Shared_pool_size = 256M Java_pool_size = 256M Sga_target = 1G control_files = "/u01/app/oracle/oradata/test/control01.ctl" control_files = "/u01/app/oracle/o          Radata/test/control02.ctl "Db_block_size = 8192 compatible =" 11.2.0.0.0 "Undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" Db_domain = "dispatchers =" (PRO TOCOL=TCP) (service=testxdb) "Audit_file_dEST = "/u01/app/oracle/admin/test/adump" Audit_trail = "DB" db_name = "Test" Ope N_cursors = Pga_aggregate_target = 96M diagnostic_dest = "/u01/app/oracle" Mon Feb 09 01:51:  2015PMON started with pid=2, os id=2397 Mon Feb 01:51:13 2015psp0 started with pid=3, os id=2399 Mon Feb 09 01:51:15 2015VKTM started with pid=4, OS id=2401 @ elevated Prioritymon Feb 01:51:15 2015gen0 started with pid=5, OS id=2405 V KTM running at (1) millisec precision with DBRM quantum (+) Msmon Feb 01:51:15 2015DIAG started with pid=6, OS id=2407 Mon Feb 01:51:15 2015DBRM started with pid=7, OS id=2409 Mon Feb 01:51:15 2015dia0 started with pid=8, OS id=2411 Mo  N Feb 01:51:15 2015MMAN started with pid=9, OS id=2413 mon Feb 01:51:15 2015dbw0 started with pid=10, OS id=2415 Mon  Feb 01:51:15 2015LGWR started with pid=11, OS id=2417 mon Feb 01:51:15 2015CKPT started with pid=12, OS id=2419 Mon Feb 01:51:15 2015SMON started with pid=13, os id=2421 Mon Feb 01:51:15 2015RECO started with pid=14, os id=2423 Mon Feb 01:51:15 2015MMO N started with pid=15, OS id=2425 starting up 1 dispatcher (s) for network address ' (Address= (Partial=yes) (protocol=tcp)) '. .. Mon Feb 01:51:15 2015MMNL started with pid=16, OS id=2427 starting up 1 shared server (s) ... Oracle_base from environment =/u02/app/oraclemon Feb 01:51:17 2015ALTER DATABASE mountsuccessful Mount of Redo Threa D 1, with Mount ID 2169318165Database mounted in Exclusive modelost write protection Disabledcompleted:alter DATABASE M Ountmon Feb 01:51:22 2015ALTER DATABASE openbeginning crash Recovery of 1 threads parallel recovery started with 3 proc  essesstarted Redo scancompleted Redo Scan Read 7 KB redo, 0 data blocks need recoverystarted redo application at Thread 1: Logseq 124, Block 3492Recovery of Online Redo log:thread 1 Group 1 Seq 124 Reading mem 0 mem# 0:/u01/app/oracle/oradat a/test/redo01.logcompleted Redo Application of 0.00MBCompleted crash recovery at Thread 1:logseq 124, Block 3506, SCN 3065931 0 data blocks read, 0 data blocks written, 7 Redo K-bytes Readthread 1 advanced to log sequence (thread open) thread 1 opened at log sequence current log# 2 s eq# mem# 0:/u01/app/oracle/oradata/test/redo02.logsuccessful Open of Redo Thread 1MTTR advisory is disabled because F Ast_start_mttr_target is not setsmon:enabling cache recovery[2437] successfully onlined Undo tablespace 2.Undo Initializa tion finished serial:0 start:4867074 end:4868274 diff:1200 (seconds) verifying file header compatibility for 11g TABLESP Ace encryption.  Verifying 11g file Header compatibility for tablespace encryption completedsmon:enabling TX recoverydatabase Characterset is Zhs16gbkno Resource Manager plan activereplication_dependency_tracking turned off (no async multimaster replication fo und) starting background process Qmncmon Feb 01:51:29 2015QMNC started with pid=23, OS id=2465 Mon Feb 01:51:40 2015C ompleted: ALTER DATABASE openmon Feb 01:51:41 2015Starting background process Cjq0mon Feb 01:51:41 2015cjq0 started with PID =28, OS id=2483 Mon Feb 01:53:42 2015Shutting Instance (immediate) shutting down Instance:further logons disabledm On Feb 01:53:43 2015Stopping background process cjq0stopping Background process qmncstopping background process Mmnlsto Pping background process Mmonlicense High water mark = 13All Dispatchers and shared servers Shutdownalter DATABASE CLOSE N Ormalmon Feb 01:53:48 2015smon:disabling TX recoverysmon:disabling Cache Recoverymon Feb 01:53:48 2015Shutting Dow N Archive processesarchiving is disabledarchive process shutdown avoided:0 activethread 1 closed at log sequence 125Succe Ssful close of Redo thread 1completed:alter database close Normalalter database dismountshutting down archive Processesar Chiving is disabledcompleted:alter DATABASE dismountarch:archival disabled due to shutdown:1089shutting down archive PR Ocessesarchiving is DisaBledmon Feb 01:53:50 2015Stopping background process vktmarch:archival disabled due to shutdown:1089shutting down arc  Hive processesarchiving is disabledmon Feb 01:53:52 2015Instance shutdown completemon Feb 01:54:34 2015Adjusting the Default value of parameter Parallel_max_serversfrom due to the value of parameter processes (starting ORAC) LE instance (normal) ************************ Large Pages information *******************per process system Memlock (soft ) limit = KB Total Shared Global region in Large Pages = 0 KB (0%)  Large pages used by this instance:0 (0 KB) Large pages unused system wide = 0 (0 KB) Large Pages configured system wide = 0 (0 KB) Large Page size = 2048 KB recommendation:total System Global area size is 1026 MB. For optimal performance, prior to the next instance restart:1. Increase the number of unused large pages by at least 5 Page size 2048 KB, total size 1026 MB) system wide to get 100% of the system Global area allocated with Large pages 2. Large pages is automatically locked into physical memory. Increase the Per process Memlock (soft) limit to on least 1034 MB to lock 100% System Global area ' s large pages into Physi Cal Memory********************************************************************license_max_session = 0LICENSE_ Sessions_warning = 0Initial number of CPU is 4CELL communication are configured to use 0 interface (s): CELL IP Affinity Deta Ils:numa Status:non-numa system Cellaffinity.ora Status:n/acell communication would use 1 IP group (s): Grp 0:p icked latch-free SCN scheme 3Using log_archive_dest_1 parameter default value as/u02/app/oracle/product/11.2.0.4/db_1/ Dbs/archautotune of undo retention is turned on. Imode=brilat =27license_max_users = 0SYS auditing is disabledstarting up:oracle Database 11g Enterprise Edition Release 11 .2.0.4.0-64bit Productionwith The partitioning, OLAP, Data Mining and Real application testing options. Oracle_home =/u02/app/oracle/product/11.2.0.4/db_1sysTEM name:linuxnode name:rhel63singlerelease:2.6.32-279.el6.x86_64version: #1 SMP Wed June 18:24:36 EDT 2012Machine:x86 _64VM name:vmware version:6using parameter settings in Client-side Pfile/home/oracle/lei20150212.ora on machine rhel63si             Nglesystem parameters with Non-default values:---> Previous row is the location of the read Pfile file at startup processes = Sga_max_size = 1G Shared_pool_size = 256M Java_pool_size = 256M Sga_target = 1G control _files = "/u01/app/oracle/oradata/test/control01.ctl" control_files = "/u01/app/oracle/oradata/test /control02.ctl "Db_block_size = 8192 compatible =" 11.2.0.0.0 "undo_tablespace =" UND OTBS1 "remote_login_passwordfile=" EXCLUSIVE "Db_domain =" "Dispatchers =" (PROTOCOL=TCP) (service=testxdb) "audit_file_dest ="/u01/app/oracle/admin/test/adump "Audit_trail =" DB "Db_nam E = "Test"  Open_cursors = Pga_aggregate_target = 96M diagnostic_dest = "/u01/app/oracle" Mon Feb 09 0 1:54:37 2015PMON started with pid=2, os id=2519 Mon Feb 01:54:37 2015psp0 started with pid=3, os id=2521 Mon Feb 09 01: 54:38 2015VKTM started with pid=4, OS id=2523 at elevated Priorityvktm running @ (1) millisec precision with DBRM quantum Msmon Feb 01:54:38 2015gen0 started with pid=5, OS id=2527 Mon Feb 01:54:39 2015DIAG started with pid=6, OS id= 2529 Mon Feb 01:54:39 2015DBRM started with pid=7, OS id=2531 Mon 01:54:39 2015dia0 started with pid=8, OS id=25 Mon Feb 01:54:39 2015MMAN started with pid=9, OS id=2535 Mon Feb 01:54:39 2015dbw0 started with pid=10, OS id=253 7 Mon Feb 01:54:39 2015LGWR started with pid=11, OS id=2539 Mon Feb 01:54:39 2015CKPT started with pid=12, OS id=254 1 Mon Feb 01:54:39 2015SMON started with pid=13, OS id=2543 Mon Feb 01:54:39 2015RECO started with pid=14, OS id=254 5 Mon Feb 09 01:54:39 2015MMON started with pid=15, OS id=2547 Mon Feb 01:54:39 2015MMNL started with pid=16, OS id=2549 starting up 1 dispatch ER (s) for network address ' (Address= (Partial=yes) (protocol=tcp)) ' ... starting up 1 shared server (s) ... Oracle_base from environment =/u02/app/oraclemon Feb 01:54:39 2015ALTER DATABASE mountsuccessful Mount of Redo Threa D 1, with Mount ID 2169320159Database mounted in Exclusive modelost write protection Disabledcompleted:alter DATABASE M Ountmon 01:54:43 2015ALTER DATABASE openthread 1 opened at log sequence current log# 2 seq# mem# 0:/u01/a Pp/oracle/oradata/test/redo02.logsuccessful Open of Redo Thread 1MTTR advisory is disabled because FAST_START_MTTR_ TARGET is not setsmon:enabling cache recovery[2560] successfully onlined Undo tablespace 2.Undo initialization finished s erial:0 start:5067704 end:5068244 diff:540 (5 seconds) verifying file header compatibility for 11g tablespace encryption. Verifying 11g file header compatibility for TablespaCE encryption completedsmon:enabling TX recoverydatabase Characterset is ZHS16GBK---> database character set no Resource Manager plan Activereplication_dependency_tracking turned off (no async multimaster replication found) starting background process  Qmncmon Feb 01:54:49 2015QMNC started with pid=20, OS id=2562 Mon Feb 01:54:57 2015completed:alter DATABASE Openmon Feb 01:54:58 2015Starting Background process Cjq0mon Feb 01:54:58 2015cjq0 started with pid=22, OS id=2574 Mon Feb  01:59:50 2015Starting Background Process Smcomon Feb 01:59:50 2015SMCO started with pid=21, OS id=2620

11.2.0.4 DB instance start alert for single instance