ORACLE常见错误代码的分析与解决(三)
避免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,a3>.检查服务器网络是否正常,如网络不通或不稳定等
里出现了错误。
正在看的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
相关文章
热门TAG
命令 权重 外链 企业网站 白帽 php 织梦教程 dedecms修改内容 javascript 织梦 功能 标签 调用 详解 服务器 网站流量 实例解析 Dedecms 织梦cms HTML tags标签 python jquery教程 jquery windows SEO优化 蜘蛛 搜索引擎 网站收录 JSP最新文章
-
Window下Oracle Database 11g 发行
时间:2020-12-29
-
Oracle如何实现like多个值的
时间:2020-12-29
-
maven添加oracle依赖失败问题
时间:2020-12-29
-
OracleRAC基本概念及入门
时间:2020-12-29
-
Azure File Storage 基本用法
时间:2020-12-26
-
Oracle 权限(grant revoke)
时间:2020-12-26
-
Azure Queue Storage 基本用法
时间:2020-12-26
-
如何对比迁移前后的Orac
时间:2020-12-26
热门文章
-
Azure Queue Storage 基本用法 Azure Storage 之
时间:2020-12-26
-
Oracle存储过程编程详解
时间:2020-12-07
-
win10下oracle 11g安装图文教程
时间:2020-12-25
-
oracle 数据库学习 基本结构介绍
时间:2020-12-13
-
Azure File Storage 基本用法 Azure Storage 之 F
时间:2020-12-26
-
windows使用sqlpus连接oracle 数据库的教程图
时间:2020-12-25
-
Window下Oracle Database 11g 发行版2安装教程
时间:2020-12-29
-
Oracle解锁的方式介绍
时间:2020-12-14
-
linux下oracle设置开机自启动实现方法
时间:2020-12-13
-
Oracle学习记录之使用自定义函数和触发器
时间:2020-12-07
