10 Oracle errors that Oracledba most encountered

xiaoxiao2021-03-06  72

This Document Contains Information ABOUT ERRORS FREQUENTLY ENCOUNTERED BY

New DBAS, Along With Appropriate Actions to Be Taken in Each Circumstance.

==

Summary:

10 Common RDBMS ErrorS

=

1) ORA-1547

a) on rollback segment when importing.

Specify Commit = y and a large buffer on import. This Way the rollback

Will Be Released After Each Array, As Opposed to Each Object.

b) When Allocating An Extent ON A TableSpace with alot of free space.

SELECT MAX (Blocks) from DBA_Free_Space. You May Have Free Space But IT

Might Not Be Contiuous. make Sure It is get Than The Extent IT

IS Trying to allocate. You can reduce the Storage Parameters next and

Pctincrease if it isn't.

2) ORA-1556 Max Extents of 121 Exceeded When Storage IS set for maxextents

Of 999.

Most Platforms Have A Max of 121 Even Though It Allows you to specify

999. (See the Readme for your Platform)

3) ORA-1090 Shutdown in Progress When Starting Up Even A shutdown was

Issued Quite Some Time Ago.

If the background processes aren't Running The Sga Could Have Been Left

Out there ... Issue a startup force open (Which Does A Shutdown Abort

First).

4) IMP-0003, ORA-942 and IMP-00023 ON Import.

Run catalog.sql and express.sql (renamed catexp.sql in v7) as sys before

The import. Both Files Are IN $ Oracle_Home / Rdbms / Admin (UNIX).

5) ORA-904 INVALID Column Name on Import.

Run ExpVew.sql (catexp.sql) Before the import.

6) ORA-1034 Oracle NOT AVAILABLE.

Startup The DB First ... if it is started the check your searchpa.

Make Sure That Oracle_sid IS Set Correctly for Setuid Issues, See

PRE 1006554.6.

7) ORA-1578 Oracle Data Block Corrupted (File # Num and Block # Num)

To DETERMINE WHERE CORRUPTION IS: Select * from sys.dba_extents where file_id = filenum and blocknum

Between Block_ID and (Block_id Blocks - 1);

The Filenum and Blocknum Are The Numbers in The 1578 Error.

THIS Query Should Give The Segment_name and Segment_Type

(I.e Table and ITS Name).

In Order to Salvage The Uncorrupted Part of The Table You CAN Add

An entry to the init.ora:

Event = "10231 Trace Name Context Forever"

This Will Skip The Corrupted Block on a Table Scan. Export The Table,

Drop and recreate it from import.

8) ORA-604 What Does it mean?

USUALLY IT COMES WITH Another Error Such As 1547 .... IF IT CAN't Be Found

In any of the trace files try setting the folowing time in init.ora and

Restarting the db.

Event = "604 TRACE Name Errostack Forever"

For the Output of this Look in The THE FILES in The Directory Given By

The user_dump_dest parameter in init.ora.

9) My CREATE DATABASE IS FAILING WITH ORA-1519: Error While Processing File

Take out the init_sql_files param out of init.ora, Run the scripts

By Hand After The Database Is Created.

10) Out of shared memory (ORA-4031).

Try de-fragmenting the shared pool by running an 'ALTER SYSTEM FLUSH

Shared_pool 'if That is not enough, increase the shared_pool_size

Parameter.

==

转载请注明原文地址:https://www.9cbs.com/read-120918.html

New Post(0)