linux下oracle命令 err,oerr linux下的Oracle简单命令

http://inthirties.com:90/thread-1284-1-1.html

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命令把。