How Oracle Error 1033 occurs and ORA-00600 errors are resolved

Source: Internet
Author: User
Tags error code log connect

This error frequently occurs in Oracle data 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, but 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

You see the last few rows

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

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

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

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 buffers 25165824 bytes

Redo buffers 667648 bytes

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 buffers 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;

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.