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).