Analysis and Solution of Oracle Frequent Error Code (3)
The article is derived from the Century Easy Network
ORA-00600: Internal Error Code, Arguments: [NUM], [?], [?], [?], [?]
Cause: This error is usually an internal error of Oracle, which is only useful for OSS and Oracle development. ORA-600 errors often accompany the status dump of the file
(System Status and Process Status), system status storage will include information of the current object held by Oracle RDBMS, and process status dumps will display special processes
Some objects, often because some information is taken from one block it holds, if we know these error processes held
Blocks are easy to track the source of the problem.
Workaround: Generally speaking, this error is unable to solve it, only from improving the system itself to solve this internal problem, such as increasing hardware
Equipment, adjust system performance, using OPS (of course OPS is not a good solution from a certain sense), etc. The first variable of ORA-600 errors is used for standard
The location of the error in the code (the first variable of each part in the code is different), from the second to the fifth variable display additional information, tell the OSS code where
An error occurred.
An error example is as follows:
ORA-00600: INTERNAL ERROR CODE, Arguments: [1237], [], [], [], [], [], [], []
The corresponding English is as follows:
Cause: this is a catchall interface irestage for oracle program exceptions.it INDICES THAT A Process
HAS Met a low-level, unExpected Condition.various Causes of this message incrude:
Time-Outs (timeout)
FILE CORRUPTION (Document is too old)
Failed Data Checks in Memory (memory retrieval failed)
Hardware, Memory, OR I / O Errors (hardware, memory, or disk error)
IncorRectly Restored Files (wrong reconstruction file)
ORA-03113: End-of-file on Communication Channel
Cause: Communication is not ended normally, causing the communication channel to terminate
Workaround: 1>. Check if there is a service process is not normal to crash, you can know from Alert.log
2>. Check if SQL * NET Driver is connected to the Oracle executable
3>. Check if the server network is normal, such as the network is not in or unstable, etc.
4>. Check if there are two nodes of the same name
5>. Check if there is a repetition IP address on the same online
The corresponding English is as follows:
Cause: an unexpected end-of-file was processed on The Communication Channel.The Problem COULD NOT BE
Handled by the net8, two task, software.this message could occur if the shadow two-task process associated
WITH A NET8 Connect Has Terminated Abnormal, or if The InterprocessCommunication Vehicle, That IS, The Network OR Server Machine Went Down.
Action: if this Message Occurs During a commection Attempt, Check the setup files for the appropriate Net8
Driver and confirm Net8 Software Is Correctly Installed on The Server.if The Message Occurs After A
Connection is Well Established, and The Error Is Not Due to a Physical Failure, Check if A TRACE WAS
Generated on the Server At Failure Time.existence of a TRACE MAY SUGGEST An Oracle Internal Error
That Requires The Assistance of Customer Support.
ORA-00942: Table or view does not exist
Cause: This is because the loaded table or view does not exist, and most of the catexp.sql has not yet runned, it is not possible to execute the Export view, if catexp.sql has been shipped
OK, it may be a version error.
Solution: Some views shared by import and export are loaded by running catexp.sql (they have the same view), do not generate separate
CATEXP.SQL, thus causing the view and the Export code that is not synchronized, it is more difficult to maintain compatibility between each other, and the user must establish its own export app, thus
Avoid errors in ORA-00942.
The corresponding English is as follows:
Cause: The Table or View Entered Does Not Exist, A Synym That Is Jnot ALLOWED Here Was Used, or a View WAS
Reference.ere a Table is required.existing user tables and views can be listed by querying the data
Dictionary.certain privileges may request to access the table.if an application returned this message, the
Table the application tried to access does not exist in the database, or the application does not have
Access to it.
Action: Check Each of The Following:
The spelling of the Table or view name.
That a view is not specified where a Table is Required
That an existing table or view name exists.
Contact The Database Administrator if The Table Needs to Be created or if User or Application Priviledes
Are Required to Access The Table.Also, if Attempting to Access A Table or View in Another Schema
Reference and this access to the object is granted.
ORA-01598: ROLLBACK Segment "Name" is not online
Cause: The Rollback Segment Was Taken Offline Either Manually or by SMON.
Action: Check The Status of The Rollback Segment in DBA_ROLLBACK_SEGS.
ORA-1636: Rollback Segment "Name" is already Online
Cause: a Rollback Segment Can Only BE Used by One Instance and an Instance IS Trying to Bring A Rollback
Segment Online That IS Already in Use.
Action: Check That The Values Set in The Initialization Parameter File for Parameters
Rollback_SEGMENTS, ROLLBACK_SEGMENT_INITIAL, AND ROLLBACK_SEGMENT_COUNT ARE CORRECTLY SET for THE Instance
Whiththe Problem, Also Check That The Instance Is Using The Correct Initialization Parameter File.make Sure
You are not confused about Difference Between Private and public rollback segments.see the oracle8
Server Administrator's Guide for More Information About Using Rollback Segments in Paraller Mode.
The above errors are all common problems when we use the return segment, and ORA-01598 indicates that the status of the current returned segment is "Not Online", can't
Use, change it to "Online" status; ORA-01636 indicates that the current returning segment is already "Online" state, can be used directly, no need to set
it.
ORA-1636 SIGNALLED DURING: Alter Rollback Segment RB00 Online
We may also encounter the following problems when doing statistics: a phenomenon of "Needs Recovery", which is because Oracle Retreat
There is a failure when there is a thing in the form of things. Usually, a DataFile or TableSpace is in the state of OFFLINE or one
The goal of Undo is destroyed or the Rollback Segment is destroyed. The solution is to set all the tablespace and DataFile to an Online status, if
Can not solve the following work: 1>. Join Event = "10015 Trace Name Context Forever Lever in InIntSid.ora
10 "; 2> .shutdown database then restart; 3> Under $ ORACLE_HOME / RDBMS / LOG, find the trace file generated by Startup; 4>. In the Trace file, find the following information" Error Recovery TX (#, #, ) Object # "; 5>. According to Object # (same as Object_ID in the sys.dba_objects table)
The name of the object drop is found in the sys.dba_objects table; 6>. Object DROP is dropped; 7>. put the rollback segment back to the ROLLBACK Segment
In the Rollback_Segments parameter, delete the Event; 8> .shutdown database is restarted. The question of "Needs Recovery" should be completely solved.
Otherwise, Rollback Segment is destroyed.
ORA-01688: Unable to extend table name.name partition name by Num in TableSpace Name
Cause: The specified TableSpace space has been occupied and cannot be expanded.
Workaround: Use the "Alter TableSpace Add DataFile command to increase the file system file and the original partition, or add the size of the initial (such as:
ALTER TABLESPACE CDRS101 Default Storage (Next 500M PctinCrease 1)) should be able to solve, otherwise someone uses your table space
Create a relatively large data file caused your table space being not enough.
An error example is as follows:
ORA-1688: UNABLE TO EXTEND TABLE RMMCDR.LOCAL_CDR Partition Local_CDR101 by 460800 in TableSpace CDRS101
The corresponding English is as follows:
Cause: An Extent Could Not Be Allocated for a Table Segment in TableSpace
Action: Use the alter tablespace add datafile statement to add one or more files to the specified tablespace
