RE: Urgent: ORA-12154 Error

From: Molina, Gerardo <Gerardo.Molina_at_schwab.com>
Date: Thu, 14 Dec 2000 15:58:52 -0800
Message-Id: <10710.124640@fatcity.com>

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-----
From: Krishna Prasad [mailto:krishna_at_nehanet.com] Sent: Thursday, December 14, 2000 3:21 PM To: Multiple recipients of list ORACLE-L Subject: Re: Urgent: ORA-12154 Error

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

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

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

Received on Thu Dec 14 2000 - 17:58:52 CST