oerr小工具研究
以前发新eygle大师它们在使用这个工具获取oracle的错误信息。最近仔细看了看$ORACLE_HOME/bin目录。才弄明白这个工具是oracle在linux/unix平台下提供的快送获取oracle错误信息的工具。他有两个参数:
oerr
比如我们有一个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平台还没发现类似的工具
[@more@]来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/129805/viewspace-920039/ ，如需转载，请注明出处，否则将追究法律责任。
