Home » RDBMS Server » Server Administration » help!ORA-00600: internal error code, arguments: [kcratr1_lostwrt],
help!ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [message #206738] Fri, 01 December 2006 05:31 Go to next message
mephisto_nj
Messages: 2
Registered: December 2006
Junior Member
hi,Can anybody help me?
when I startup my database,I receive the message:
~
"/opt/ora9/product/9.2/network/admin/listener.ora" [已转换] 21L, 475C 已写入
-bash-2.05b#
-bash-2.05b# chown -R oracle.dba /oracle1
-bash-2.05b# chown -R oracle.dba /oracle2
-bash-2.05b# chown -R oracle.dba /oracle3
-bash-2.05b# su - oracle -c "lsnrctl start LISTENER"

LSNRCTL for Linux IA64: Version 9.2.0.2.0 - Production on 01-DEC-2006 15:18:03

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

Starting /opt/ora9/product/9.2/bin/tnslsnr: please wait...

TNSLSNR for Linux IA64: Version 9.2.0.2.0 - Production
System parameter file is /opt/ora9/product/9.2/network/admin/listener.ora
Log messages written to /opt/ora9/product/9.2/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.1.19)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.1.19)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux IA64: Version 9.2.0.2.0 - Production
Start Date 01-DEC-2006 15:18:04
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /opt/ora9/product/9.2/network/admin/listener.ora
Listener Log File /opt/ora9/product/9.2/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.1.19)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "ora9i" has 1 instance(s).
Instance "ora9i", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
-bash-2.05b# su - oracle -c "export ORACLE_SID=ora9i;sqlplus /nolog @/oracle2/oradata/ora9i/startup.sql"

SQL*Plus: Release 9.2.0.2.0 - Production on Fri Dec 1 15:18:13 2006

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

Connected to an idle instance.
ORACLE instance started.

Total System Global Area 2300070808 bytes
Fixed Size 756632 bytes
Variable Size 838860800 bytes
Database Buffers 1459617792 bytes
Redo Buffers 835584 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [], [], [], [],
[], [], []


Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.2.0 - Production
-bash-2.05b#
-bash-2.05b# sqlplus /nolog
-bash: sqlplus: command not found
-bash-2.05b# su - oracle
[oracle@huiwen1 oracle]$ sqlplus /nolog

SQL*Plus: Release 9.2.0.2.0 - Production on Fri Dec 1 15:20:21 2006

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

SQL> conn / sy sysdba
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_string>] | /
SQL> conn / as sysdba
Connected.
SQL>
SQL> alert database open
SP2-0734: unknown command beginning "alert data..." - rest of line ignored.
SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [], [], [], [],
[], [], []


SQL> shutdown normal
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 2300070808 bytes
Fixed Size 756632 bytes
Variable Size 838860800 bytes
Database Buffers 1459617792 bytes
Redo Buffers 835584 bytes
Database mounted.
SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [], [], [], [],
[], [], []


SQL> shutdown normal
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 2300070808 bytes
Fixed Size 756632 bytes
Variable Size 838860800 bytes
Database Buffers 1459617792 bytes
Redo Buffers 835584 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [], [], [], [],
[], [], []


SQL>
SQL>
SQL>
SQL> conn sys/change_on_install as sysdba
Connected.
SQL>
SQL> shutdown normal
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 2300070808 bytes
Fixed Size 756632 bytes
Variable Size 838860800 bytes
Database Buffers 1459617792 bytes
Redo Buffers 835584 bytes
Database mounted.
SQL> recover database
ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [3020], [8388619], [1], [127],
[848], [16], [], []
ORA-10567: Redo is inconsistent with data block (file# 2, block# 11)
ORA-10564: tablespace UNDOTBS1
ORA-01110: data file 2: '/oracle2/oradata/ora9i/undotbs01.dbf'
ORA-10560: block type 'KTU SMU HEADER BLOCK'


SQL> alter database recover datafile 2;

SQL> shutdown
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 2300070808 bytes
Fixed Size 756632 bytes
Variable Size 838860800 bytes
Database Buffers 1459617792 bytes
Redo Buffers 835584 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [], [], [], [],
[], [], []


SQL> recover database
ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [3020], [8388619], [1], [127],
[848], [16], [], []
ORA-10567: Redo is inconsistent with data block (file# 2, block# 11)
ORA-10564: tablespace UNDOTBS1
ORA-01110: data file 2: '/oracle2/oradata/ora9i/undotbs01.dbf'
ORA-10560: block type 'KTU SMU HEADER BLOCK'


SQL> alter database recover datafile 2
2 ;
alter database recover datafile 2
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [3020], [8388619], [1], [127],
[848], [16], [], []
ORA-10567: Redo is inconsistent with data block (file# 2, block# 11)
ORA-10564: tablespace UNDOTBS1
ORA-01110: data file 2: '/oracle2/oradata/ora9i/undotbs01.dbf'
ORA-10560: block type 'KTU SMU HEADER BLOCK'

How can I do?
Thx
Re: help!ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [message #206742 is a reply to message #206738] Fri, 01 December 2006 05:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Metalink note 30866.1.
Talk to oracle support for all ora-0600 errors.
Seems you need to do a TSPITR.
Re: help!ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [message #206794 is a reply to message #206742] Fri, 01 December 2006 08:59 Go to previous messageGo to next message
mephisto_nj
Messages: 2
Registered: December 2006
Junior Member
Thank you very much.but I have not a metalink account,Can you tell more about it ?
Re: help!ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [message #206797 is a reply to message #206794] Fri, 01 December 2006 09:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It is for the Oracle support services.
Talk to your IT folks/DBA
Re: help!ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [message #359198 is a reply to message #206738] Fri, 14 November 2008 01:43 Go to previous messageGo to next message
rizimazhar
Messages: 34
Registered: August 2008
Location: Pakistan
Member

Error
ORA-00600: internal error code, arguments: [kcratr1_lostwrt]....bla bla

You can try for the following command if alert_log shows only the above error in alert log file;

> connect sys as sysdba
>
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;
SQL> RECOVER DATABAES;
SQL> ALTER DATABSE OPEN;

-- database opened.

SQL>
Re: help!ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [message #359215 is a reply to message #359198] Fri, 14 November 2008 03:05 Go to previous message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the relation bewteen the problem and you solution?
Or is it a generic answer you give for all ORA-600 error?

Regards
Michel
Previous Topic: CDC issue
Next Topic: low open file descriptor message
Goto Forum:
  


Current Time: Fri Dec 09 11:43:52 CST 2016

Total time taken to generate the page: 0.10484 seconds