Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA 12545: TNS lookup failure

ORA 12545: TNS lookup failure

From: Sean Zhang <sean_at_cnfei.com>
Date: Fri, 07 May 1999 22:42:00 GMT
Message-ID: <Y_JY2.3295$p17.11078999@firenze.visi.net> 





Dear Friends,



I got a big problems with Oracle Network, Please  give me some guidance.



Enviroments:  Oracle Server 8i (EE) 8.1.5 in Sun E3000 with solaris 2.6.

                         Clients: PC windows 95 with Developer 2000 version
2.0
                         and Sql*Net 2.3.4





I have followed all the guidelines  in Oracle Docs and  configured
the follwing files:

         listener.ora  in /var/opt/oracle    ( see attached files).
         tnsnames.ora and sqlnet.ora  in C:\orawin95\network\admin ( Please


see attached files).



The listener is  working and Developer 2k programs also works, but ONLY in
the main building (  the LAN where the Oracle server resides). When I move a
PC


from the main building to another building ( WAN ) , I can't logon on to
Oracle, and always get the same message " Oracle error 12545: TNS lookup
failure".



My diagnosis went like this:


1.    I can ftp, telnet to the Oracle server machine, meaning I have
successfully


       disabled the Firewall to the remote site. ( I simply make the remote
address a TRUSTED


        Site).


2,   MS-DOS: c:\windows>  tnsping cnf


        got messages  "  attempting connect to
(address=(protocol=tcp)(host=209.96.203.5)(port=1522))

        OK (610 msec).
       this  should mean  configuration files are fine.


 3.  But whe I tried  to connect the server via Sql*PLus 3.3 Or Developer
2K, I got the


       error message " TNS lookup failure".
 4. Before I upgraded to Oracle 8i, I used Oracle 8.0.4 and the remote PC


     can log to Oracle with the same configuarion files( tnsnames.ora,
sqlnet.ora ) fine.


     ( Note the listener.ora on server is a little different in Oracle 8I).
5.  When I turned on the trace in Windows95, I got the following files
(PLease see attachment):


     sqlnet.trc , sqlnet.log




 Any suggestions and advices are greatly appreciated.   Thank you in
advance.




Sean Zhang


mailto:sean_at_cnfei.com







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;"!/4TX_at_8V]N

M;F5C="!E<G)O<B Q,C4T-2P_at_8V]N;F5C=&EN9R!T;SH-"B H1$530U))4%1)

M3TX]*$%$1%)%4U,]*%!23U1/0T],/51#4"DH2$]35#TR,#DN.38N,C S+C4I
M*%!/4E0],34R,BDI*$-/3DY%0U1?1$%403TH4TE$/6-N9BDH1TQ/0D%,7TY!
M344]8VYF+G=O<FQD*2A#240]*%!23T=204T]1C4P4E5.,S(N15A%*2A(3U-4


M/4Q32"DH55-%4CU/<F%5<V5R*2DI*0T*#0H@(%9%4E-)3TX_at_24Y&3U)-051)
M3TXZ#0H)5$Y3(&9O<B S,BUB:70_at_5VEN9&]W<SH_at_5F5R<VEO;B R+C,N-"XP
M+C @+2!0<F]D=6-T:6]N#0H)5VEN9&]W<R!.5"!40U O25 @3E0_at_4')O=&]C
M;VP_at_061A<'1E<B!F;W(@,S(M8FET(%=I;F1O=W,Z(%9E<G-I;VX@,BXS+C0N
M,"XP("T_at_4')O9'5C=&EO;@T*("!4:6UE.B P-RU-05DM.3D@,38Z,S(Z,C -

M"B @5')A8VEN9R!T;R!F:6QE.B!#.EQ/4D%724XY-5Q"24Y<<W%L;F5T+G1R
M8PT*("!4;G,@97)R;W(@<W1R=6-T.@T*(" @(&YR(&5R<B!C;V1E.B Q,C(P
M-_at_T*(" @(%1.4RTQ,C(P-CH_at_5$Y3.G)E8V5I=F5D(&$@5$Y3(&5R<F]R(&1U
M<FEN9R!N879I9V%T:6]N#0H@(" @;G,@;6%I;B!E<G(@8V]D93H@,3(U-#4-


M"B @("!43E,M,3(U-#4Z($-O;FYE8W0_at_9F%I;&5D(&)E8V%U<V4@=&%R9V5T

M(&AO<W0@;W(@;V)J96-T(&1O97,@;F]T(&5X:7-T#0H@(" @;G,@<V5C;VYD
M87)Y(&5R<B!C;V1E.B Q,C4V, T*(" @(&YT(&UA:6X_at_97)R(&-O9&4Z(#4Q
M-0T*(" @(%1.4RTP,#4Q-3H_at_0V]N;F5C="!F86EL960_at_8F5C875S92!T87)G


M970@:&]S="!O<B!O8FIE8W0_at_9&]E<R!N;W0_at_97AI<W0-"B @("!N="!S96-O
M;F1A<GD_at_97)R(&-O9&4Z("TQ,# P, T*(" @(&YT($]3(&5R<B!C;V1E.B P
M#0H-"@T**BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ

M*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BH-"D9A=&%L($]33B!C


M;VYN96-T(&5R<F]R(#$R-30W+"!C;VYN96-T:6YG('1O._at_T*("A$15-#4DE0
M5$E/3CTH041$4D534U],25-4/2A!1$1215-3/2A04D]43T-/3#U"15$I*%!2
M3T=204T];W)A8VQE.# I*$%21U8P/6]R86-L93_at_P3U)#3"DH05)'4STG*$1%


M4T-225!424]./2A,3T-!3#U915,I*$%$1%)%4U,]*%!23U1/0T],/6)E<2DI
M*2<I*2DH0T].3D5#5%]$051!/2A3240]3U)#3"DH0TE$/2A04D]'4D%-/48U
M,%)53C,R+D5812DH2$]35#U,4T_at_I*%5315(]3W)A57-E<BDI*2D-"@T*("!6
M15)324].($E.1D]234%424].._at_T*"51.4R!F;W(@,S(M8FET(%=I;F1O=W,Z

M(%9E<G-I;VX@,BXS+C0N,"XP("T_at_4')O9'5C=&EO;@T*"4]R86-L92!"97%U
M96%T:"!.5"!0<F]T;V-O;"!!9&%P=&5R(&9O<B S,BUB:70_at_5VEN9&]W<SH@
M5F5R<VEO;B R+C,N-"XP+C @+2!0<F]D=6-T:6]N#0H@(%1I;64Z(# W+4U!
M62TY.2 Q-CHS,CHR, T*("!4<F%C:6YG('1O(&9I;&4Z($,Z7$]205=)3CDU

M7$))3EQS<6QN970N=')C#0H@(%1N<R!E<G)O<B!S=')U8W0Z#0H@(" @;G(@
M97)R(&-O9&4Z(#$R,C V#0H@(" @5$Y3+3$R,C V.B!43E,Z<F5C96EV960@
M82!43E,@97)R;W(@9'5R:6YG(&YA=FEG871I;VX-"B @("!N<R!M86EN(&5R
M<B!C;V1E.B Q,C4T-PT*(" @(%1.4RTQ,C4T-SH_at_5$Y3.FQO<W0_at_8V]N=&%C
M= T*(" @(&YS('-E8V]N9&%R>2!E<G(@8V]D93H@,3(U-C -"B @("!N="!M


M86EN(&5R<B!C;V1E.B U,3<-"B @("!43E,M,# U,3<Z($QO<W0_at_8V]N=&%C
M= T*(" @(&YT('-E8V]N9&%R>2!E<G(@8V]D93H@, T*(" @(&YT($]3(&5R
+<B!C;V1E.B P#0H`


`




end



begin 666 sqlnet.trc


M#0HM+2T_at_5%)!0T4_at_0T].1DE'55)!5$E/3B!)3D9/4DU!5$E/3B!&3TQ,3U=3
M("TM+0T*3F5W('1R86-E('-T<F5A;2!I<R B0SI<3U)!5TE..35<0DE.7'-Q

M;&YE="YT<F,B#0I.97<@=')A8V4@;&5V96P@:7,@- T*+2TM(%1204-%($-/
M3D9)1U52051)3TX_at_24Y&3U)-051)3TX_at_14Y$4R M+2T-"@T*+2TM(%!!4D%-
M151%4B!33U520T4_at_24Y&3U)-051)3TX_at_1D],3$]74R M+2T-"D%T=&5M<'1E


M9"!L;V%D(&]F('-Y<W1E;2!P9FEL92!S;W5R8V4_at_0SI<3U)!5TE..35<;F5T
M=V]R:UQA9&UI;EQS<6QN970N;W)A#0I087)A;65T97(@<V]U<F-E(&QO861E

M9"!S=6-C97-S9G5L;'D-"@T*071T96UP=&5D(&QO860@;V8@;&]C86P@<&9I
M;&4@<V]U<F-E($,Z7$]205=)3CDU7$))3EQS<6QN970N;W)A#0I087)A;65T
M97(@<V]U<F-E('=A<R!N;W0@;&]A9&5D#0H-"B M/B!005)!345415(@5$%"


M3$4_at_3$]!1"!215-53%13($9/3$Q/5R \+0T*4W5C8V5S<V9U;"!P87)A;65T
M97(@=&%B;&4@;&]A9 T*("T^(%!!4D%-151%4B!404),12!(05,@5$A%($9/

M3$Q/5TE.1R!#3TY414Y44R \+0T*("!!551/34%424-?25!#(#T_at_3T9&#0H@
M(%1204-%7TQ%5D5,7T-,245.5" ](#0-"B @;F%M92YD969A=6QT7WIO;F4@
M/2!W;W)L9 T*("!N86UE<RYD969A=6QT7V1O;6%I;B ]('=O<FQD#0H@(&YA


M;65S+F1I<F5C=&]R>5]P871H(#T@*%1.4TY!3453*0T*+2TM(%!!4D%-151%
M4B!33U520T4_at_24Y&3U)-051)3TX_at_14Y$4R M+2T-"@T*+2TM($Q/1R!#3TY&

M24=54D%424].($E.1D]234%424].($9/3$Q/5U,@+2TM#0I,;V<@<W1R96%M
M('=I;&P_at_8F4@(D,Z7$]205=)3CDU7$))3EQS<6QN970N;&]G(@T*3&]G('-T
M<F5A;2!V86QI9&%T:6]N(&YO="!R97%U97-T960-"BTM+2!,3T<@0T].1DE'


M55)!5$E/3B!)3D9/4DU!5$E/3B!%3D13("TM+0T*#0I5;F%B;&4@=&\@9V5T
M(&1A=&$@9G)O;2!N879I9V%T:6]N(&9I;&4@=&YS;F%V+F]R80T*3F]T('1R
M>6EN9R!T;R!E;F%B;&4_at_9&5A9"!C;VYN96-T:6]N(&1E=&5C=&EO;BX-"D-A

M;&QI;F<@861D<F5S<SH@*$1%4T-225!424]./2A!1$1215-37TQ)4U0]*$%$
M1%)%4U,]*%!23U1/0T],/4)%42DH4%)/1U)!33UO<F%C;&4X,"DH05)'5C ]
M;W)A8VQE.#!/4D-,*2A!4D=3/2<H1$530U))4%1)3TX]*$Q/0T%,/5E%4RDH
M041$4D534STH4%)/5$]#3TP]8F5Q*2DI)RDI*2A#3TY.14-47T1!5$$]*%-)

M1#U/4D-,*2A#240]*%!23T=204T]1C4P4E5.,S(N15A%*2A(3U-4/4Q32"DH
M55-%4CU/<F%5<V5R*2DI*0T*1V5T=&EN9R!L;V-A;"!C;VUM=6YI='D@:6YF
M;W)M871I;VX-"DQO;VMI;F<@9F]R(&QO8V%L(&%D9')E<W-E<R!S971U<"!B
M>2!N<FEG;&$-"DYO(&%D9')E<W-E<R!I;B!T:&4@<')E9F5R<F5D(&%D9')E
M<W,@;&ES= T*5$Y33D%6+D]202!I<R!N;W0@<')E<V5N="X_at_3F\@;&]C86P@

M8V]M;75N:71I97,@96YT<GDN#0I'971T:6YG(&QO8V%L(&%D9')E<W,@:6YF
M;W)M871I;VX-"D%D9')E<W,@;&ES="!B96EN9R!P<F]C97-S960N+BX-"DYO
M(&-O;6UU;FET>2!I;F9O<FUA=&EO;B!S;R!A;&P_at_861D<F5S<V5S(&%R92 B
M;&]C86PB#0I297-O;'9I;F<@861D<F5S<R!T;R!U<V4@=&\@8V%L;"!D97-T


M:6YA=&EO;B!O<B!N97AT(&AO< T*4')O8V5S<VEN9R!A9&1R97-S(&QI<W0N
M+BX-"DYO(&-O;6UU;FET>2!E;G1R:65S('-O(&ET97)A=&4@;W9E<B!A9&1R

M97-S(&QI<W0-"E1H:7,@:7,@82!L;V-A;"!C;VUM=6YI='D_at_86-C97-S#0I'
M;W0@<F]U=&%B;&4_at_861D<F5S<R!I;F9O<FUA=&EO;@T*36%K:6YG(&-A;&P@
M=VET:"!F;VQL;W=I;F<@861D<F5S<R!I;F9O<FUA=&EO;CH@*$1%4T-225!4


M24]./2A#3TY.14-47T1!5$$]*%-)1#U/4D-,*2A#240]*%!23T=204T]1C4P
M4E5.,S(N15A%*2A(3U-4/4Q32"DH55-%4CU/<F%5<V5R*2DI*$%$1%)%4U,]
M*%!23U1/0T],/4)%42DH4%)/1U)!33UO<F%C;&4X,"DH05)'5C ];W)A8VQE
M.#!/4D-,*2A!4D=3/2<H1$530U))4%1)3TX]*$Q/0T%,/5E%4RDH041$4D53
M4STH4%)/5$]#3TP]8F5Q*2DI)RDI*0T*0V%L;&EN9R!W:71H(&]U=&=O:6YG

M(&-O;FYE8W0_at_9&%T82 H1$530U))4%1)3TX]*$%$1%)%4U-?3$E35#TH041$

M4D534STH4%)/5$]#3TP]0D51*2A04D]'4D%-/6]R86-L93_at_P*2A!4D=6,#UO

M<F%C;&4X,$]20TPI*$%21U,])RA$15-#4DE05$E/3CTH3$]#04P]6453*2A!
M1$1215-3/2A04D]43T-/3#UB97$I*2DG*2DI*$-/3DY%0U1?1$%403TH4TE$
M/4]20TPI*$-)1#TH4%)/1U)!33U&-3!254XS,BY%6$4I*$A/4U0]3%-(*2A5

M4T52/4]R855S97(I*2DI#0IC;VYN96-T:6YG+BXN#0HH1$530U))4%1)3TX]

M*$-/3DY%0U1?1$%403TH4TE$/4]20TPI*$-)1#TH4%)/1U)!33U&-3!254XS

M,BY%6$4I*$A/4U0]3%-(*2A54T52/4]R855S97(I*2DH041$4D534STH4%)/

M5$]#3TP]0D51*2A04D]'4D%-/6]R86-L93_at_P*2A!4D=6,#UO<F%C;&4X,$]2
M0TPI*$%21U,])RA$15-#4DE05$E/3CTH3$]#04P]6453*2A!1$1215-3/2A0

M4D]43T-/3#UB97$I*2DG*2DI#0IO<&5N:6YG('1R86YS<&]R="XN+@T*+3Q%
M4E)/4CXM(&YS<F5S.B!I9#TP+"!O<#TV-2P@;G,],3(U-#<L(&YS,CTQ,C4V

M,#L@;G1;,%T]-3$W+"!N=%LQ73TP+"!N=%LR73TP#0HM/$524D]2/BT@=6YA
M8FQE('1O(&]P96X@=')A;G-P;W)T#0I#86QL(&9A:6QE9"XN+@T*17AI=&EN
M9R!.4DE#04Q,('=I=&@@9F]L;&]W:6YG('1E<FUI;F%T:6]N(')E<W5L=" M


M,0T*+3Q%4E)/4CXM("!E<G)O<B!F<F]M(&YR:6-A;&P-"BT\15)23U(^+2 @
M("!N<B!E<G(@8V]D93H@,3(R,#8-"BT\15)23U(^+2 @("!N<R!M86EN(&5R
M<B!C;V1E.B Q,C4T-PT*+3Q%4E)/4CXM(" @(&YS("@R*2 @97)R(&-O9&4Z

M(#$R-38P#0HM/$524D]2/BT@(" @;G0@;6%I;B!E<G(@8V]D93H_at_-3$W#0HM
M/$524D]2/BT@(" @;G0@*#(I("!E<G(@8V]D93H@, T*+3Q%4E)/4CXM(" @
M(&YT($]3(" @97)R(&-O9&4Z(# -"BT\15)23U(^+2!#;W5L9&XG="!C;VYN


696-T+"!R971U<FYI;F<@,3(U-#<-"@``


`




end



begin 666 listener.ora


M(R!,25-414Y%4BY/4D$@0V]N9FEG=7)A=&EO;B!&:6QE.B]A<' O;W)A8VQE
M+W!R;V1U8W0O."XQ+C4O;F5T=V]R:R]A9&UI;B]L:7-T96YE<BYO<F$-"B,@
M1V5N97)A=&5D(&)Y($]R86-L92!.970X($%S<VES=&%N= T*#0I,25-414Y%

M4B ]#0H@("A$15-#4DE05$E/3E],25-4(#T-"B @(" H1$530U))4%1)3TX@
M/0T*(" @(" @*$%$1%)%4U,@/2 H4%)/5$]#3TP@/2!)4$,I*$M%62 ](&-N
M9BDI#0H@(" @(" H4%)/5$]#3TQ?4U1!0TL@/0T*(" @(" @(" H4%)%4T5.
M5$%424].(#T_at_5%1#*0T*(" @(" @(" H4T534TE/3B ]($Y3*0T*(" @(" @
M*0T*(" @("D-"B @(" H1$530U))4%1)3TX@/0T*(" @(" @*$%$1%)%4U,@
M/2 H4%)/5$]#3TP@/2!40U I*$A/4U0@/2 R,#DN.38N,C S+C4I*%!/4E0@
M/2 Q-3(R*2D-"B @(" @("A04D]43T-/3%]35$%#2R ]#0H@(" @(" @("A0


M4D5314Y4051)3TX@/2!45$,I#0H@(" @(" @("A315-324].(#T_at_3E,I#0H@

M(" @(" I#0H@(" @*0T*(" @*0T*#0I3241?3$E35%],25-414Y%4B ]#0H@
M("A3241?3$E35" ]#0H@(" @*%-)1%]$15-#(#T-"B @(" @("A'3$]"04Q?
M1$).04U%(#T_at_8VYF+G=O<FQD*0T*(" @(" @*$]204-,15](3TU%(#T@+V%P


M<"]O<F%C;&4O<')O9'5C="\X+C$N-2D-"B @(" @("A3241?3D%-12 ](&-N
@9BD-"B @(" I#0H@("D-"@T*#0H-"@T*#0H-"@T*#0H`


`




end



begin 666 tnsnames.ora


M(R!#.EQ/4D%724XY-5Q.150X,%Q!1$U)3EQ43E-.04U%4RY/4D$@0V]N9FEG

M=7)A=&EO;B!&:6QE.D,Z7$]205=)3CDU7&YE=#@P7&%D;6EN7'1N<VYA;65S
M+F]R80T*(R!'96YE<F%T960_at_8GD@3W)A8VQE($YE=#@@07-S:7-T86YT#0H-
M"D-.1BY73U),1" ]#0H@("A$15-#4DE05$E/3B ]#0H@(" @*$%$1%)%4U,@
M/2 H4%)/5$]#3TP@/2!40U I*$A/4U0@/2 R,#DN.38N,C S+C4I*%!/4E0@
M/2 Q-3(R*2D-"B @(" H0T].3D5#5%]$051!(#T@*%-)1" ](&-N9BDH1TQ/

E0D%,7TY!344@/2!C;F8N=V]R;&0I*0T*(" I#0H-"@T*#0H-"@``


`




end



begin 666 Sqlnet.ora


M05543TU!5$E#7TE00R ]($]&1_at_T*5%)!0T5?3$5614Q?0TQ)14Y4(#T_at_3T9&

M#0IN86UE<RYD:7)E8W1O<GE?<&%T:" ]("A43E-.04U%4RD-"FYA;65S+F1E
M9F%U;'1?9&]M86EN(#T@=V]R;&0-"FYA;64N9&5F875L=%]Z;VYE(#T@=V]R
@;&0-"FYA;65S+F1E9F%U;'1?9&]M86EN/7=O<FQD#0H`




`




end

Received on Fri May 07 1999 - 17:42:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US