Цитата: OlegON ➤ Не надо гадать, большинство ответов - в конкретных ошибках журнала. Какие там сейчас?
К примеру, я удалил alert.log, после чего открыл сессию в sqlplus:
C:\Users\Administrator.WIN-9LCOTV2IE5L>sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Вт Апр 1 10:47:20 2025
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn sys/qqq as sysdba
Соединено.
SQL> select status from v$instance;
STATUS
------------
MOUNTED
SQL> shutdown immediate
ORA-01109: база данных не открыта
База данных размонтирована.
Экземпляр ORACLE завершен.
SQL> startup
Экземпляр ORACLE запущен.
Total System Global Area 1610612736 bytes
Fixed Size 2066080 bytes
Variable Size 385878368 bytes
Database Buffers 1207959552 bytes
Redo Buffers 14708736 bytes
База данных смонтирована.
База данных открыта.
SQL> select status from v$instance;
ERROR:
ORA-03114: нет связи с ORACLE
LOG:
Tue Apr 01 10:47:14 2025
WARNING: inbound connection timed out (ORA-3136)
Tue Apr 01 10:47:15 2025
WARNING: inbound connection timed out (ORA-3136)
Tue Apr 01 10:47:23 2025
WARNING: inbound connection timed out (ORA-3136)
Tue Apr 01 10:47:40 2025
Shutting down instance: further logons disabled
Tue Apr 01 10:47:40 2025
Stopping background process CJQ0
Tue Apr 01 10:47:40 2025
Stopping background process MMNL
Tue Apr 01 10:47:41 2025
Background process MMNL not dead after 10 seconds
Tue Apr 01 10:47:41 2025
Stopping background process MMON
Tue Apr 01 10:47:42 2025
Background process MMON not dead after 30 seconds
Tue Apr 01 10:47:42 2025
Shutting down instance (immediate)
License high water mark = 2
Tue Apr 01 10:47:42 2025
Stopping Job queue slave processes, flags = 7
Tue Apr 01 10:47:42 2025
Job queue slave processes stopped
Tue Apr 01 10:47:42 2025
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Tue Apr 01 10:47:42 2025
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Apr 01 10:47:57 2025
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =182
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
processes = 1500
sessions = 1655
__shared_pool_size = 352321536
__large_pool_size = 16777216
__java_pool_size = 16777216
__streams_pool_size = 0
sga_target = 1610612736
control_files = D:\ORACLE\ORADATA\STARCO\CONTROL01.CTL, D:\ORACLE\ORADATA\STARCO\CONTROL02.CTL, D:\ORACLE\ORADATA\STARCO\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 1207959552
compatible = 10.2.0.4.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:\oracle\flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDO
O7_DICTIONARY_ACCESSIBILITY= TRUE
remote_login_passwordfile= EXCLUSIVE
db_domain =
job_queue_processes = 10
audit_file_dest = D:\ORACLE\ADMIN\STARCO\ADUMP
background_dump_dest = D:\ORACLE\ADMIN\STARCO\BDUMP
user_dump_dest = D:\ORACLE\ADMIN\STARCO\UDUMP
core_dump_dest = D:\ORACLE\ADMIN\STARCO\CDUMP
db_name = starco
open_cursors = 300
pga_aggregate_target = 1049624576
PMON started with pid=2, OS id=4760
PSP0 started with pid=3, OS id=5356
MMAN started with pid=4, OS id=9276
DBW0 started with pid=5, OS id=7736
LGWR started with pid=6, OS id=10876
CKPT started with pid=7, OS id=9064
SMON started with pid=8, OS id=7800
RECO started with pid=9, OS id=11048
CJQ0 started with pid=10, OS id=7184
MMON started with pid=11, OS id=6108
MMNL started with pid=12, OS id=8044
Tue Apr 01 10:47:58 2025
ALTER DATABASE MOUNT
Tue Apr 01 10:48:02 2025
Setting recovery target incarnation to 2
Tue Apr 01 10:48:02 2025
Successful mount of redo thread 1, with mount id 1630252830
Tue Apr 01 10:48:02 2025
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Tue Apr 01 10:48:03 2025
ALTER DATABASE OPEN
Tue Apr 01 10:48:03 2025
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Tue Apr 01 10:48:03 2025
Started redo scan
Tue Apr 01 10:48:03 2025
Completed redo scan
24 redo blocks read, 2 data blocks need recovery
Tue Apr 01 10:48:03 2025
Started redo application at
Thread 1: logseq 6504, block 237
Tue Apr 01 10:48:03 2025
Recovery of Online Redo Log: Thread 1 Group 5 Seq 6504 Reading mem 0
Mem# 0: D:\ORACLE\ORADATA\STARCO\REDO05.LOG
Tue Apr 01 10:48:03 2025
Completed redo application
Tue Apr 01 10:48:03 2025
Completed crash recovery at
Thread 1: logseq 6504, block 261, scn 25976649624
2 data blocks read, 2 data blocks written, 24 redo blocks read
Tue Apr 01 10:48:03 2025
Thread 1 advanced to log sequence 6505 (thread open)
Thread 1 opened at log sequence 6505
Current log# 7 seq# 6505 mem# 0: D:\ORACLE\ORADATA\STARCO\REDO07.LOG
Successful open of redo thread 1
Tue Apr 01 10:48:03 2025
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Apr 01 10:48:03 2025
SMON: enabling cache recovery
Tue Apr 01 10:48:03 2025
Successfully onlined Undo Tablespace 8.
Tue Apr 01 10:48:03 2025
SMON: enabling tx recovery
Tue Apr 01 10:48:03 2025
Database Characterset is CL8MSWIN1251
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 4
Tue Apr 01 10:48:03 2025
Errors in file d:\oracle\admin\starco\udump\starco_ora_6180.trc:
ORA-00600: код внутр. ошибки, аргументы: [4194], [66], [52], [], [], [], [], []
Doing block recovery for file 63 block 29911
Block recovery from logseq 6505, block 63 to scn 25976649832
Tue Apr 01 10:48:04 2025
Recovery of Online Redo Log: Thread 1 Group 7 Seq 6505 Reading mem 0
Mem# 0: D:\ORACLE\ORADATA\STARCO\REDO07.LOG
Block recovery stopped at EOT rba 6505.81.16
Block recovery completed at rba 6505.81.16, scn 6.206846055
Doing block recovery for file 63 block 153
Block recovery from logseq 6505, block 63 to scn 25976649809
Tue Apr 01 10:48:04 2025
Recovery of Online Redo Log: Thread 1 Group 7 Seq 6505 Reading mem 0
Mem# 0: D:\ORACLE\ORADATA\STARCO\REDO07.LOG
Block recovery completed at rba 6505.65.16, scn 6.206846035
replication_dependency_tracking turned off (no async multimaster replication found)
Tue Apr 01 10:48:04 2025
Errors in file d:\oracle\admin\starco\bdump\starco_smon_7800.trc:
ORA-00600: internal error code, arguments: [4194], [66], [52], [], [], [], [], []
Starting background process QMNC
QMNC started with pid=17, OS id=6812
Tue Apr 01 10:48:04 2025
Completed: ALTER DATABASE OPEN
Tue Apr 01 10:48:04 2025
Doing block recovery for file 63 block 29911
Block recovery from logseq 6505, block 63 to scn 25976649832
Tue Apr 01 10:48:04 2025
Recovery of Online Redo Log: Thread 1 Group 7 Seq 6505 Reading mem 0
Mem# 0: D:\ORACLE\ORADATA\STARCO\REDO07.LOG
Block recovery completed at rba 6505.81.16, scn 6.206846057
Doing block recovery for file 63 block 153
Block recovery from logseq 6505, block 63 to scn 25976649833
Tue Apr 01 10:48:04 2025
Recovery of Online Redo Log: Thread 1 Group 7 Seq 6505 Reading mem 0
Mem# 0: D:\ORACLE\ORADATA\STARCO\REDO07.LOG
Block recovery completed at rba 6505.81.16, scn 6.206846059
Tue Apr 01 10:48:04 2025
Errors in file d:\oracle\admin\starco\bdump\starco_smon_7800.trc:
ORA-01595: error freeing extent (9) of rollback segment (43))
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [66], [52], [], [], [], [], []
Tue Apr 01 10:48:04 2025
db_recovery_file_dest_size of 2048 MB is 0.00% 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.
Tue Apr 01 10:48:04 2025
Errors in file d:\oracle\admin\starco\bdump\starco_mmon_6108.trc:
ORA-00600: internal error code, arguments: [4194], [66], [52], [], [], [], [], []
Doing block recovery for file 63 block 29911
Block recovery from logseq 6505, block 63 to scn 25976649832
Tue Apr 01 10:48:05 2025
Recovery of Online Redo Log: Thread 1 Group 7 Seq 6505 Reading mem 0
Mem# 0: D:\ORACLE\ORADATA\STARCO\REDO07.LOG
Block recovery completed at rba 6505.81.16, scn 6.206846057
Doing block recovery for file 63 block 153
Block recovery from logseq 6505, block 63 to scn 25976649873
Tue Apr 01 10:48:05 2025
Recovery of Online Redo Log: Thread 1 Group 7 Seq 6505 Reading mem 0
Mem# 0: D:\ORACLE\ORADATA\STARCO\REDO07.LOG
Block recovery completed at rba 6505.104.16, scn 6.206846098
Tue Apr 01 10:48:05 2025
Errors in file d:\oracle\admin\starco\bdump\starco_j008_10588.trc:
ORA-00600: код внутр. ошибки, аргументы: [4194], [66], [52], [], [], [], [], []
Tue Apr 01 10:48:05 2025
DEBUG: Replaying xcb 0x585377e0, pmd 0x5747d9f8 for failed op 8
Doing block recovery for file 63 block 29911
Block recovery from logseq 6505, block 63 to scn 25976649832
Tue Apr 01 10:48:05 2025
Recovery of Online Redo Log: Thread 1 Group 7 Seq 6505 Reading mem 0
Mem# 0: D:\ORACLE\ORADATA\STARCO\REDO07.LOG
Block recovery completed at rba 6505.81.16, scn 6.206846057
Tue Apr 01 10:48:06 2025
Errors in file d:\oracle\admin\starco\bdump\starco_j008_10588.trc:
ORA-00600: код внутр. ошибки, аргументы: [4194], [66], [52], [], [], [], [], []
ORA-00600: код внутр. ошибки, аргументы: [4194], [66], [52], [], [], [], [], []
Tue Apr 01 10:48:06 2025
Errors in file d:\oracle\admin\starco\bdump\starco_j008_10588.trc:
ORA-00600: код внутр. ошибки, аргументы: [4194], [66], [52], [], [], [], [], []
ORA-00600: код внутр. ошибки, аргументы: [4194], [66], [52], [], [], [], [], []
Tue Apr 01 10:48:06 2025
Errors in file d:\oracle\admin\starco\bdump\starco_j008_10588.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [4194], [66], [52], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [66], [52], [], [], [], [], []
Tue Apr 01 10:48:09 2025
DEBUG: Replaying xcb 0x585377e0, pmd 0x5747d9f8 for failed op 8
Doing block recovery for file 63 block 29911
Block recovery from logseq 6505, block 63 to scn 25976649832
Tue Apr 01 10:48:09 2025
Recovery of Online Redo Log: Thread 1 Group 7 Seq 6505 Reading mem 0
Mem# 0: D:\ORACLE\ORADATA\STARCO\REDO07.LOG
Block recovery completed at rba 6505.81.16, scn 6.206846057
Tue Apr 01 10:48:09 2025
Errors in file d:\oracle\admin\starco\bdump\starco_pmon_4760.trc:
ORA-00600: internal error code, arguments: [4194], [66], [52], [], [], [], [], []
Tue Apr 01 10:48:10 2025
Errors in file d:\oracle\admin\starco\bdump\starco_pmon_4760.trc:
ORA-00600: internal error code, arguments: [4194], [66], [52], [], [], [], [], []
PMON: terminating instance due to error 472
Tue Apr 01 10:48:12 2025
Errors in file d:\oracle\admin\starco\bdump\starco_psp0_5356.trc:
ORA-00472: PMON process terminated with error
Tue Apr 01 10:48:12 2025
Errors in file d:\oracle\admin\starco\bdump\starco_lgwr_10876.trc:
ORA-00472: PMON process terminated with error
Tue Apr 01 10:48:12 2025
Errors in file d:\oracle\admin\starco\bdump\starco_dbw0_7736.trc:
ORA-00472: PMON process terminated with error
Tue Apr 01 10:48:12 2025
Errors in file d:\oracle\admin\starco\bdump\starco_ckpt_9064.trc:
ORA-00472: PMON process terminated with error
Tue Apr 01 10:48:13 2025
Errors in file d:\oracle\admin\starco\bdump\starco_mman_9276.trc:
ORA-00472: PMON process terminated with error
Tue Apr 01 10:48:16 2025
Errors in file d:\oracle\admin\starco\bdump\starco_reco_11048.trc:
ORA-00472: PMON process terminated with error
Tue Apr 01 10:48:16 2025
Errors in file d:\oracle\admin\starco\bdump\starco_smon_7800.trc:
ORA-00472: PMON process terminated with error
Instance terminated by PMON, pid = 4760
Tue Apr 01 10:49:19 2025
WARNING: inbound connection timed out (ORA-3136)