db사용중 갑자기 tns오류뜨면서 로그인이 안되는 문제발생. 급한마음에 서버를 껐다 켰습니다.
다시 올라온후 15~20분사이에 한번씩 ora-12154가 뜨면서 db연결이 안됩니다. 밑은 로그입니다..
뭐가 문제일까요. 분석 좀 해주세요 ㅠㅠ
Instance terminated by PMON, pid = 5120
Tue Oct 11 20:30:34 2011
Adjusting the default value of parameter parallel_max_servers
from 640 to 235 due to the value of parameter processes (250)
Tue Oct 11 20:30:34 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =30
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.3.0.
System parameters with non-default values:
processes = 250
sga_max_size = 1048576000
__shared_pool_size = 205520896
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLE\PRODUCT\10.2.0\DBS\SPFILEZEUS.ORA
sga_target = 1048576000
control_files = D:\ORACLE\PRODUCT\ORADATA\ZEUS\CONTROL01.CTL, D:\ORACLE\PRODUCT\ORADATA\ZEUS\CONTROL02.CTL, D:\ORACLE\PRODUCT\ORADATA\ZEUS\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 817889280
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
cluster_database = FALSE
db_recovery_file_dest = D:\oracle\product/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=ZEUSXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\ADMIN\ZEUS\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\ADMIN\ZEUS\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\ADMIN\ZEUS\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\ADMIN\ZEUS\CDUMP
db_name = ZEUS
open_cursors = 500
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=5140
PSP0 started with pid=4, OS id=6104
MMAN started with pid=6, OS id=4564
DBW0 started with pid=8, OS id=5496
DBW1 started with pid=10, OS id=5968
DBW2 started with pid=12, OS id=2324
DBW3 started with pid=14, OS id=908
LGWR started with pid=16, OS id=5532
CKPT started with pid=18, OS id=5708
SMON started with pid=20, OS id=3364
RECO started with pid=22, OS id=4384
CJQ0 started with pid=24, OS id=2832
MMON started with pid=26, OS id=4784
Tue Oct 11 20:30:35 2011
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=28, OS id=3208
Tue Oct 11 20:30:35 2011
starting up 1 shared server(s) ...
Tue Oct 11 20:30:35 2011
ALTER DATABASE MOUNT
Tue Oct 11 20:30:40 2011
Setting recovery target incarnation to 2
Tue Oct 11 20:30:40 2011
Successful mount of redo thread 1, with mount id 309190315
Tue Oct 11 20:30:40 2011
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Tue Oct 11 20:30:40 2011
ALTER DATABASE OPEN
Tue Oct 11 20:30:40 2011
Beginning crash recovery of 1 threads
parallel recovery started with 16 processes
Tue Oct 11 20:30:40 2011
Started redo scan
Tue Oct 11 20:30:40 2011
Completed redo scan
3625 redo blocks read, 751 data blocks need recovery
Tue Oct 11 20:30:41 2011
Started redo application at
Thread 1: logseq 78856, block 11117
Tue Oct 11 20:30:41 2011
Recovery of Online Redo Log: Thread 1 Group 3 Seq 78856 Reading mem 0
Mem# 0: D:\ORACLE\PRODUCT\ORADATA\ZEUS\REDO03.LOG
Mem# 1: D:\ORACLE\PRODUCT\ORADATA\ZEUS\REDO06.LOG
Tue Oct 11 20:30:41 2011
Completed redo application
Tue Oct 11 20:30:41 2011
Completed crash recovery at
Thread 1: logseq 78856, block 14742, scn 3553014024
751 data blocks read, 749 data blocks written, 3625 redo blocks read
Tue Oct 11 20:30:41 2011
Thread 1 advanced to log sequence 78857
Thread 1 opened at log sequence 78857
Current log# 1 seq# 78857 mem# 0: D:\ORACLE\PRODUCT\ORADATA\ZEUS\REDO01.LOG
Current log# 1 seq# 78857 mem# 1: D:\ORACLE\PRODUCT\ORADATA\ZEUS\REDO04.LOG
Successful open of redo thread 1
Tue Oct 11 20:30:41 2011
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Oct 11 20:30:41 2011
SMON: enabling cache recovery
Tue Oct 11 20:30:42 2011
Successfully onlined Undo Tablespace 1.
Tue Oct 11 20:30:42 2011
SMON: enabling tx recovery
Tue Oct 11 20:30:42 2011
Database Characterset is KO16MSWIN949
Tue Oct 11 20:30:43 2011
Errors in file d:\oracle\product\admin\zeus\bdump\zeus_p050_2412.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kturblguba+231] [PC:0x95D0D3] [ADDR:0x14] [UNABLE_TO_READ] []
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=164, OS id=5896
Tue Oct 11 20:30:47 2011
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 Oct 11 20:30:47 2011
Completed: ALTER DATABASE OPEN
Tue Oct 11 20:31:27 2011
SMON: slave died unexpectedly, downgrading to serial recovery
Tue Oct 11 20:31:30 2011
Errors in file d:\oracle\product\admin\zeus\bdump\zeus_smon_3364.trc:
ORA-00600: internal error code, arguments: [4137], [], [], [], [], [], [], []
ORACLE Instance zeus (pid = 20) - Error 600 encountered while recovering transaction (2, 44).
Tue Oct 11 20:31:30 2011
Errors in file d:\oracle\product\admin\zeus\bdump\zeus_smon_3364.trc:
ORA-00600: internal error code, arguments: [4137], [], [], [], [], [], [], []
|