Oracle Error 1033 and error ORA-00600 resolution _oracle

This error often occurs in an Oracle database after an illegal shutdown:

Exp-00056:oracle Error 1033 appears
ora-01033:oracle initialization or shutdown in progress
User:
Password:

This is obviously the database does not have the means to start, but the database service can be started, and the program cannot connect to the database.

The first choice to find the problem to see the database bdump directory alert file specific report what the error

The last few lines you'll see are:

Errors ORA-00600: Internal error code, parameters: [Kcratr1_lostwrt], [], [], [], [], [], [], []

This error does not need to study what is meant, the following is the solution to this problem:

oracle9/10g startup times wrong ORA-00600: Internal error code, parameters: [Kcratr1_lostwrt], [], [], [], [], [], [], []

This may be due to illegal shutdown or power off, following are the problems and solutions:

C:\Documents and Settings\administrator>sqlplus
sql*plus:release 9.2.0.1.0-production on Sunday May 13 09:23:23 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Please enter user name:/as sysdba

Connect to:

Oracle9i Enterprise Edition release 9.2.0.1.0-production
with the partitioning, OLAP and Oracle Data Mining options< C2/>jserver Release 9.2.0.1.0-production

Sql> Startup

ORA-01081: Unable to start an ORACLE---that is already running please close first

sql> Shutdown Abort

The ORACLE routine has been closed.

Sql> Startup

The ORACLE routine has started.

Total System Global area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buf Fers 25165824 bytes
Redo buffers 667648

Database loading complete.
ORA-00600: Internal error code, parameters: [Kcratr1_lostwrt], [], [], [], [], [], [], []

sql> shutdown Immediate

ORA-01109: Database not open

The database has been unloaded.

The ORACLE routine has been closed.

Sql> Startup Mount

The ORACLE routine has started.

Total System Global area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffer S 25165824 bytes
Redo buffers 667648 bytes

Database loading complete.

sql> Recover database;

Complete media recovery.

sql> ALTER DATABASE open;

The database has changed.

sql>exit;

By the way, the role of Oracle's several adump, Bdump, Cdump, Dpdump, Pfile, and Udump directories:

Audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ Admin\orcl\bdump
user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = C:\ORACLE\ Product\10.2.0\admin\orcl\cdump

From the above you can know:

Adump: Audit Information
Bdump: Background process trace and alert log, which means that Alert_sid.log also exists in this directory
Cdump:core trace, typically used to log applications, will have little information unless there is a problem with the database.
Dpdump: is to store some login information
Pfile: initialization parameter file Initsid
Udump: Foreground manual trace, such as the trace file for session after SQL Trace
There are alert files in the Bdump, and some background process trace file
Trace file for session after SQL Trace is normally placed in Udump
Cdump typically place some core trace files

Wangfl

Adump is generally audit dump
Bdump is background dump.
Udump is User dump
Cdump is core dump

Show parameter background_dump_dest;