oerr 命令
oerr是一個簡單而非常有用的命令,linux/unix的平臺安裝完Oracle就已經帶有了。
window平臺可以到網上下載
這個命令可以快速的查詢一個根據oracle錯誤號的查到錯誤概要描述
比如,ora、imp、nid、rman、tns等:
$ oerr ora 39213
39213, 00000, "Metadata processing is not available"
// *Cause: The Data Pump could not use the Metadata API. Typically,
// this is caused by the XSL stylesheets not being set up properly.
// *Action: Connect AS SYSDBA and execute dbms_metadata_util.load_stylesheets
// to reload the stylesheets.
$
[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.
D:\Software_for_Development\Oracle\Oracle_Tools\winoerr>oerr.bat imp 00091
00091, 00000, "Above error occurred on the following function and object: %s. Remaining PL/SQL blocks for this object will be skipped."
// *Cause: An error occurred while executing a PL/SQL block that implements the
// DDL for the named function and procedural object. A procedural object
// is one whose DDL is implemented as stored procedures rather than as
// standard SQL statements.
// *Action: Contact Oracle Worldwide Support so they may determine the
// development group responsible for the package that failed.
最方便的工具就在你的旁邊,不要捨近求遠的去找ora-err這樣的網站了。
執行你的oerr命令把。
下載:
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/14710393/viewspace-751326/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 剖析Oracle中oerr命令Oracle
- oracle10g oerr 命令使用Oracle
- 【故障處理】【oerr】【grep】謹防grep“花哨”功能導致oerr工具無法使用
- oracle 自帶錯誤提示工具oerrOracle
- Linux/Uninx下Oracle的oerr工具的使用LinuxOracle
- [20140814]oerr for windows.txtWindows
- oerr錯誤查詢工作的使用與ora-56729錯誤的處理
- OERR: ORA-1499 table/Index Cross Reference Failure - see trace file [ID 1499.1]IndexROSAI
- cmd 命令列 命令命令列
- windows命令列命令Windows命令列
- Linux命令之rz命令與sz命令Linux
- Hadoop Shell命令 |HDFS Shell命令| HDFS 命令Hadoop
- java命令--jmap命令使用Java
- Linux命令—–CP命令Linux
- 【Linux命令】grep命令Linux
- hadoop命令fsck命令Hadoop
- ipcs命令和ipcrm命令
- Linux命令--ps命令Linux
- Linux命令(1)——xargs命令Linux
- Linux命令篇 - grep 命令Linux
- Linux命令篇 - sed 命令Linux
- Linux命令篇 - tar 命令Linux
- Linux命令列與命令Linux命令列
- linux命令 之 du 命令Linux
- 【AIX 命令學習】mkvg 命令AI
- SQL*PLUS命令, set命令大全SQL
- linux命令:ping命令Linux
- Linux命令之lldptool命令Linux
- 命令
- AT命令
- 批處理命令之tree命令
- linux每日命令(32):gzip命令Linux
- linux每日命令(29):chown命令Linux
- linux每日命令(18):whereis命令Linux
- linux每日命令(36):wc命令Linux
- linux每日命令(35):grep命令Linux
- linux每日命令(37):top命令Linux
- linux每日命令(39):lsof命令Linux