oerr 小工具的用法

http://shadowfalao.itpub.net/post/2483/297247

这个工具是oracle在linux/unix平台下提供的快送获取oracle错误信息的工具。他有两个参数:

oerr <error_type> <error_code>

比如我们有一个ora4031的错误,求助如下：

[oracle@rac1 ~]$ oerr ora 4031
04031, 00000, "unable to allocate %s bytes of shared memory ("%s","%s","%s","%s")"
// *Cause: More shared memory is needed than was allocated in the shared
// pool.
// *Action: If the shared pool is out of memory, either use the
// dbms_shared_pool package to pin large packages,
// reduce your use of shared memory, or increase the amount of
// available shared memory by increasing the value of the
// INIT.ORA parameters "shared_pool_reserved_size" and
// "shared_pool_size".
// If the large pool is out of memory, increase the INIT.ORA
// parameter "large_pool_size".

tns12560 错误求助:

[oracle@rac1 ~]$ oerr tns 12560
12560, 00000, "TNS:protocol adapter error"
// *Cause: A generic protocol adapter error occurred.
// *Action: Check addresses used for proper protocol specification. Before
// reporting this error, look at the error stack and check for lower level
// transport errors. For further details, turn on tracing and reexecute the
// operation. Turn off tracing when the operation is complete.

方便快捷啊，但目前windows平台还没发现类似的工具

Trackback URL: http://blog.itpub.net//trackback.php?id=297560