I have written in the past a small C program which does the same as oerr only faster, especially for 'high' error numbers (using binary searches on the files); it is written for Unix but can easily be adapted to Windows - for those who don't have perl installed ...
http://www.oriole.com/scripts/foerr.c Note that if somebody takes the pain to modify it for Windows, I'll appreciate being e-mailed the modified source. >----- ------- Original Message ------- ----- >From: "Mark Leith" <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Wed, 10 Sep 2003 01:54:23 > >Yechiel, > >oerr isn't installed on Windows machines - only on >UNIX installs.. oerr is >basically a shell script that reads the oraus.msg >file under a UNIX install >(and some others too I think). Windows has a binary >file under >%ORACLE_HOME%\RDBMS\mesg\oraus.msb, which if you >open it has the >descriptions pretty much in plain text, but the >error codes aren't very >legible.. > >There are a couple of ways to get the functionality >on Windows though. Some >require you to have access to a Oracle on UNIX >install, so that you can >parse the $ORACLE_HOME/RDBMS/mesg/oraus.msg file, >and load the contents in >to a database table. > >You can use sqlerrm(-600) from within SQL*PLus, but >this only provides the >ORA errors, you don't get TNS etc. > >If you have perl installed, there is a perl script >available on orafaq.org >that can be used to simulate the oerr utility, it's >here: > >http://www.orafaq.org/scripts/perl/oerr.txt > >Grab the PDF documentation.. ;) > >HTH > >Mark > >=================================================== > > Mark Leith | T: +44 (0)1905 330 281 > Sales & Marketing | F: +44 (0)870 127 5283 > Cool Tools UK Ltd | E: [EMAIL PROTECTED] >=================================================== > > http://www.cool-tools.co.uk > Maximising throughput & performance > > >-----Original Message----- >Yechiel Adar >Sent: 10 September 2003 09:54 >To: Multiple recipients of list ORACLE-L > > >Hello Jared > >What is the oerr utility? >I just finished searching my disk for *oerr* and no >exe or com file found. >Oracle 9.2.0.4 on windows. > >Yechiel Adar >Mehish >----- Original Message ----- >To: "Multiple recipients of list ORACLE-L" ><[EMAIL PROTECTED]> >Sent: Tuesday, September 09, 2003 5:54 PM > > >> >> The error message should be a definite clue. >> >> If you're not familiar with the 'oerr' utility, >now is >> the time to try it out. >> >> On either of your servers, type this command from >the >> system command prompt: oerr ora 12154 >> >> The info provided there should make it clear that > >> some modification are needed to your sqlnet ( net >8, >> oracle net, whatever) environment on the server >> with the 9i database. >> >> Jared >> >> On Mon, 2003-09-08 at 14:39, Hamid Alavi wrote: >> > Dear List, >> > >> > I have two database one on 8.1.7.4 on sun >Solaris 8.2 and another one on >> > oracle 9.0.1(two separate box) I have created a >database link under >oracle >> > 8 to oracle 9 database & it's working fine from >8 to 9, but when I try >to >> > use this link from 9 to 8 it's failed to >ORA-12154. >> > Any idea what could be this?? >> > >> > Thanks allot for your help. >> > >> > >> > >> > Hamid Alavi >> > >> > Office : 818-737-0526 >> > Cell phone : 818-416-5095 >> > >> > -- >> > Please see the official ORACLE-L FAQ: >http://www.orafaq.net >> > -- >> > Author: Hamid Alavi >> > INET: [EMAIL PROTECTED] >> > >> > Fat City Network Services -- 858-538-5051 >http://www.fatcity.com >> > San Diego, California -- Mailing list >and web hosting services >> > >> > To REMOVE yourself from this mailing list, send >an E-Mail message >> > to: [EMAIL PROTECTED] (note EXACT spelling >of 'ListGuru') and in >> > the message BODY, include a line containing: >UNSUB ORACLE-L >> > (or the name of mailing list you want to be >removed from). You may >> > also send the HELP command for other >information (like subscribing). >> > >> >> >> -- >> Please see the official ORACLE-L FAQ: >http://www.orafaq.net >> -- >> Author: Jared Still >> INET: [EMAIL PROTECTED] >> >> Fat City Network Services -- 858-538-5051 >http://www.fatcity.com >> San Diego, California -- Mailing list and >web hosting services >> >> To REMOVE yourself from this mailing list, send >an E-Mail message >> to: [EMAIL PROTECTED] (note EXACT spelling of >'ListGuru') and in >> the message BODY, include a line containing: >UNSUB ORACLE-L >> (or the name of mailing list you want to be >removed from). You may >> also send the HELP command for other information >(like subscribing). > >-- >Please see the official ORACLE-L FAQ: >http://www.orafaq.net >-- >Author: Yechiel Adar > INET: [EMAIL PROTECTED] > >Fat City Network Services -- 858-538-5051 >http://www.fatcity.com >San Diego, California -- Mailing list and >web hosting services >To REMOVE yourself from this mailing list, send an >E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of >'ListGuru') and in >the message BODY, include a line containing: UNSUB >ORACLE-L >(or the name of mailing list you want to be removed >from). You may >also send the HELP command for other information >(like subscribing). >--- >Incoming mail is certified Virus Free. >Checked by AVG anti-virus system >(http://www.grisoft.com). >Version: 6.0.515 / Virus Database: 313 - Release >Date: 01/09/2003 >--- >Outgoing mail is certified Virus Free. >Checked by AVG anti-virus system >(http://www.grisoft.com). >Version: 6.0.515 / Virus Database: 313 - Release >Date: 01/09/2003 > >-- >Please see the official ORACLE-L FAQ: >http://www.orafaq.net >-- >Author: Mark Leith > INET: [EMAIL PROTECTED] > >Fat City Network Services -- 858-538-5051 >http://www.fatcity.com >San Diego, California -- Mailing list and >web hosting services >To REMOVE yourself from this mailing list, send an >E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of >'ListGuru') and in >the message BODY, include a line containing: UNSUB >ORACLE-L >(or the name of mailing list you want to be removed >from). You may >also send the HELP command for other information >(like subscribing). >http://download-uk.oracle.com/docs/cd/B10501_01/ser >ver.920/a96525.pdf >--------------------------------------------------- >------------------ >--------------------------------------------------- >------------------ >--------------------------------------------------- >------------------ >--------------------------------------------------- >------------------ Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
