Help - Search - Members - Calendar
Full Version: oracle 10g R 1.2.0 backgroud process terminated automatically
Oracle DBA Forums > Oracle > Oracle Forum
farnaw4u
Hi all


I recieved New Dell PowerVault 2900 server with SAS having Window 2003 E server on it .

when i install oracle 10g R 10.2.0 it successfully installed but soon error apears, oracle instance/background process automatically become fail. i dont knw y .


please help me


here is alter log file


Thu Jul 24 15:37:25 2008
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 =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 = 184549376
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEDB51A.ORA
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\DB51A\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\DB51A\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\DB51A\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 411041792
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:\oracle\product\10.2.0/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=db51aXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\DB51A\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\DB51A\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\DB51A\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\DB51A\CDUMP
db_name = db51a
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=2696
PSP0 started with pid=3, OS id=3748
MMAN started with pid=4, OS id=3756
DBW0 started with pid=5, OS id=2396
LGWR started with pid=6, OS id=3036
CKPT started with pid=7, OS id=4012
SMON started with pid=8, OS id=408
RECO started with pid=9, OS id=3736
CJQ0 started with pid=10, OS id=1744
MMON started with pid=11, OS id=3536
MMNL started with pid=12, OS id=4000
Thu Jul 24 15:37:25 2008
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Thu Jul 24 15:37:25 2008
ALTER DATABASE MOUNT
Thu Jul 24 15:37:29 2008
Setting recovery target incarnation to 2
Thu Jul 24 15:37:29 2008
Successful mount of redo thread 1, with mount id 3529317749
Thu Jul 24 15:37:29 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Thu Jul 24 15:37:29 2008
ALTER DATABASE OPEN
Thu Jul 24 15:37:29 2008
Beginning crash recovery of 1 threads
parallel recovery started with 7 processes
Thu Jul 24 15:37:29 2008
Started redo scan
Thu Jul 24 15:37:29 2008
Completed redo scan
309 redo blocks read, 121 data blocks need recovery
Thu Jul 24 15:37:29 2008
Started redo application at
Thread 1: logseq 88, block 3
Thu Jul 24 15:37:29 2008
Recovery of Online Redo Log: Thread 1 Group 3 Seq 88 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\DB51A\REDO03.LOG
Thu Jul 24 15:37:29 2008
Completed redo application
Thu Jul 24 15:37:29 2008
Completed crash recovery at
Thread 1: logseq 88, block 312, scn 1698533
121 data blocks read, 121 data blocks written, 309 redo blocks read
Thu Jul 24 15:37:29 2008
Thread 1 advanced to log sequence 89
Thread 1 opened at log sequence 89
Current log# 1 seq# 89 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\DB51A\REDO01.LOG
Successful open of redo thread 1
Thu Jul 24 15:37:29 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Jul 24 15:37:29 2008
SMON: enabling cache recovery
Thu Jul 24 15:37:30 2008
Successfully onlined Undo Tablespace 1.
Thu Jul 24 15:37:30 2008
SMON: enabling tx recovery
Thu Jul 24 15:37:30 2008
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=23, OS id=3656
Thu Jul 24 15:37:31 2008
Errors in file d:\oracle\product\10.2.0\admin\db51a\bdump\db51a_smon_408.trc:
ORA-00600: internal error code, arguments: [4194], [60], [37], [], [], [], [], []

Thu Jul 24 15:37:32 2008
Doing block recovery for file 2 block 81353
Block recovery from logseq 89, block 76 to scn 1698759
Thu Jul 24 15:37:32 2008
Recovery of Online Redo Log: Thread 1 Group 1 Seq 89 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\DB51A\REDO01.LOG
Block recovery stopped at EOT rba 89.81.16
Block recovery completed at rba 89.81.16, scn 0.1698756
Doing block recovery for file 2 block 73
Block recovery from logseq 89, block 76 to scn 1698749
Thu Jul 24 15:37:32 2008
Recovery of Online Redo Log: Thread 1 Group 1 Seq 89 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\DB51A\REDO01.LOG
Block recovery completed at rba 89.77.16, scn 0.1698752
Thu Jul 24 15:37:32 2008
Errors in file d:\oracle\product\10.2.0\admin\db51a\bdump\db51a_smon_408.trc:
ORA-01595: error freeing extent (3) of rollback segment (5))
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [60], [37], [], [], [], [], []

Thu Jul 24 15:37:32 2008
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.
Thu Jul 24 15:37:32 2008
Completed: ALTER DATABASE OPEN
Thu Jul 24 15:38:14 2008
Errors in file d:\oracle\product\10.2.0\admin\db51a\bdump\db51a_mmon_3536.trc:
ORA-00600: internal error code, arguments: [4194], [60], [37], [], [], [], [], []

Thu Jul 24 15:38:14 2008
Flush retried for xcb 0x5cfab124, pmd 0x5c4b70f0
Doing block recovery for file 2 block 81353
Block recovery from logseq 89, block 76 to scn 1698759
Thu Jul 24 15:38:14 2008
Recovery of Online Redo Log: Thread 1 Group 1 Seq 89 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\DB51A\REDO01.LOG
Block recovery completed at rba 89.81.16, scn 0.1698762
Thu Jul 24 15:38:14 2008
Errors in file d:\oracle\product\10.2.0\admin\db51a\bdump\db51a_mmon_3536.trc:
ORA-00600: internal error code, arguments: [4194], [60], [37], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [60], [37], [], [], [], [], []

Flush retried for xcb 0x5cfab124, pmd 0x5c4b70f0
Doing block recovery for file 2 block 81353
Block recovery from logseq 89, block 76 to scn 1698759
Thu Jul 24 15:38:15 2008
Recovery of Online Redo Log: Thread 1 Group 1 Seq 89 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\DB51A\REDO01.LOG
Block recovery completed at rba 89.81.16, scn 0.1698762
Thu Jul 24 15:38:15 2008
Errors in file d:\oracle\product\10.2.0\admin\db51a\bdump\db51a_mmon_3536.trc:
ORA-00600: internal error code, arguments: [4194], [60], [37], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [60], [37], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [60], [37], [], [], [], [], []

Flush retried for xcb 0x5cfab124, pmd 0x5c4b70f0
Doing block recovery for file 2 block 81353
Block recovery from logseq 89, block 76 to scn 1698759
Thu Jul 24 15:38:15 2008
Recovery of Online Redo Log: Thread 1 Group 1 Seq 89 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\DB51A\REDO01.LOG
Block recovery completed at rba 89.81.16, scn 0.1698762
Thu Jul 24 15:38:15 2008
Errors in file d:\oracle\product\10.2.0\admin\db51a\bdump\db51a_mmon_3536.trc:
ORA-00600: internal error code, arguments: [4194], [60], [37], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [60], [37], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [60], [37], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [60], [37], [], [], [], [], []

Flush retried for xcb 0x5cfab124, pmd 0x5c4b70f0
Doing block recovery for file 2 block 81353
Block recovery from logseq 89, block 76 to scn 1698759
Thu Jul 24 15:38:16 2008
Recovery of Online Redo Log: Thread 1 Group 1 Seq 89 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\DB51A\REDO01.LOG
Block recovery completed at rba 89.81.16, scn 0.1698762
Thu Jul 24 15:38:16 2008
Errors in file d:\oracle\product\10.2.0\admin\db51a\bdump\db51a_mmon_3536.trc:
ORA-00600: internal error code, arguments: [4194], [60], [37], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [60], [37], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [60], [37], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [60], [37], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [60], [37], [], [], [], [], []

Thu Jul 24 15:39:34 2008
Flush retried for xcb 0x5cfab124, pmd 0x5c4b70f0
Doing block recovery for file 2 block 81353
Block recovery from logseq 89, block 76 to scn 1698759
Thu Jul 24 15:39:34 2008
Recovery of Online Redo Log: Thread 1 Group 1 Seq 89 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\DB51A\REDO01.LOG
Block recovery completed at rba 89.81.16, scn 0.1698762
Thu Jul 24 15:39:34 2008
Errors in file d:\oracle\product\10.2.0\admin\db51a\bdump\db51a_mmon_3536.trc:
ORA-00600: internal error code, arguments: [4194], [60], [37], [], [], [], [], []

ORA-600 encountered when generating server alert SMG-3503
Thu Jul 24 15:40:35 2008
Flush retried for xcb 0x5cfab124, pmd 0x5c4b70f0
Doing block recovery for file 2 block 81353
Block recovery from logseq 89, block 76 to scn 1698759
Thu Jul 24 15:40:35 2008
Recovery of Online Redo Log: Thread 1 Group 1 Seq 89 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\DB51A\REDO01.LOG
Block recovery completed at rba 89.81.16, scn 0.1698762
Thu Jul 24 15:40:35 2008
Errors in file d:\oracle\product\10.2.0\admin\db51a\bdump\db51a_mmon_3536.trc:
ORA-00600: internal error code, arguments: [4194], [60], [37], [], [], [], [], []

Flush retried for xcb 0x5cfab124, pmd 0x5c4b70f0
Doing block recovery for file 2 block 81353
Block recovery from logseq 89, block 76 to scn 1698759
Thu Jul 24 15:40:35 2008
Recovery of Online Redo Log: Thread 1 Group 1 Seq 89 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\DB51A\REDO01.LOG
Block recovery completed at rba 89.81.16, scn 0.1698762
Thu Jul 24 15:40:35 2008
Errors in file d:\oracle\product\10.2.0\admin\db51a\bdump\db51a_mmon_3536.trc:
ORA-00600: internal error code, arguments: [4194], [60], [37], [], [], [], [], []

Thu Jul 24 15:41:36 2008
Flush retried for xcb 0x5cfab124, pmd 0x5c4b70f0
Doing block recovery for file 2 block 81353
Block recovery from logseq 89, block 76 to scn 1698759
Thu Jul 24 15:41:36 2008
Recovery of Online Redo Log: Thread 1 Group 1 Seq 89 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\DB51A\REDO01.LOG
Block recovery completed at rba 89.81.16, scn 0.1698762
Thu Jul 24 15:41:36 2008
Errors in file d:\oracle\product\10.2.0\admin\db51a\bdump\db51a_mmon_3536.trc:
ORA-00600: internal error code, arguments: [4194], [60], [37], [], [], [], [], []

Thu Jul 24 15:42:23 2008
Flush retried for xcb 0x5cfab124, pmd 0x5c4b70f0
Doing block recovery for file 2 block 81353
Block recovery from logseq 89, block 76 to scn 1698759
Thu Jul 24 15:42:23 2008
Recovery of Online Redo Log: Thread 1 Group 1 Seq 89 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\DB51A\REDO01.LOG
Block recovery completed at rba 89.81.16, scn 0.1698762
Thu Jul 24 15:42:23 2008
Errors in file d:\oracle\product\10.2.0\admin\db51a\bdump\db51a_pmon_2696.trc:
ORA-00600: internal error code, arguments: [4194], [60], [37], [], [], [], [], []

Thu Jul 24 15:42:23 2008
Errors in file d:\oracle\product\10.2.0\admin\db51a\bdump\db51a_pmon_2696.trc:
ORA-00600: internal error code, arguments: [4194], [60], [37], [], [], [], [], []

PMON: terminating instance due to error 472
Thu Jul 24 15:42:25 2008
Errors in file d:\oracle\product\10.2.0\admin\db51a\bdump\db51a_q001_1364.trc:
ORA-00472: PMON process terminated with error

Thu Jul 24 15:42:25 2008
Errors in file d:\oracle\product\10.2.0\admin\db51a\bdump\db51a_j000_404.trc:
ORA-00472: PMON process terminated with error

Thu Jul 24 15:42:25 2008
Errors in file d:\oracle\product\10.2.0\admin\db51a\bdump\db51a_psp0_3748.trc:
ORA-00472: PMON process terminated with error

Thu Jul 24 15:42:25 2008
Errors in file d:\oracle\product\10.2.0\admin\db51a\bdump\db51a_mman_3756.trc:
ORA-00472: PMON process terminated with error

Thu Jul 24 15:42:25 2008
Errors in file d:\oracle\product\10.2.0\admin\db51a\bdump\db51a_dbw0_2396.trc:
ORA-00472: PMON process terminated with error

Thu Jul 24 15:42:25 2008
Errors in file d:\oracle\product\10.2.0\admin\db51a\bdump\db51a_ckpt_4012.trc:
ORA-00472: PMON process terminated with error

Thu Jul 24 15:42:25 2008
Errors in file d:\oracle\product\10.2.0\admin\db51a\bdump\db51a_lgwr_3036.trc:
ORA-00472: PMON process terminated with error

Thu Jul 24 15:42:31 2008
Errors in file d:\oracle\product\10.2.0\admin\db51a\bdump\db51a_reco_3736.trc:
ORA-00472: PMON process terminated with error

Thu Jul 24 15:42:31 2008
Errors in file d:\oracle\product\10.2.0\admin\db51a\bdump\db51a_smon_408.trc:
ORA-00472: PMON process terminated with error

Instance terminated by PMON, pid = 2696


mANY THNKS


REGARDS
dave
what did metalink say when you looked all these errors up?
aussie_dba
ORA-600 errors must be reported to Oracle technical support.

Only Oracle can help you.

http://metalink.oracle.com
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.