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

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

OT: Urgent: ORA-12154 Error

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Wed, 13 Dec 2000 16:10:12 -0500
Message-Id: <10709.124493@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C06549.14E90F50
Content-Type: text/plain;

        charset="iso-8859-1"

Incorrect again, Mladen. I have it on very good authority that this is because the log buffer is flushing every 1.0000128 Mbytes or one hemi-demi-semi-quaver, whichever comes first.

;->

-Larry Ellison

-----Original Message-----
From: Gogala, Mladen [mailto:MGogala_at_oxhp.com] Sent: Wednesday, December 13, 2000 3:33 PM To: Multiple recipients of list ORACLE-L 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-----
Sent: Wednesday, December 13, 2000 12:16 PM To: Multiple recipients of list ORACLE-L

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

>
> --------------------------------------------------------------------------
--

> > ------------
> > 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 also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: MGogala_at_oxhp.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). ------_=_NextPart_001_01C06549.14E90F50 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12"> <TITLE>OT: Urgent: ORA-12154 Error</TITLE> </HEAD> <BODY> <P><FONT SIZE=2>Incorrect again, Mladen.&nbsp; I have it on very good authority that </FONT> <BR><FONT SIZE=2>this is because the log buffer is flushing every 1.0000128 Mbytes </FONT> <BR><FONT SIZE=2>or one hemi-demi-semi-quaver, whichever comes first. </FONT> </P> <P><FONT SIZE=2>;-&gt;</FONT> </P> <P><FONT SIZE=2>-Larry Ellison</FONT> </P> <P><FONT SIZE=2>-----Original Message-----</FONT> <BR><FONT SIZE=2>From: Gogala, Mladen [<A HREF="mailto:MGogala_at_oxhp.com">mailto:MGogala_at_oxhp.com</A>]</FONT> <BR><FONT SIZE=2>Sent: Wednesday, December 13, 2000 3:33 PM</FONT> <BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=2>Subject: RE: Urgent: ORA-12154 Error</FONT> </P> <BR> <P><FONT SIZE=2>Incorrect listener.ora configuration. You should use the</FONT> <BR><FONT SIZE=2>old fashioned SID based addresses and not 8i service names.</FONT> </P> <P><FONT SIZE=2>-----Original Message-----</FONT> <BR><FONT SIZE=2>Sent: Wednesday, December 13, 2000 12:16 PM</FONT> <BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT> </P> <BR> <P><FONT SIZE=2>Hi,</FONT> </P> <P><FONT SIZE=2>I'm trying to conenct to an Oracle 8.1.7 (on Solaris8) instance from another</FONT> <BR><FONT SIZE=2>workstation on the LAN but get the &quot;ORA-12154&quot; error (cannot resolve</FONT> <BR><FONT SIZE=2>SERVICE_NAME)</FONT> </P> <P><FONT SIZE=2>I checked and double-checked the entries in listener.ora and tnsnames.ora in</FONT> <BR><FONT SIZE=2>the respective</FONT> <BR><FONT SIZE=2>machines... everything appears ok... (I can connect using the</FONT> <BR><FONT SIZE=2>@connect_String) from the</FONT> <BR><FONT SIZE=2>same machine the instance is on...</FONT> </P> <P><FONT SIZE=2>Also, I can succesfully &quot;tnsping&quot; the alias from the workstation... My</FONT> <BR><FONT SIZE=2>database name is</FONT> <BR><FONT SIZE=2>nnsun (and global dbName is nnsun.WORLD)...</FONT> </P> <P><FONT SIZE=2>Any insight would be greatly appreciated.</FONT> </P> <P><FONT SIZE=2>Thanks,</FONT> <BR><FONT SIZE=2>-Krishna.</FONT> </P> <P><FONT SIZE=2>----- Original Message -----</FONT> <BR><FONT SIZE=2>To: &quot;Multiple recipients of list ORACLE-L&quot; &lt;ORACLE-L_at_fatcity.com&gt;</FONT> <BR><FONT SIZE=2>Sent: Tuesday, December 12, 2000 10:08 PM</FONT> </P> <BR> <P><FONT SIZE=2>&gt;&nbsp;&nbsp;&nbsp;&nbsp; did you try http://www.cpan.org?</FONT> <BR><FONT SIZE=2>&gt; Kimberly Smith wrote:</FONT> <BR><FONT SIZE=2>&gt;</FONT> <BR><FONT SIZE=2>&gt; &gt; Anyone know a good site to get the Perl DBI and DBD for Oracle that</FONT> <BR><FONT SIZE=2>&gt; &gt; will work with ActivePerl 5.6 on Windows 2000.&nbsp; Having issues.</FONT> <BR><FONT SIZE=2>&gt; &gt;</FONT> <BR><FONT SIZE=2>&gt;</FONT> <BR><FONT SIZE=2>&gt; --------------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>--</FONT> <BR><FONT SIZE=2>&gt; &gt; ------------</FONT> <BR><FONT SIZE=2>&gt; &gt; Kimberly Smith</FONT> <BR><FONT SIZE=2>&gt; &gt; EDS</FONT> <BR><FONT SIZE=2>&gt; &gt; Fujitsu/GMD</FONT> <BR><FONT SIZE=2>&gt; &gt; 21015 SE Stark St</FONT> <BR><FONT SIZE=2>&gt; &gt; Gresham, OR</FONT> <BR><FONT SIZE=2>&gt; &gt; 97030</FONT> <BR><FONT SIZE=2>&gt; &gt; Phone:&nbsp; (503) 669-6050</FONT> <BR><FONT SIZE=2>&gt; &gt; Fax&nbsp;&nbsp;&nbsp; :&nbsp; (503) 669-5705</FONT> <BR><FONT SIZE=2>&gt; &gt;</FONT> <BR><FONT SIZE=2>&gt; &gt; --</FONT> <BR><FONT SIZE=2>&gt; &gt; Please see the official ORACLE-L FAQ: http://www.orafaq.com</FONT> <BR><FONT SIZE=2>&gt; &gt; --</FONT> <BR><FONT SIZE=2>&gt; &gt; Author: Kimberly Smith</FONT> <BR><FONT SIZE=2>&gt; &gt;&nbsp;&nbsp; INET: kimberly.smith_at_gmd.fujitsu.com</FONT> <BR><FONT SIZE=2>&gt; &gt;</FONT> <BR><FONT SIZE=2>&gt; &gt; Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>&gt; &gt; San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists</FONT> <BR><FONT SIZE=2>&gt; &gt; --------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>&gt; &gt; To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=2>&gt; &gt; to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=2>&gt; &gt; the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=2>&gt; &gt; (or the name of mailing list you want to be removed from).&nbsp; You may</FONT> <BR><FONT SIZE=2>&gt; &gt; also send the HELP command for other information (like subscribing).</FONT> <BR><FONT SIZE=2>&gt;</FONT> </P> <P><FONT SIZE=2>-- </FONT> <BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.com</FONT> <BR><FONT SIZE=2>-- </FONT> <BR><FONT SIZE=2>Author: Krishna Prasad</FONT> <BR><FONT SIZE=2>&nbsp; INET: krishna_at_nehanet.com</FONT> </P> <P><FONT SIZE=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists</FONT> <BR><FONT SIZE=2>--------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=2>(or the name of mailing list you want to be removed from).&nbsp; You may</FONT> <BR><FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT> <BR><FONT SIZE=2>-- </FONT> <BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.com</FONT> <BR><FONT SIZE=2>-- </FONT> <BR><FONT SIZE=2>Author: Gogala, Mladen</FONT> <BR><FONT SIZE=2>&nbsp; INET: MGogala_at_oxhp.com</FONT> </P> <P><FONT SIZE=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists</FONT> <BR><FONT SIZE=2>--------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
Received on Wed Dec 13 2000 - 15:10:12 CST

Original text of this message

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