The Oracle tutorial being looked at is: analysis and resolution of Oracle common error codes three.
--------------------------------------------------------------------------------
P align= "Justify" >ora-00600:internal error code,arguments:[num],[?],[?],[?],[?]
Reason: This error is usually an internal error of Oracle and is only useful for OSS and Oracle development. ORA-600 errors are often accompanied by a state dump of the trace file (System State and process State), the system state store will include information about the current object held by the Oracle RDBMS, and the process state dump will show the objects held by the special process, and when the process conforms to an error condition, Often because some information is taken from a block that it holds, it is easy to trace the source of the problem if we know the block the error process holds.
Workaround: In general, this error can not be solved by itself, only by improving the system itself to solve this internal problem, such as adding hardware devices, adjusting system performance, using OPS (of course, OPS is not a good solution in a sense) and so on. The first variable of the ORA-600 error is used to mark the location of the error in the code (the first variable in each part of the code is different), displaying additional information from the second to fifth variable, telling the OSS code where an error occurred.
An example of an error is as follows:
Ora-00600:internal error code, arguments: [1237], [], [], [], [], [], [], []
The corresponding English is as follows:
Cause:this is a catchall internal the error message for the Oracle program exceptions. It indicates that a process has met a low-level,unexpected condition. Various causes of this message include:
Time-outs (timeout)
File corruption (files 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 rebuild file)
Ora-03113:end-of-file on communication channel
Cause: Communication is terminated abnormally, resulting in communication channel termination
Solution: 1$#@62; Check if there is a service process abnormal panic, can learn from Alert.log
2$#@62;. Check to see if Sql*net driver is connected to an Oracle executable
3$#@62;. Check that the server network is normal, such as network or unstable
4$#@62;. Check the same internet is the 鐾 value of the reef?
5$#@62;. Check if there is a duplicate IP address on the same web
The corresponding English is as follows:
Cause:an unexpected End-of-file is processed on the communication channel. The problem could is 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 the Re is a physical failure of the interprocess communication vehicle,that is,the network or server machine went.
Action:if This message occurs during a commection Attempt,check the setup files for the appropriate NET8 driver and Confir M Net8 software is correctly installed on the server. If the message occurs an connection is very established,and the error is not due to a physical failure,check if a tra Ce file is generated on the server at failure time. Existence of a trace file may suggest to 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 of the catexp.sql is not yet running, the export view cannot be performed, and if Catexp.sql is already running, it may be a version error.
Workaround: Because some views of import and export sharing are loaded by running Catexp.sql (they have the same view) and do not generate separate catexp.sql, resulting in a different view from the export code, making it difficult to maintain compatibility with each other, users must build their own expo RT application, so as to avoid ORA-00942 errors.
The corresponding English is as follows:
Cause:the table or view entered does not exist,a synonym this is jnot allowed this is-used,or a view was referenced where A table is required. Existing user tables and views can is listed by querying the data dictionary. Certain privileges may required to access the table. If an application retur
[1] [2] [3] Next page
The Oracle tutorial being looked at is: analysis and resolution of Oracle common error codes three. Ned This message,the table the "application tried to access does not exist in the Database,or" application does not have Access to it.
Action:check each of the following:
The spelling of the table or view name.
That's a view isn't specified where a table is required
That is existing table or view name exists.
Contacts the database administrator if the table needs to is created or if user or application priviledes are required to a Ccess the table.
Also, if attempting to access a table or view in another schema,make certain thecorrect schema are referenced and that ACCE SS to the object is granted.
Ora-01598:rollback segment "Name" is not online
Cause:the rollback segment was taken offline either the 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, used by one instance and A instance are trying to bring A rollback segment online tha T is already in use.
Action:check that's values set in the initialization parameter file for parameters rollback_segments,rollback_segment_in Itial,and Rollback_segment_count are correctly set for the instance whiththe problem,also Check this instance is using The correct initialization parameter file. Make sure your are not confused about the difference between private and public rollback segments. The Oracle8 Server Administrator ' s Guide for more information about using rollback segments in Paraller mode.
All of the above errors are common problems when using rollback segments, ORA-01598 indicate that the status of the rollback segment currently in use is not online and cannot be used; ORA-01636 indicates that the current rollback segment is already online State, which can be used directly without having to set it again.
ORA-1636 signalled during:alter rollback segment rb00 Online
We may also encounter the following problems when doing statistics: a rollback segment State is "Needs Recovery", which is caused by the failure of Oracle to return a list of things that have not been submitted. Usually the reason for a datafile or tablespace is to be destroyed in the state of offline or a goal of undo or rollback segment destroyed. The solution is to put all the tablespace and datafile are on the online status, if not resolved to do the following work: 1$#@62; Add event= "10015 Trace name Context Forever lever 10" in Initsid.ora; Shutdown database and then reboot; 3$#@62; Under $oracle_home/rdbms/log, trace file;4$#@62 generated at startup is found;. In the trace file, locate the following information "Error recovery TX (#,#) object #" 5$#@62;. The name of the object is identified in the Sys.dba_objects table according to the object# (same as the object_id in the Sys.dba_objects table); Drop the object off; 7$#@62;. In the Init.ora file, put the rollback segment back in the rollback_segments parameter and delete the event;8$#@62;. Shutdown the database and reboot. At this time "Needs Recovery" problem should be completely solved, otherwise it is rollback segment was destroyed.
Ora-01688:unable to extend table Name.name partition name by NUM in Tablespace name
Reason: The specified tablespace space has been occupied and cannot be extended.
Workaround: Add File System files and original partitions using the ALTER tablespace add datafile command, or increase the size of the initial (such as: ALTER tablespace CDRS101 de
prev [1] [2] [3] Next page
The Oracle tutorial being looked at is: analysis and resolution of Oracle common error codes three. Fault storage (next 500M pctincrease 1)) should be able to resolve otherwise someone using your tablespace creates a larger data file that causes your tablespaces to be out of space.
An example of an error 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 is allocated for a table segment in Tablespace
Action:use the ALTER tablespace ADD datafile statement to the specified tablespace
--------------------------------------------------------------------------------
prev [1] [2] [3]
