jump to navigation

oerr – Obtener la descripcion de un mensaje de error de Oracle marzo 22, 2007

Posted by superpiwi in Java, Oracle, Programacion, Unix.
trackback

oerr (Oracle error utility) es un shell script que se instala en las bases de datos de Oracle y unicamente en las plataformas UNIX. Nos sirve para obtener rapidamente la descripcion de un error a partir de su codigo.


$(manager): /manager > oerr
Usage: oerr facility error
Facility is identified by the prefix string in the error message.
For example, if you get ORA-7300, "ora" is the facility and "7300"
is the error. So you should type "oerr ora 7300".
If you get LCD-111, type "oerr lcd 111", and so on.
$(manager): /manager > oerr ora 1000
01000, 00000, "maximum open cursors exceeded"
// *Cause:
// *Action:

Para windows existen alternativas.

http://www.oracleutilities.com/OSUtil/oerr.html

http://www.jlcomp.demon.co.uk/faq/windowsoerr.htm

Tambien para encontrar la descripcion del error puedes utilizar un buscador como Google, pero lo anterior te sirve cuando no siempre tienes acceso a Internet.

Comentarios»

1. Immigration Lawyers in maidstone - enero 17, 2013

Its such as you learn my thoughts! You seem to know
so much about this, such as you wrote the ebook in it or something.
I think that you simply can do with a few p.c. to force the message home
a bit, however instead of that, that is excellent blog.
A fantastic read. I will certainly be back.

2. dc comics online - junio 20, 2016

Undeniably imagine that that you said. Your favorite justification seemed
to be on the internet the simplest thing to be
mindful of. I say to you, I certainly get irked at the same time as folks think about concerns that they just do not recognise about.
You managed to hit the nail upon the highest as well as defined out the
entire thing without having side effect , people can take
a signal. Will probably be back to get more.
Thank you


Responder

Introduce tus datos o haz clic en un icono para iniciar sesión:

Logo de WordPress.com

Estás comentando usando tu cuenta de WordPress.com. Cerrar sesión / Cambiar )

Imagen de Twitter

Estás comentando usando tu cuenta de Twitter. Cerrar sesión / Cambiar )

Foto de Facebook

Estás comentando usando tu cuenta de Facebook. Cerrar sesión / Cambiar )

Google+ photo

Estás comentando usando tu cuenta de Google+. Cerrar sesión / Cambiar )

Conectando a %s

A %d blogueros les gusta esto: