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.. ;) http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96525.pdf 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).
