Message-Id: <10709.124504@fatcity.com> From: Suzy Vordos Date: Wed, 13 Dec 2000 14:59:22 -0700 Subject: Re: Urgent: ORA-12154 Error Is the database listener on a different port than 1521? Here I run multiple listeners and found the same problem with listeners on different ports. The workaround was changing connect_data in tnsnames.ora: this did not work: (connect_data=(service_name=db_name.domain)) this works for any port: (connect_data=(service_name=db_name)) Hope this helps, Suzy Krishna Prasad wrote: > > 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