Specified value of sga_max_size is too small, bumping to 46170898432
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
WARNING: db_recovery_file_dest is same as db_create_online_log_dest_1
IMODE=BR
ILAT =182
LICENSE_MAX_USERS = 0
SYS auditing is enabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.5.0.
System parameters with non-default values:
processes = 900
sessions = 1660
resource_limit = TRUE
sga_max_size = 46170898432
__shared_pool_size = 10770972672
shared_pool_size = 10737418240
__large_pool_size = 67108864
__java_pool_size = 67108864
__streams_pool_size = 16777216
nls_language = AMERICAN
nls_territory = AMERICA
nls_length_semantics = BYTE
resource_manager_plan =
sga_target = 46170898432
control_files = +FRA1/dbairs2/controlfile/current.259.1009559809
control_file_record_keep_time= 60
db_block_size = 8192
__db_cache_size = 35232153600
db_cache_size = 31457280000
compatible = 10.2.0.5.0
log_archive_dest_1 = LOCATION=USE_DB_RECOVERY_FILE_DEST
log_archive_dest_state_1 = ENABLE
log_archive_dest_state_2 = ALTERNATE
log_checkpoint_timeout = 0
db_create_file_dest = +DATA1
db_create_online_log_dest_1= +FRA1
db_create_online_log_dest_2=
db_recovery_file_dest = +FRA1
db_recovery_file_dest_size= 526133493760
fast_start_mttr_target = 60
log_checkpoints_to_alert = TRUE
db_flashback_retention_target= 1440
undo_management = AUTO
undo_tablespace = UNDOTBS
undo_retention = 14400
fast_start_parallel_rollback= FALSE
remote_login_passwordfile= EXCLUSIVE
audit_sys_operations = TRUE
db_domain = GRFC.RU
service_names = DBAIRS2.GRFC.RU, DBAIRS2.grfc.ru
dispatchers = (PROTOCOL=TCP) (SERVICE=DBAIRS2XDB)
session_cached_cursors = 750
plsql_native_library_dir = /u01/oracle/product/10.2.0/db_1/plsql/lib
job_queue_processes = 20
parallel_min_servers = 20
background_dump_dest = /u01/oracle/product/10.2.0/db_1/admin/DBAIRS2/bdump
user_dump_dest = /u01/oracle/product/10.2.0/db_1/admin/DBAIRS2/udump
core_dump_dest = /u01/oracle/product/10.2.0/db_1/admin/DBAIRS2/cdump
audit_file_dest = /u01/oracle/product/10.2.0/db_1/admin/DBAIRS2/adump
audit_trail = DB, EXTENDED
sort_area_size = 65536
sort_area_retained_size = 0
db_name = DBAIRS2
open_cursors = 20000
optimizer_mode = FIRST_ROWS
pga_aggregate_target = 19327352832
statistics_level = TYPICAL
optimizer_secure_view_merging= FALSE
PMON started with pid=2, OS id=2317
Fri May 31 15:38:19 MSK 2019
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=airs2db6)(PORT=1521))'
PSP0 started with pid=3, OS id=2319
MMAN started with pid=4, OS id=2321
DBW0 started with pid=5, OS id=2323
DBW1 started with pid=6, OS id=2325
LGWR started with pid=7, OS id=2327
CKPT started with pid=8, OS id=2330
SMON started with pid=9, OS id=2332
RECO started with pid=10, OS id=2334
CJQ0 started with pid=11, OS id=2336
MMON started with pid=12, OS id=2338
Fri May 31 15:38:20 MSK 2019
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=13, OS id=2340
Fri May 31 15:38:20 MSK 2019
starting up 1 shared server(s) ...
Fri May 31 15:38:20 MSK 2019
dispatcher 'D000' encountered error getting listening address
Fri May 31 15:38:20 MSK 2019
Errors in file /u01/oracle/product/10.2.0/db_1/admin/DBAIRS2/bdump/dbairs2_ora_2342.trc:
ORA-07445: exception encountered: core dump [kslgetl()+120] [SIGSEGV] [Address not mapped to object] [0x000000210] [] []
ORA-00108: failed to set up dispatcher to accept connection asynchronously
Fri May 31 15:38:20 MSK 2019
ALTER DATABASE MOUNT
Fri May 31 15:38:23 MSK 2019
Starting background process ASMB
ASMB started with pid=14, OS id=2390
Starting background process RBAL
RBAL started with pid=37, OS id=2394
Fri May 31 15:38:27 MSK 2019
SUCCESS: diskgroup FRA1 was mounted
Fri May 31 15:38:31 MSK 2019
Setting recovery target incarnation to 2
Fri May 31 15:38:31 MSK 2019
Successful mount of redo thread 1, with mount id 1458434031
Fri May 31 15:38:31 MSK 2019
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri May 31 15:38:31 MSK 2019
ALTER DATABASE OPEN
Fri May 31 15:38:31 MSK 2019
SUCCESS: diskgroup DATA1 was mounted
Fri May 31 15:38:31 MSK 2019
Beginning crash recovery of 1 threads
parallel recovery started with 15 processes
Fri May 31 15:38:32 MSK 2019
Started redo scan
Fri May 31 15:38:33 MSK 2019
Completed redo scan
995700 redo blocks read, 38759 data blocks need recovery
Fri May 31 15:38:33 MSK 2019
Started redo application at
Thread 1: logseq 31, block 3
Fri May 31 15:38:33 MSK 2019
Recovery of Online Redo Log: Thread 1 Group 5 Seq 31 Reading mem 0
Mem# 0: +FRA1/dbairs2/onlinelog/group_5.275.1009624457
Fri May 31 15:38:40 MSK 2019
Completed redo application
Fri May 31 15:38:40 MSK 2019
Completed crash recovery at
Thread 1: logseq 31, block 995703, scn 367645922471
38759 data blocks read, 38759 data blocks written, 995700 redo blocks read
Fri May 31 15:38:40 MSK 2019
Thread 1 advanced to log sequence 32 (thread open)
Thread 1 opened at log sequence 32
Current log# 6 seq# 32 mem# 0: +FRA1/dbairs2/onlinelog/group_6.277.1009624461
Successful open of redo thread 1
Fri May 31 15:38:40 MSK 2019
SMON: enabling cache recovery
Fri May 31 15:38:40 MSK 2019
Successfully onlined Undo Tablespace 40.
Fri May 31 15:38:40 MSK 2019
SMON: enabling tx recovery
Fri May 31 15:38:40 MSK 2019
Database Characterset is CL8MSWIN1251
Opening with internal Resource Manager plan
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=39, OS id=2403
Fri May 31 15:38:41 MSK 2019
Completed: ALTER DATABASE OPEN
Fri May 31 15:38:41 MSK 2019
db_recovery_file_dest_size of 501760 MB is 2.66% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Starting background process EMN0
EMN0 started with pid=44, OS id=2415
Fri May 31 15:38:44 MSK 2019
Errors in file /u01/oracle/product/10.2.0/db_1/admin/DBAIRS2/bdump/dbairs2_pmon_2317.trc:
ORA-07445: exception encountered: core dump [kmmlrl()+4223] [SIGSEGV] [Address not mapped to object] [0x000000010] [] []
Fri May 31 15:39:22 MSK 2019
PSP0: terminating instance due to error 472
Instance terminated by PSP0, pid = 2319