当前位置: 代码迷 >> Oracle管理 >> Oracle启动异常,报ORA-00600错,希望各位老大帮忙解决
  详细解决方案

Oracle启动异常,报ORA-00600错,希望各位老大帮忙解决

热度:47   发布时间:2016-04-24 05:15:58.0
Oracle启动错误,报ORA-00600错,希望各位老大帮忙解决
有会的老大帮忙解决一下,分可以加。日志内容为:

Dump file h:\oracle\product\10.2.0/admin/myoracle/bdump\alert_myoracle.log
Fri Jun 15 17:33:44 2012
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 2 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:2872M/3317M, Ph+PgF:4937M/5206M, VA:1937M/2047M
Fri Jun 15 17:33:44 2012
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 =97
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.1.0.
System parameters with non-default values:
  processes = 800
  sessions = 885
  __shared_pool_size = 109051904
  __large_pool_size = 4194304
  __java_pool_size = 4194304
  __streams_pool_size = 0
  sga_target = 448790528
  control_files = H:\ORACLE\PRODUCT\10.2.0\ORADATA\MYORACLE\CONTROL01.CTL, H:\ORACLE\PRODUCT\10.2.0\ORADATA\MYORACLE\CONTROL02.CTL, H:\ORACLE\PRODUCT\10.2.0\ORADATA\MYORACLE\CONTROL03.CTL
  db_block_size = 8192
  __db_cache_size = 322961408
  compatible = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest = H:\oracle\product\10.2.0/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management = AUTO
  undo_tablespace = UNDOTBS1
  _row_cr = FALSE
  remote_login_passwordfile= EXCLUSIVE
  db_domain = 
  dispatchers = (PROTOCOL=TCP) (SERVICE=myoracleXDB)
  job_queue_processes = 10
  cursor_sharing = SIMILAR
  audit_file_dest = H:\ORACLE\PRODUCT\10.2.0\ADMIN\MYORACLE\ADUMP
  background_dump_dest = H:\ORACLE\PRODUCT\10.2.0\ADMIN\MYORACLE\BDUMP
  user_dump_dest = H:\ORACLE\PRODUCT\10.2.0\ADMIN\MYORACLE\UDUMP
  core_dump_dest = H:\ORACLE\PRODUCT\10.2.0\ADMIN\MYORACLE\CDUMP
  db_name = myoracle
  open_cursors = 300
  pga_aggregate_target = 148897792
PMON started with pid=2, OS id=2284
PSP0 started with pid=3, OS id=2264
MMAN started with pid=4, OS id=2280
DBW0 started with pid=5, OS id=1076
LGWR started with pid=6, OS id=2292
CKPT started with pid=7, OS id=3536
SMON started with pid=8, OS id=2304
RECO started with pid=9, OS id=2320
CJQ0 started with pid=10, OS id=2316
MMON started with pid=11, OS id=1932
Fri Jun 15 17:33:44 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=2488
Fri Jun 15 17:33:44 2012
starting up 1 shared server(s) ...
Fri Jun 15 17:33:44 2012
alter database mount exclusive
Fri Jun 15 17:33:48 2012
Setting recovery target incarnation to 2
Fri Jun 15 17:33:48 2012
Successful mount of redo thread 1, with mount id 1884694584
Fri Jun 15 17:33:48 2012
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Fri Jun 15 17:33:48 2012
alter database open
Fri Jun 15 17:33:49 2012
Beginning crash recovery of 1 threads
 parallel recovery started with 2 processes
Fri Jun 15 17:33:49 2012
Started redo scan
Fri Jun 15 17:33:50 2012
Completed redo scan
 327 redo blocks read, 547 data blocks need recovery
  相关解决方案