| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: tnsnames.ora
--=_ORCL_5932326_0r0
Content-Type:text/plain; charset="iso-8859-1"
Content-Transfer-Encoding:quoted-printable
Let me get this straight.
You have orcl.world in your tnsnames.ora and can connect when
using orcl.world but not when using orcl. You changed it
to orcl.c and could connect when using that. I am guessing
that you could not use just orcl in that case but you did not
mention this.
If all of the above is true then it looks like you do not have
the default domain set in your sqlnet.ora file or its set to
something other then world. The .world part is the domain.
Either set your domain or use the whole text.
kimberly.smith_at_eds.com
--=_ORCL_5932326_0r0
content-type:message/rfc822
Date: 01 May 2000 13:00:49
From:Eric Fang <eric_fang_at_yahoo.com>
To:Multiple recipients of list ORACLE-L <ORACLE-L>
Subject:tnsnames.ora
Reply-to:UNIX.IOGMD:ORACLE-L_at_fatcity.com
Return-Path:root_at_fatcity.cts.com
Received:from gmd.fujitsu.com (ducks.gmd.fujitsu.com [198.6.119.2]) by hdoc02.gmd.fujitsu.com with SMTP (8.7.1/8.7.1) id NAA01760 for <ksmith1.ofcmail_at_hdbi01>; Mon, 1 May 2000 13:36:23 -0700 (PDT) Received:from dfwl01.gmd.fujitsu.com by gmd.fujitsu.com (SMI-8.6/) id NAA17365; Mon, 1 May 2000 13:36:17 -0700 Received:from dfwl01.gmd.fujitsu.com (root_at_localhost) by dfwl01.gmd.fujitsu.com with ESMTP id NAA24860 for <ksmith1_at_gmd.fujitsu.com>; Mon, 1 May 2000 13:36:16 -0700 (PDT) Received:from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199]) by dfwl01.gmd.fujitsu.com with ESMTP id NAA24856 for <ksmith1_at_gmd.fujitsu.com>; Mon, 1 May 2000 13:36:15 -0700 (PDT) Received:from fatcity.UUCP (uucp_at_localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id NAA84434; Mon, 1 May 2000 13:00:01 -0700 (PDT) Received:by fatcity.com (02-Mar-2000/v1.0f-b68/bab) via UUCP id 001550CF; Mon, 01 May 2000 12:00:49 -0800Message-ID:<F001.001550CF.20000501120049_at_fatcity.com> X-Comment:Oracle RDBMS Community Forum
I have a wierd problem to access the database today.
If I use the following
sqlplusw system/manager_at_orcl.world, it is ok to
connect to the database. But if I use
sqlplusw system/manager_at_orcl
I have the ORA-12154: TNS:could not resolve service
name error.
I can change the service name to whatever like orcl.c,
then I am still able to connect to the database by
using sqlplusw system/manager_at_orcl.c
I don't what's wrong with the service name. Any
advice? The tnsnames.ora is listed as the follwing(the
database is Oracle 8.1) :
ORCL.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
ticket.company.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
-- Author: Eric Fang INET: eric_fang_at_yahoo.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).Received on Mon May 01 2000 - 15:51:28 CDT
--=_ORCL_5932326_0r0--
------------------------------ From: Shawn Ferris <Shawn.Ferris_at_twtelecom.com> Date: Mon, 1 May 2000 14:58:33 -0600 Subject: RE: ORACLE 8.1.6 patch set come out Would setting compatible to 8.1.5 work? Shawn M Ferris Oracle DBA - Time Warner Telecom > -----Original Message----- > From: A. Bardeen [mailto:abardeen_at_hotmail.com] > Sent: Monday, May 01, 2000 3:39 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: ORACLE 8.1.6 patch set come out > > > It's been my experience that except for patches for specific > bugs, there > usually isn't a "deinstall" option for patchsets. Instead > you need to > reinstall the base release from the media and then apply any > intermediate > patches/patchsets to get back to the level you want. > > HTH, > > -- Anita > > >From: "Rachel Carmichael" <carmichr_at_hotmail.com> > >Reply-To: ORACLE-L_at_fatcity.com > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> > >Subject: Re: ORACLE 8.1.6 patch set come out > >Date: Mon, 01 May 2000 12:00:49 -0800 > > > >check with Support on how to go back, but yes, I heard about
 |
 |