Oracle Error 1033 occurrence and ORA-00600 error resolution

This error often occurs with Oracle data after an illegal shutdown:

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

This is clearly not a way to start the database, but the database service can still be started, but the program cannot connect to the database.

Preferred to find a problem to see the database bdump directory alert file specific report what error

You see the last lines there

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

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

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

The cause may be illegal shutdown or power-down, the 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
Jserver Release 9.2.0.1.0-production

Sql> Startup
ORA-01081: Unable to start an ORACLE---that is already running please shut down first
sql> Shutdown Abort
The ORACLE routine has been closed.
Sql> Startup
The ORACLE routine has been started.

Total System Global area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database buffers 25165824 bytes
Redo buffers 667648 bytes
The database is loaded.
ORA-00600: Internal error code, parameters: [Kcratr1_lostwrt], [], [], [], [], [], [], []

sql> shutdown Immediate
ORA-01109: Database is not open

The database has been uninstalled.
The ORACLE routine has been closed.
Sql> Startup Mount
The ORACLE routine has been started.

Total System Global area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database buffers 25165824 bytes
Redo buffers 667648 bytes
The database is loaded.
sql> Recover database;
Complete media recovery.
sql> ALTER DATABASE open;

The database has changed.

sql>exit;

--------------------------------------------------------------------------------------------------------------- -----

By the way, the role of Oracle several adump, Bdump, Cdump, Dpdump, Pfile, 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, which is typically used for log applications unless there is a problem with the database, there is basically no information.

Dpdump: is to store some login information

Pfile: Initialize parameter file Initsid

Udump: The trace file of the foreground manual trace such as SQL Trace after session

There are alert files in Bdump, and trace file for some background processes

Trace file for session after SQL Trace is generally placed in udump

Cdump generally places 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;