oerr 命令
来源:互联网 发布:民法网络教育入学考试 编辑:程序博客网 时间:2024/06/06 16:25
oerr是一个简单而非常有用的命令,linux/unix的平台安装完Oracle就已经带有了。
window平台可以到网上下载
这个命令可以快速的查询一个根据oracle错误号的查到错误概要描述
比如
[oracle@dxzq10 ~]$ oerr ora 942
00942, 00000, “table or view does not exist”
// *Cause:
// *Action:
[oracle@dxzq10 ~]$ oerr ora 604
00604, 00000, “error occurred at recursive SQL level %s”
// *Cause: An error occurred while processing a recursive SQL statement
// (a statement applying to internal dictionary tables).
// *Action: If the situation described in the next error on the stack
// can be corrected, do so; otherwise contact Oracle Support.
[oracle@dxzq10 ~]$ oerr ora 19909
19909, 00000, “datafile %s belongs to an orphan incarnation”
// *Cause: Either the specified datafile was restored from a backup that was
// taken during a period of time that has already been discarded by
// a resetlogs operation, or Oracle cannot identify which database
// incarnation the file belongs to. The alert log contains more
// information.
// *Action: Restore a backup of this file that belongs to either the current
// or a prior incarnation of the database. If you are using RMAN
// to restore, RMAN will automatically select a correct backup.
来个TNS的错误
[oracle@dxzq10 ~]$ oerr tns 12541
12541, 00000, “TNS:no listener”
// *Cause: The connection request could not be completed because the listener
// is not running.
// *Action: Ensure that the supplied destination address matches one of
// the addresses used by the listener - compare the TNSNAMES.ORA entry with
// the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to
// go by way of an Interchange). Start the listener on the remote machine.
再来个rman的错误。
[oracle@dxzq10 ~]$ oerr rman 20242
20242, 1, “specification does not match any archive log in the recovery catalog”
// *Cause:
// *Action: check the archive log specifier
//
Exp的错误
[oracle@dxzq10 ~]$ oerr exp 00091
00091, 00000, “Exporting questionable statistics.”
// *Cause: Export was able export statistics, but the statistics may not be
// usuable. The statistics are questionable because one or more of
// the following happened during export: a row error occurred, client
// character set or NCHARSET does not match with the server, a query
// clause was specified on export, only certain partitions or
// subpartitions were exported, or a fatal error occurred while
// processing a table.
// *Action: To export non-questionable statistics, change the client character
// set or NCHARSET to match the server, export with no query clause,
// export complete tables. If desired, import parameters can be
// supplied so that only non-questionable statistics will be imported,
// and all questionable statistics will be recalculated.
还有这个
[oracle@dxzq10 ~]$ oerr NID 131
131, 1, “Control file is not current”
// *Cause: A non-current control file is currently mounted.
// *Action: Perform necessary actions to make the control file current and
// retry.
最方便的工具就在你的旁边,不要舍近求远的去找ora-err这样的网站了。
运行你的oerr命令把。
- oerr 命令
- oerr 命令的使用
- OERR: ORA-12519 客户端连接间歇性失败 使用命令查询oracle错误描述: oerr ora 12519
- OERR用法
- OERR用法
- oerr的用法
- oerr的使用
- Oracle oerr工具的使用
- Oracle排错工具oerr
- OERR: ORA-12519 错误处理
- 简介oracle oerr工具使用
- 跟踪事件(转帖)和linux-oerr
- 如何打包oerr客户端程序,而不是为了使用oerr工具而安装整个ORACLE数据库
- OERR: ORA-12519 TNS:no appropriate service handler found
- OERR: ORA-12519 TNS:no appropriate service handler found
- OERR: ORA-12519 TNS:no appropriate service handler found
- OERR: ORA-12519 TNS:no appropriate service handler found
- Linux/Uninx下Oracle的oerr工具的使用
- Failed to parse the output of 'adb version' 两种解决办法
- java.lang.OutOfMemoryError: PermGen space及其解决方法
- oracle字符串载取及判断是否包含指定字符串
- .globl的作用
- VMWare tools的安装过程及文件共享设置
- oerr 命令
- TreeView控件在IE7中连接线 对不齐
- VMware 5.5 Red Hat 9 屏幕分辨率调节详细方法
- QQTab切换特效
- CSS Float
- sql 语法 cast 不太清楚 还有ibatis语法
- 编程高手成长的六个阶段(梁肇新《编程高手箴言》)
- 在用户空间发生中断时,上下文切换的过程
- Decorator------设计模式