RE: ORA-12514 TNS names could not resolve service name

Thanks for the tip - we just installed 8.1.6 on NT this afternoon and had the problem. Your solution did the trick!!!

Laura H. Myers
AT&T Solutions-ITS
lhmyers_at_att.com
Phone: (336) 698-2375
Fax: (336) 698-2385

> ----------
> From: Ruiz, Mary A (CAP, CDI)[SMTP:Mary.Ruiz_at_gecapital.com]
> Sent: Thursday, February 01, 2001 2:20 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: ORA-12514 TNS names could not resolve service name
>
> Rick:
> In tnsnames.ora, is the entry listed as "satt.world" ?
> If so, then check the sqlnet.ora file, to see if there is a line
> names.default_domain = world
>
> Just a shot in the dark,
> Mary Ruiz / Atlanta GA
>
> -----Original Message-----
> Sent: Thursday, February 01, 2001 1:27 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi All,
>
> NT 4/Oracle 8.1.6
>
> I can do a tnsping satt. The entry is in tnsnames.ora. When I try to
> connect
> using sqlplus
> I get ora-12514. This is a new installation. Everything is loaded on the
> same computer. It connects
> fine without service name but for other reasons I want to connect using
> service name.
> Any ideas?
>
> Thanks
> Rick Cale, Science Applications International Corp.
> Phone:865-481-2198, fax:865-481-8555
> e-mail: caler_at_saic.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Cale, Rick T (Richard)
> INET: RICHARD.T.CALE_at_saic.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: Ruiz, Mary A (CAP, CDI)
> INET: Mary.Ruiz_at_gecapital.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: Myers, Laura H, SITS
  INET: lhmyers_at_att.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).