Home > database >  Oracle launched two minutes down 474: SMON process terminated with error
Oracle launched two minutes down 474: SMON process terminated with error

Time:09-21

Such as oracle start two minutes to hang up, 607 and 600 error according to the online query file 609 pieces of 6 to a data object, alert_orcl log as follows, to solve the
Sun Sep 9 17:10:59 2018
Starting ORACLE instance (normal)
Sskgpgetexecname failed to get the name
LICENSE_MAX_SESSION=0
LICENSE_SESSIONS_WARNING=0
Picked latch - free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT=61
LICENSE_MAX_USERS=0
SYS auditing is disabled
Ksdpec: called for event 13740 the prior to the event group initialization
Starting up the ORACLE RDBMS Version: 10.2.0.4.0.
The System parameters with non - the default values:
The processes=500
Sessions=555
The event=10513 trace name context forever, level 2
Sga_max_size=18874368000
__shared_pool_size=738197504
__large_pool_size=16777216
__java_pool_size=33554432
__streams_pool_size=16777216
Nls_language='
Sga_target=18874368000
Control_files=/u01/app/oracle/oradata/former/control01 CTL,/u01/app/oracle/oradata/former/control02 CTL,/u01/app/oracle/oradata/former/control03 CTL
Control_file_record_keep_time=31
Db_block_size=8192
__db_cache_size=18052284416
Compatible=10.2.0.3.0
Log_archive_dest_1=location=/u01/app/oracle/oradata/former/archive
Db_files=2048
Db_file_multiblock_read_count=16
Db_recovery_file_dest=/u01/app/oracle/oradata flash_recovery_area
Db_recovery_file_dest_size=94266982400
_allow_resetlogs_corruption=TRUE
Undo_management=AUTO
Undo_tablespace=UNDOS
Undo_retention appropriately=10800
Remote_login_passwordfile=EXCLUSIVE
Audit_sys_operations=FALSE
Db_domain=
Dispatchers=(TCP) PROTOCOL=(SERVICE=orclXDB)
Session_cached_cursors=1000
Job_queue_processes=10
Cursor_sharing=FORCE
Background_dump_dest=/u01/app/oracle/admin/former/bdump
User_dump_dest=/u01/app/oracle/admin/former/udump
Core_dump_dest=/u01/app/oracle/admin/former/cdump
Audit_file_dest=/u01/app/oracle/admin/former/adump
Audit_trail=NONE
Db_name=former
Open_cursors=1500
Pga_aggregate_target=4951375872
PMON started with pid=2, OS id=42139748
PSP0 started with pid=3, OS id=22020104
MMAN started with pid=4, OS id=13303998
DBW0 started with pid=5, OS id=58458330
DBW1 started with pid=6, OS id=50593826
DBW2 started with pid=7, OS id=29098136
LGWR started with pid=8, OS id=39714858
CKPT started with pid=9, OS id=30736554
SMON started with pid=10, OS id=25034810
RECO started with pid=11, OS id=11075810
CJQ0 started with pid=12, OS id=56950896
MMON started with pid=13, OS id=27721848
Sun Sep 9 17:11:00 2018
Starting up a dispatcher (s) for the network address '(address=(PARTIAL=YES) (TCP) PROTOCOL=)'...
MMNL started with pid=14, OS id=54526100
Sun Sep 9 17:11:00 2018
Starting up a Shared server (s)...
Sun Sep 9 17:11:00 2018
The ALTER DATABASE MOUNT
Sun Sep 9 17:11:07 2018
Setting recovery target incarnation to 6
Sun Sep 9 17:11:07 2018
Successful mount of redo thread 1, with the mount id 1514171175
Sun Sep 9 17:11:07 2018
The Database mounted in Exclusive Mode
Completed: the ALTER DATABASE MOUNT
Sun Sep 9 17:11:07 2018
The ALTER DATABASE OPEN
Sun Sep 9 17:11:07 2018
Thread 1 the opened at the log sequence 74
Current log# 5 seq# mem# 0:74/u01/app/oracle/oradata/former/redo05. DBF
Successful open of redo thread 1
Sun Sep 9 17:11:07 2018
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sun Sep 9 17:11:07 2018
SMON: enabling cache recovery
Sun Sep 9 17:11:09 2018
Successfully onlined Undo in Tablespace 17.
Sun Sep 9 17:11:09 2018
SMON: enabling tx recovery
Sun Sep 9 17:11:09 2018
The Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
Where the NUMA PG=1, CPUs=24
Replication_dependency_tracking turned off (no async multimaster replication found)
Sun Sep 9 17:11:09 2018
Errors in the file/u01/app/oracle/admin/former/bdump/orcl_smon_25034810 TRC:
ORA - 00600: internal error code, the arguments: [kddummy_blkchk], [609], [6], [18018], [], [], [], []
Starting background process QMNC
QMNC started with pid=19, OS id=28180686
Sun Sep 9 17:11:10 2018
Completed: the ALTER DATABASE OPEN
Sun Sep 9 17:11:10 2018
Db_recovery_file_dest_size of 89900 MB is 0.00% 2. This is a
User - specified limit on the amount of space that will be 2 by this
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
  • Related