oracle数据库00603,ora-00603如何处理？

约定不等于承诺〃 2022-10-21 01:09 11阅读 0赞

Instance terminated by SMON, pid = 2048

Mon Apr 12 12:09:32 2010

Starting ORACLE instance (normal)

LICENSE\_MAX\_SESSION = 0

LICENSE\_SESSIONS\_WARNING = 0

Picked latch-free SCN scheme 2

Autotune of undo retention is turned on.

IMODE=BR

ILAT =18

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                = 150

\_\_shared\_pool\_size       = 138412032

\_\_large\_pool\_size        = 4194304

\_\_java\_pool\_size         = 4194304

\_\_streams\_pool\_size      = 0

sga\_target               = 1015021568

control\_files            = C:\\ORACLE\\PRODUCT\\ROCKET\\CONTROL\_C.CTL, D:\\ORACLE\\ORADATA\\CONTROL\_D.CTL, E:\\ORACLE\\ORADATA\\CONTROL\_E.CTL

db\_block\_size            = 8192

\_\_db\_cache\_size          = 859832320

compatible               = 10.2.0.1.0

log\_archive\_dest\_1       = LOCATION=G:\\oracle\\oradata

log\_archive\_format       = ARC%S\_%R.%T

db\_file\_multiblock\_read\_count= 16

db\_recovery\_file\_dest    = F:\\oracle\\oradata

db\_recovery\_file\_dest\_size= 2147483648

undo\_management          = AUTO

undo\_tablespace          = UNDO

remote\_login\_passwordfile= EXCLUSIVE

db\_domain                =

dispatchers              = (protocol=TCP)

shared\_servers           = 10

job\_queue\_processes      = 10

audit\_file\_dest          = C:\\ORACLE\\PRODUCT\\ADMIN\\ROCKET\\ADUMP

background\_dump\_dest     = C:\\ORACLE\\PRODUCT\\ADMIN\\ROCKET\\BDUMP

user\_dump\_dest           = C:\\ORACLE\\PRODUCT\\ADMIN\\ROCKET\\UDUMP

core\_dump\_dest           = C:\\ORACLE\\PRODUCT\\ADMIN\\ROCKET\\CDUMP

db\_name                  = rocket

open\_cursors             = 300

pga\_aggregate\_target     = 337641472

PMON started with pid=2, OS id=2468

PSP0 started with pid=3, OS id=2732

MMAN started with pid=4, OS id=2736

DBW0 started with pid=5, OS id=2740

LGWR started with pid=6, OS id=2744

CKPT started with pid=7, OS id=2748

SMON started with pid=8, OS id=2752

RECO started with pid=9, OS id=2756

CJQ0 started with pid=10, OS id=2760

MMON started with pid=11, OS id=2764

Mon Apr 12 12:09:32 2010

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

MMNL started with pid=12, OS id=2768

Mon Apr 12 12:09:32 2010

starting up 10 shared server(s) ...

Mon Apr 12 12:09:33 2010

ALTER DATABASE   MOUNT

Mon Apr 12 12:09:37 2010

Setting recovery target incarnation to 1

Mon Apr 12 12:09:37 2010

Successful mount of redo thread 1, with mount id 2257082749

Mon Apr 12 12:09:37 2010

Database mounted in Exclusive Mode

Completed: ALTER DATABASE   MOUNT

Mon Apr 12 12:09:37 2010

ALTER DATABASE OPEN

Mon Apr 12 12:09:37 2010

Beginning crash recovery of 1 threads

parallel recovery started with 3 processes

Mon Apr 12 12:09:38 2010

Started redo scan

Mon Apr 12 12:09:38 2010

Completed redo scan

349 redo blocks read, 40 data blocks need recovery

Mon Apr 12 12:09:38 2010

Started redo application at

Thread 1: logseq 418, block 78

Mon Apr 12 12:09:38 2010

Recovery of Online Redo Log: Thread 1 Group 1 Seq 418 Reading mem 0

Mem\# 0 errs 0: C:\\ORACLE\\PRODUCT\\ROCKET\\REDO\_C.LOG

Mon Apr 12 12:09:38 2010

Completed redo application

Mon Apr 12 12:09:38 2010

Completed crash recovery at

Thread 1: logseq 418, block 427, scn 20793331

40 data blocks read, 40 data blocks written, 349 redo blocks read

Mon Apr 12 12:09:38 2010

LGWR: STARTING ARCH PROCESSES

ARC0 started with pid=28, OS id=2824

Mon Apr 12 12:09:38 2010

ARC0: Archival started

ARC1 started with pid=29, OS id=2832

Mon Apr 12 12:09:38 2010

ARC1: Archival started

LGWR: STARTING ARCH PROCESSES COMPLETE

Thread 1 advanced to log sequence 419

Thread 1 opened at log sequence 419

Current log\# 2 seq\# 419 mem\# 0: D:\\ORACLE\\ORADATA\\REDO\_D.LOG

Successful open of redo thread 1

Mon Apr 12 12:09:39 2010

MTTR advisory is disabled because FAST\_START\_MTTR\_TARGET is not set

Mon Apr 12 12:09:39 2010

ARC1: STARTING ARCH PROCESSES

Mon Apr 12 12:09:39 2010

ARC0: Becoming the 'no FAL' ARCH

ARC0: Becoming the 'no SRL' ARCH

Mon Apr 12 12:09:39 2010

SMON: enabling cache recovery

Mon Apr 12 12:09:39 2010

ARC2: Archival started

Mon Apr 12 12:09:39 2010

ARC1: STARTING ARCH PROCESSES COMPLETE

ARC1: Becoming the heartbeat ARCH

Mon Apr 12 12:09:39 2010

Successfully onlined Undo Tablespace 1.

Mon Apr 12 12:09:39 2010

SMON: enabling tx recovery

Mon Apr 12 12:09:39 2010

Database Characterset is ZHS16GBK

ARC2 started with pid=30, OS id=2836

Mon Apr 12 12:09:40 2010

Errors in file c:\\oracle\\product\\admin\\rocket\\udump\\rocket\_ora\_2828.trc:

ORA-00600: 内部错误代码, 参数: \[4194\], \[77\], \[82\], \[\], \[\], \[\], \[\], \[\]

DEBUG: Replaying xcb 0x4b38be8c, pmd 0x4a9388dc for failed op 8

Doing block recovery for file 2 block 55

No block recovery was needed

Mon Apr 12 12:13:14 2010

Errors in file c:\\oracle\\product\\admin\\rocket\\udump\\rocket\_ora\_2828.trc:

ORA-00600: 内部错误代码, 参数: \[4194\], \[77\], \[82\], \[\], \[\], \[\], \[\], \[\]

Mon Apr 12 12:13:18 2010

DEBUG: Replaying xcb 0x4b38be8c, pmd 0x4a9388dc for failed op 8

Mon Apr 12 12:13:18 2010

Errors in file c:\\oracle\\product\\admin\\rocket\\udump\\rocket\_ora\_2828.trc:

ORA-00600: 内部错误代码, 参数: \[4194\], \[77\], \[82\], \[\], \[\], \[\], \[\], \[\]

Doing block recovery for file 2 block 55

No block recovery was needed

Mon Apr 12 12:13:21 2010

Errors in file c:\\oracle\\product\\admin\\rocket\\udump\\rocket\_ora\_2828.trc:

ORA-00603: ORACLE server session terminated by fatal error

ORA-00600: internal error code, arguments: \[4194\], \[77\], \[82\], \[\], \[\], \[\], \[\], \[\]

Mon Apr 12 12:16:52 2010

Errors in file c:\\oracle\\product\\admin\\rocket\\bdump\\rocket\_smon\_2752.trc:

ORA-00600: internal error code, arguments: \[4194\], \[77\], \[82\], \[\], \[\], \[\], \[\], \[\]

Mon Apr 12 12:16:55 2010

DEBUG: Replaying xcb 0x4b38be8c, pmd 0x4a9388dc for failed op 8

Mon Apr 12 12:16:56 2010

Non-fatal internal error happenned while SMON was doing shrinking of rollback segments.

SMON encountered 1 out of maximum 100 non-fatal internal errors.

Mon Apr 12 12:16:56 2010

Doing block recovery for file 2 block 55

No block recovery was needed

Mon Apr 12 12:20:27 2010

Errors in file c:\\oracle\\product\\admin\\rocket\\bdump\\rocket\_pmon\_2468.trc:

ORA-00600: internal error code, arguments: \[4194\], \[77\], \[82\], \[\], \[\], \[\], \[\], \[\]

Mon Apr 12 12:20:30 2010

DEBUG: Replaying xcb 0x4b38be8c, pmd 0x4a9388dc for failed op 8

Doing block recovery for file 2 block 55

No block recovery was needed

Mon Apr 12 12:20:30 2010

Errors in file c:\\oracle\\product\\admin\\rocket\\bdump\\rocket\_pmon\_2468.trc:

ORA-00600: internal error code, arguments: \[4194\], \[77\], \[82\], \[\], \[\], \[\], \[\], \[\]

Mon Apr 12 12:20:30 2010

PMON: terminating instance due to error 472

Mon Apr 12 12:20:32 2010

Errors in file c:\\oracle\\product\\admin\\rocket\\bdump\\rocket\_mman\_2736.trc: