Re: DESIGNER
Date: Thu, 20 Dec 2001 14:52:00 -0700
Message-ID: <u24nc7kqji0i68_at_corp.supernews.com>
Oracle-des_817_home|application Development|sql Plus connects (Version
8.1.7.0.0)
tnsnames.ora:
# C:\ORADESIGN\NET80\ADMIN\TNSNAMES.ORA Configuration
File:C:\oraDesign\net80\admin\tnsnames.ora
# Generated by Oracle Net8 Assistant
DEV =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXXXXXXXXXXXXX)(PORT = 1521))
(CONNECT_DATA = (SID = DEV))
)
EXAMPLE3.WORLD =
[continues with other examples][computer name replaced by XXXs]
SqlNet.log attached. I notice only 2 sets of entries while I have tried over a dozen times, both with a SID and without a SID. Always gives : ora-12154: TNS could not resolve service name RME-00220: Failed to connect to Repository
Note, the Sql Plus 8.0.6.0.0 within this same folder also doesn't connect.
"Frank van Bortel" <fbortel_at_home.nl> wrote in message
news:3C224709.5244F985_at_home.nl...
> SUSOTT_at_amnutrition.com wrote:
> >
> > I copied a known good tnsnames.ora file to dir and still am unable to
> > connect.
> > I looked at oracle homes in hklm, software and verified that the same
> > tnsnames.ora was in each home. no changes
> I was referring to tns_admin; it is not there by default.
>
> OK - debug mode:
> - what version SQL*Plus does connect?
> - post the tnsnames snippet
> - what's the error message/stack (see sqlnet.log in your Des working
> diry)
>
> --
> Gtrz,
>
> Frank van Bortel
begin 666 sqlnet.log
M#0H-"BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ
M*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ#0I&871A;"!.22!C;VYN
M96-T(&5R<F]R(#$R-3$T+"!C;VYN96-T:6YG('1O._at_T*("A$15-#4DE05$E/
M3CTH0T].3D5#5%]$051!/2A3240]*BDH4T525DE#15].04U%/5A86"Y86"Y8
M6%_at_N6%_at_I*$-)1#TH4%)/1U)!33U#.EQO<F%C;&5<;W)A.#%D97-<0DE.7&1E M<S)K-C$N97AE*2A(3U-4/5A86%A86%A86%A86%_at_I*%5315(];V5M*2DI*$%$ M1%)%4U,]*%!23U1/0T],/51#4"DH2$]35#U86%_at_N6%_at_N6%A8+EA8*2A03U)4M/3$U,C$I*2D-"_at_T*("!615)324].($E.1D]234%424].._at_T*"51.4R!F;W(@ M,S(M8FET(%=I;F1O=W,Z(%9E<G-I;VX_at_."XP+C8N,"XP("T_at_4')O9'5C=&EO M;_at_T*"5=I;F1O=W,_at_3E0@5$-0+TE0($Y4(%!R;W1O8V]L($%D87!T97(@9F]R M(#,R+6)I="!7:6YD;W=S.B!697)S:6]N(#_at_N,"XV+C N," M(%!R;V1U8W1I M;VX-"B _at_5&EM93H@,3<M1$5#+3 Q(#(S.C0U.C,W#0H@(%1R86-I;F<@;F]T M('1U<FYE9"!O;BX-"B _at_5&YS(&5R<F]R('-T<G5C=#H-"B @("!N<B!E<G(@ M8V]D93H_at_,3(R,#0-"B @("!43E,M,3(R,#0Z(%1.4SIR96-E:79E9"!D871A M(')E9G5S960_at_9G)O;2!A;B!A<'!L:6-A=&EO;@T*(" @(&YS(&UA:6X_at_97)R M(&-O9&4Z(#$R-38T#0H_at_(" @5$Y3+3$R-38T.B!43E,Z8V]N;F5C=&EO;B!R M969U<V5D#0H_at_(" @;G,@<V5C;VYD87)Y(&5R<B!C;V1E.B P#0H@(" @;G0@ M;6%I;B!E<G(_at_8V]D93H@, T*(" @(&YT('-E8V]N9&%R>2!E<G(@8V]D93H@ M, T*(" _at_(&YT($]3(&5R<B!C;V1E.B P#0H-"@T**BHJ*BHJ*BHJ*BHJ*BHJ M*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ M*BHJ*BHJ*BHJ*BH-"D9A=&%L($Y)(&-O;FYE8W0_at_97)R;W(@,3(U,30L(&-O M;FYE8W1I;F<_at_=&\Z#0H@*$1%4T-225!424]./2A#3TY.14-47T1!5$$]*%-) M1#TJ*2A315)624-%7TY!344]6%A8+EA8+EA86"Y86"DH0TE$/2A04D]'4D%- M/4,Z7&]R86-L95QO<F$X,61E<UQ"24Y<9&5S,FLV,2YE>&4I*$A/4U0]6%A8 M6%A86%A86%A86%_at_I*%5315(];V5M*2DI*$%$1%)%4U,]*%!23U1/0T],/51# M4"DH2$]35#TR,#DN-C,N,3$P+CDP*2A03U)4/3$U,C$I*2D-"_at_T*("!615)3 M24].($E.1D]234%424].._at_T*"51.4R!F;W(@,S(M8FET(%=I;F1O=W,Z(%9E M<G-I;VX_at_."XP+C8N,"XP("T_at_4')O9'5C=&EO;@T*"5=I;F1O=W,_at_3E0@5$-0 M+TE0($Y4(%!R;W1O8V]L($%D87!T97(_at_9F]R(#,R+6)I="!7:6YD;W=S.B!6 M97)S:6]N(#_at_N,"XV+C N," M(%!R;V1U8W1I;VX-"B @5&EM93H@,3_at_M1$5# M+3 Q(# T.C$U.C4W#0H_at_(%1R86-I;F<@;F]T('1U<FYE9"!O;BX-"B @5&YS M(&5R<F]R('-T<G5C=#H-"B _at_("!N<B!E<G(@8V]D93H@,3(R,#0-"B @("!4 M3E,M,3(R,#0Z(%1.4SIR96-E:79E9"!D871A(')E9G5S960_at_9G)O;2!A;B!A
M<'!L:6-A=&EO;_at_T*(" @(&YS(&UA:6X_at_97)R(&-O9&4Z(#$R-38T#0H@(" @
M5$Y3+3$R-38T.B!43E,Z8V]N;F5C=&EO;B!R969U<V5D#0H_at_(" @;G,@<V5C
M;VYD87)Y(&5R<B!C;V1E.B P#0H_at_(" @;G0@;6%I;B!E<G(@8V]D93H@, T*
M(" _at_(&YT('-E8V]N9&%R>2!E<G(@8V]D93H@, T*(" @(&YT($]3(&5R<B!C
(;V1E.B P#0H`
`
end Received on Thu Dec 20 2001 - 22:52:00 CET