Thanks: Re: Urgent: ORA-12154 Error

Thanks for all your advice. There was an IP clash - after I resolved it, it works fine now.

-Krishna.
----- Original Message -----
From: "Oliver Artelt" <oli_at_md.transnet.de> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, December 14, 2000 5:15 PM Subject: Re: Urgent: ORA-12154 Error

>
> Are you using global names?
>
> Try nnsun1.= or nnsun1.mydomain.com in your tnsnames.ora
>
>
> oli
>
> On Friday 15 December 2000 01:47, Gerardo.Molina_at_schwab.com wrote:
> > See Note 114085.1 on MetaLink (or use ORA-12154 as search word)
> >
> > Excellent step-by-step troubleshooting guide for this particular error.
> >
> > HTH
> > Gerardo
> > -----Original Message-----
> > Sent: Thursday, December 14, 2000 3:21 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi,
> >
> > I seems to have the right "SID" reference and am still getting the same
> > error - I've
> > enclosed relevant portions of the listener.ora and tnsnames.ora on the
two
> > machines...
> >
> > I'd appreciate any help.
> > Thanks,
> > -Krishna.
> >
> > /*** listener.ora ***/
> > SID_LIST_LISTENER =
> > (SID_LIST =
> > (SID_DESC =
> > (SID_NAME = PLSExtProc)
> > (ORACLE_HOME = /data1/app/oracle/8.1.7)
> > (PROGRAM = extproc)
> > )
> > (SID_DESC =
> > (GLOBAL_DBNAME = nnsun)
> > (ORACLE_HOME = /data1/app/oracle/8.1.7)
> > (SID_NAME = nnsun)
> > )
> > (SID_DESC =
> > (GLOBAL_DBNAME = nnsun1.world)
> > (ORACLE_HOME = /data1/app/oracle/8.1.7)
> > (SID_NAME = nnsun1)
> > )
> > )
> >
> > /*** tnsnames.ora ***/
> >
> > NNSUN1 =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = nnsun)(PORT = 1521))
> > )
> > (CONNECT_DATA =
> > (SERVICE_NAME = nnsun1.world)
> > )
> > )
> > /***************************************************************/
> >
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Wednesday, December 13, 2000 9:15 AM
> >
> > > 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
> > > also send the HELP command for other information (like subscribing).
>
> --
> ---
>
> Oliver Artelt, System- und Datenbankadministration
> ---------------------------------------------------------------
> cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
> telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
> email: oli@cubeoffice.de # web: http://www.cubeoffice.de
> ---------------------------------------------------------------
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Oliver Artelt
> INET: oli_at_md.transnet.de
>
> 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
Received on Fri Dec 15 2000 - 16:18:06 CST