Message-Id: <10709.124483@fatcity.com> From: "Gogala, Mladen" Date: Wed, 13 Dec 2000 15:29:29 -0500 Subject: RE: Urgent: ORA-12154 Error Incorrect listener.ora configuration. You should use the old fashioned SID based addresses and not 8i service names. -----Original Message----- From: Krishna Prasad [mailto:krishna@nehanet.com] Sent: Wednesday, December 13, 2000 12:16 PM To: Multiple recipients of list ORACLE-L Subject: Urgent: ORA-12154 Error Hi, I'm trying to conenct to an Oracle 8.1.7 (on Solaris8) instance from another workstation on the LAN but get the "ORA-12154" error (cannot resolve SERVICE_NAME) I checked and double-checked the entries in listener.ora and tnsnames.ora in the respective machines... everything appears ok... (I can connect using the @connect_String) from the same machine the instance is on... Also, I can succesfully "tnsping" the alias from the workstation... My database name is nnsun (and global dbName is nnsun.WORLD)... Any insight would be greatly appreciated. Thanks, -Krishna. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" Sent: Tuesday, December 12, 2000 10:08 PM > did you try http://www.cpan.org? > Kimberly Smith wrote: > > > Anyone know a good site to get the Perl DBI and DBD for Oracle that > > will work with ActivePerl 5.6 on Windows 2000. Having issues. > > > > -------------------------------------------------------------------------- -- > > ------------ > > Kimberly Smith > > EDS > > Fujitsu/GMD > > 21015 SE Stark St > > Gresham, OR > > 97030 > > Phone: (503) 669-6050 > > Fax : (503) 669-5705 > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Kimberly Smith > > INET: kimberly.smith@gmd.fujitsu.com > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California -- Public Internet access / Mailing Lists > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: ListGuru@fatcity.com (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.com -- Author: Krishna Prasad INET: krishna@nehanet.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (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