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