Analysis and resolution of common ORACLE error codes (iii)
- 2020-05-06 11:51:04
- OfStack
Why it happens: this error is usually an internal fault of ORACLE and is only useful for OSS and ORACLE development. Errors in ORA-600 often accompany the state dump
of the trace file
(system state and process state), the system state store will contain information about the current object held by ORACLE RDBMS, and the process state dump will show the special process holding
Some object, when a process meets an error condition, is often due to some information taken from a block it holds, if we know that the error process holds
Block, it is easy to trace the source of the problem.
Solution: generally speaking, we can't solve this error by ourselves. We can only solve this internal problem by improving the system itself, such as adding hardware
Equipment, tuning system performance, using OPS (of course OPS is not a good solution in a sense), etc. The first variable of the ORA-600 error is used to label
Remember the location of the error in the code (the first variable in each part of the code is different), show additional information from the second to the fifth variable, tell OSS where the code is
There is an error in.
An example of error reporting is
ORA-00600: internal error code, arguments: [1237], [], [], [], [], [], [], []
The corresponding English is as follows:
Cause:This is a catchall internal error message for Oracle program exceptions.It indicates that a process
has met a low-level,unexpected condition.Various causes of this message include:
Es49en-outs (timeout)
File corruption(the file 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 (error rebuilding file)
Es84en-03113: end-of-file on communication channel
Cause: the communication ends improperly, resulting in the termination of the communication channel
Solution: 1>. Check if there is a server process abnormal crash, you can know
from alert.logCheck whether sql*Net Driver is connected to ORACLE executable
3>. Check whether the server network is normal, such as network is blocked or unstable
Check if there are two nodes on the same network with the same name
Check for duplicate IP address
on the same webThe 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 abnormally,or if there is a physical failure of the interprocess
communication 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 file was
generated on the server at failure time.Existence of a trace file may suggest an Oracle internal error
that requires the assistance of customer support.
ORA-00942:table or view does not exist
Reason: this is because the loaded table or view does not exist, most likely CATEXP.SQL has not run, unable to execute Export view, if CATEXP.SQL has shipped
Line, it may be a version error.
Solution: because some of the views Import and Export share are loaded by running CATEXP.SQL (they have the same view), they do not generate a separate
CATEXP.SQL. As a result, the view and Export code are out of sync, which makes it difficult to maintain compatibility with each other
Avoid errors with ORA-00942.
Cause:The table or view entered does not exist,a synonym that is jnot allowed here was used,or a view was
referenced where a table is required.Existing user tables and views can be listed by querying the data
dictionary.Certain privileges may required 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,make certain thecorrect schema is
referenced and that access to the object is granted.
Es218en-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.
Es236en-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 p
[1] [2] next page
The ORACLE tutorial you are looking at is: analysis and resolution of common ORACLE error codes (iii). arametersROLLBACK_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 the 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 common problems when we use the rollback segment. Es275en-01598 indicates that the current state of the rollback segment is "not online", and
cannot be made
Yes, change it to "online" state to use; Es280en-01636 indicates that the current rollback segment is already in the state of "online" and can be used directly without collecting
It.
ORA-1636 signalled during: alter rollback segment rb00 online
We may also encounter the following problem when making statistics: an rollback segment state is "Needs Recovery" phenomenon, this is due to ORACLE back
Failure to submit something in a table of things. The usual reason is that an datafile or tablespace is in the state of offline or an
The target of undo is destroyed or rollback segment is destroyed. The solution is to put all tablespace and datafile in online state, if
If you can't, do the following: 1>. Add event= "10015 trace name context lever
10 "; 2 >.shutdown database then restart; 3>. Under $ORACLE_HOME/rdbms/log, find trace file generated when startup; 4>. In trace file
, find the following information: "error recovery tx(#,#) object #"; 5>. object#(the same as object_id in the sys.dba_objects table) in
Find the name of object in the sys.dba_objects table; 6>. Drop the object drop; Put the rollback segment back to
in the init.ora file
In the parameter rollback_segments, delete event; 8 >.shutdown database then restart. At this point "Needs Recovery" problem should be fully resolved
Otherwise, rollback segment is broken.
ORA-01688:unable to extend table name.name partition NAME by NUM in tablespace NAME
Reason: the specified tablespace space is full and cannot be extended.
Solution: use the "ALTER TABLESPACE ADD DATAFILE" command to increase the file system file and the original partition, or to increase the size of INITIAL (e.g.
)
alter tablespace CDRS101 default storage(next 500M pctincrease 1)) should be able to solve, otherwise someone is using your table space
A large data file has been created on the web and your table space is running low.
An example of error reporting is
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
previous page [1] [2]