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 Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Thu Sep 12 11:32:18 CDT 2024
|