oracle

推荐列表 站点导航

当前位置:首页 > 数据库 > oracle >

ORACLE常见错误代码的分析与解决(三)

来源:网络整理  作者:网络  发布时间:2020-12-09 18:16
ORACLE常见错误代码的分析与解决(三)...
handled by the Net8,two task,software.This message could occur if the shadow two-task process associated
避免ORA-00942的错误。

5>.检查同一个网上是否有重复的IP地址

Cause:The table or view entered does not exist,a synonym that is jnot allowed here was used,or a view was
Cause:A rollback segment can only be used by one instance and an instance is trying to bring a rollback


generated on the server at failure time.Existence of a trace file may suggest an Oracle internal error


解决方法:一般来说出现这个错误我们本身是无法解决的,只有从提高系统本身各方面来解决这个内部问题,如增加硬件
ORA-03113:end-of-file on communication channel
access to it.


has met a low-level,unexpected condition.Various causes of this message include:


一个报错例子如下:
相应的英文如下:

解决方法:1>.检查是否有服进程不正常死机,可从alert.log得知
产生原因:这是由于装载的表或视图不存在,多半是CATEXP.SQL还没有运行,无法执行Export视图,如果CATEXP.SQL已经运

The spelling of the table or view name.
Incorrectly restored files(错误的重建文件)

设备,调整系统性能,使用OPS(当然OPS从某种意义上说并不是一种好的解决方式)等。ORA-600错误的第一个变量用于标
ORA-01598:rollback segment “name” is not online

that requires the assistance of customer support.
segment online that is already in use.
File corruption(文件太老)
Time-outs(超时)
Action:Check the status of the rollback segment in DBA_ROLLBACK_SEGS.
2>.检查sql*Net Driver是否连接到ORACLE可执行程序

ORA-00600: internal error code, arguments: [1237], [], [], [], [], [], [], []
table the application tried to access does not exist in the database,or the application does not have
产生原因:通讯不正常结束,从而导致通讯通道终止

行,则可能是版本错误。
Cause:An unexpected end-of-file was processed on the communication channel.The problem could not be


相应的英文如下:
ORA-1636: rollback segment “name” is already online
Cause:The rollback segment was taken offline either manually or by SMON.
Contact the database administrator if the table needs to be created or if user or application priviledes
Action:If this message occurs during a commection attempt,check the setup files for the appropriate Net8
解决方法:因为Import和Export共享的一些视图是通过运行CATEXP.SQL来装载的(它们具有相同的视图),并不生成单独


communication vehicle,that is,the network or server machine went down.
相应的英文如下:


Action:Check that the values set in the initialization parameter file for parameters

That an existing table or view name exists.





记代码中错误的位置(代码中的每个部分的第一变量都不一样),从第二个到第五个变量显示附加信息,告诉OSS代码在哪


4>.检查同一个网上是否有两个同样名字的节点
Also, if attempting to access a table or view in another schema,make certain thecorrect schema is
ROLLBACK_SEGMENTS,ROLLBACK_SEGMENT_INITIAL,a

3>.检查服务器网络是否正常,如网络不通或不稳定等
里出现了错误。
正在看的ORACLE教程是:ORACLE常见错误代码的分析与解决(三)。ORA-00600:internal error code,arguments:[num],[?],[?],[?],[?]

connection is well established,and the error is not due to a physical failure,check if a trace file was

with a Net8 connect has terminated abnormally,or if there is a physical failure of the interprocess
dictionary.Certain privileges may required to access the table.If an application returned this message,the

That a view is not specified where a table is required
Failed data checks in memory(内存检索失败)



referenced where a table is required.Existing user tables and views can be listed by querying the data
ORA-00942:table or view does not exist

Hardware,memory,or I/O errors(硬件、内存或者磁盘错误)

的CATEXP.SQL,因而造成视图与Export代码不同步,较难保持彼此之间的兼容,用户就必须建立自己的Export应用,从而
块,就容易跟踪问题的来源。
Action:Check each of the following:
(系统状态和进程状态),系统状态存储将包括ORACLE RDBMS持有的当前对象的信息,进程状态转储则将显示特殊进程持

are required to access the table.
driver and confirm Net8 software is correctly installed on the server.If the message occurs after a
产生原因:这种错误通常为ORACLE的内部错误,只对OSS和ORACLE开发有用。ORA-600的错误经常伴随跟踪文件的状态转储

有的对象,当进程符合了某错误条件时,经常是由于一些信息取自它持有的一个块,如果我们知道这些错误进程持有的
referenced and that access to the object is granted.

Cause:This is a catchall internal error message for Oracle program exceptions.It indicates that a process

相关热词: oracle 解决

本站内容来源于网络,如有侵权请与我们联系,我们会及时删除,我们深感抱歉!
注:本站所有信息仅供用于网络技术学习参考,学习中请遵循相关法律法规!

本文地址: https://www.juheyunku.com/sql/oracle/1889.shtml

Copyright © www.juheyunku.com      关于 | 合作 | 声明 | 联系 | 更新 | 地图 | Tags

ORACLE常见错误代码的分析与解决(三)

2020-12-09 编辑:网络

handled by the Net8,two task,software.This message could occur if the shadow two-task process associated
避免ORA-00942的错误。

5>.检查同一个网上是否有重复的IP地址

Cause:The table or view entered does not exist,a synonym that is jnot allowed here was used,or a view was
Cause:A rollback segment can only be used by one instance and an instance is trying to bring a rollback


generated on the server at failure time.Existence of a trace file may suggest an Oracle internal error


解决方法:一般来说出现这个错误我们本身是无法解决的,只有从提高系统本身各方面来解决这个内部问题,如增加硬件
ORA-03113:end-of-file on communication channel
access to it.


has met a low-level,unexpected condition.Various causes of this message include:


一个报错例子如下:
相应的英文如下:

解决方法:1>.检查是否有服进程不正常死机,可从alert.log得知
产生原因:这是由于装载的表或视图不存在,多半是CATEXP.SQL还没有运行,无法执行Export视图,如果CATEXP.SQL已经运

The spelling of the table or view name.
Incorrectly restored files(错误的重建文件)

设备,调整系统性能,使用OPS(当然OPS从某种意义上说并不是一种好的解决方式)等。ORA-600错误的第一个变量用于标
ORA-01598:rollback segment “name” is not online

that requires the assistance of customer support.
segment online that is already in use.
File corruption(文件太老)
Time-outs(超时)
Action:Check the status of the rollback segment in DBA_ROLLBACK_SEGS.
2>.检查sql*Net Driver是否连接到ORACLE可执行程序

ORA-00600: internal error code, arguments: [1237], [], [], [], [], [], [], []
table the application tried to access does not exist in the database,or the application does not have
产生原因:通讯不正常结束,从而导致通讯通道终止

行,则可能是版本错误。
Cause:An unexpected end-of-file was processed on the communication channel.The problem could not be


相应的英文如下:
ORA-1636: rollback segment “name” is already online
Cause:The rollback segment was taken offline either manually or by SMON.
Contact the database administrator if the table needs to be created or if user or application priviledes
Action:If this message occurs during a commection attempt,check the setup files for the appropriate Net8
解决方法:因为Import和Export共享的一些视图是通过运行CATEXP.SQL来装载的(它们具有相同的视图),并不生成单独


communication vehicle,that is,the network or server machine went down.
相应的英文如下:


Action:Check that the values set in the initialization parameter file for parameters

That an existing table or view name exists.





记代码中错误的位置(代码中的每个部分的第一变量都不一样),从第二个到第五个变量显示附加信息,告诉OSS代码在哪


4>.检查同一个网上是否有两个同样名字的节点
Also, if attempting to access a table or view in another schema,make certain thecorrect schema is
ROLLBACK_SEGMENTS,ROLLBACK_SEGMENT_INITIAL,a

3>.检查服务器网络是否正常,如网络不通或不稳定等
里出现了错误。
正在看的ORACLE教程是:ORACLE常见错误代码的分析与解决(三)。ORA-00600:internal error code,arguments:[num],[?],[?],[?],[?]

connection is well established,and the error is not due to a physical failure,check if a trace file was

with a Net8 connect has terminated abnormally,or if there is a physical failure of the interprocess
dictionary.Certain privileges may required to access the table.If an application returned this message,the

That a view is not specified where a table is required
Failed data checks in memory(内存检索失败)



referenced where a table is required.Existing user tables and views can be listed by querying the data
ORA-00942:table or view does not exist

Hardware,memory,or I/O errors(硬件、内存或者磁盘错误)

的CATEXP.SQL,因而造成视图与Export代码不同步,较难保持彼此之间的兼容,用户就必须建立自己的Export应用,从而
块,就容易跟踪问题的来源。
Action:Check each of the following:
(系统状态和进程状态),系统状态存储将包括ORACLE RDBMS持有的当前对象的信息,进程状态转储则将显示特殊进程持

are required to access the table.
driver and confirm Net8 software is correctly installed on the server.If the message occurs after a
产生原因:这种错误通常为ORACLE的内部错误,只对OSS和ORACLE开发有用。ORA-600的错误经常伴随跟踪文件的状态转储

有的对象,当进程符合了某错误条件时,经常是由于一些信息取自它持有的一个块,如果我们知道这些错误进程持有的
referenced and that access to the object is granted.

Cause:This is a catchall internal error message for Oracle program exceptions.It indicates that a process

本站内容来源于网络,如有侵权请与我们联系,我们会及时删除,我们深感抱歉!
注:本站所有信息仅供学习参考!
本文地址为 https://www.juheyunku.com/sql/oracle/1889.shtml

相关文章

风云图片

推荐阅读

返回oracle频道首页