Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

startup problem

NeevSep 7 2009 — edited Sep 7 2009
Hi all,
Please see the details below..
------------------
COmmand prompt
Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.

C:\Documents and Settings\Administrator>sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Mon Sep 7 09:21:39 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced


SQL>

ALERT----
Mon Sep 07 09:27:23 2009
Errors in file d:\oracle\admin\kkms\udump\kkms_ora_4832.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [2122], [1891], [], [], [], [], []

Error 607 happened during db open, shutting down database
USER: terminating instance due to error 607
Mon Sep 07 09:27:25 2009
Errors in file d:\oracle\admin\kkms\bdump\kkms_pmon_4760.trc:
ORA-00607: Internal error occurred while making a change to a data block

Instance terminated by USER, pid = 4832
ORA-1092 signalled during: ALTER DATABASE OPEN...


TRACE FILE-----

Dump file d:\oracle\admin\kkms\bdump\kkms_pmon_4760.trc
Mon Sep 07 09:27:25 2009
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: kkms

Redo thread mounted by this instance: 1

Oracle process number: 2

Windows thread id: 4760, image: ORACLE.EXE


*** 2009-09-07 09:27:25.000
*** SESSION ID:(1.1) 2009-09-07 09:27:25.000
error 607 detected in background process
ORA-00607: Internal error occurred while making a change to a data block

even after recovery my database by latest backup it is showing me this error..
Please guide
VERSION:9i
Windows 2003 server

Thanks,
Neerav
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 5 2009
Added on Sep 7 2009
8 comments
1,651 views