oerr linux下的Oracle简单命令

oerr linux下的Oracle简单命令

oerr linux下的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命令把。

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。