| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_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.
> 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.
> >
>
> --------------------------------------------------------------------------
--Received on Wed Dec 13 2000 - 14:29:29 CST
> > ------------
> > 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_at_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_at_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_at_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_at_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
 |
 |