Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Urgent: ORA-12154 Error

Re: Urgent: ORA-12154 Error

From: Sanjay Kumar <ora_user_at_hotmail.com>
Date: Wed, 13 Dec 2000 12:41:32 -0800
Message-Id: <10709.124487@fatcity.com>


Try replacing the service_name entry with SID value.

Sanjay
----- Original Message -----
From: "Krishna Prasad" <krishna_at_nehanet.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, December 13, 2000 9:15 AM 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" <ORACLE-L_at_fatcity.com>
> 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_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
Received on Wed Dec 13 2000 - 14:41:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US