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 -> Re: Connection problem ORA 12535 TNS Timeout

Re: Connection problem ORA 12535 TNS Timeout

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 28 Feb 2004 16:20:23 +0800
Message-ID: <40404f47$0$28870$afc38c87@news.optusnet.com.au>


"Bernd Maierhofer (dato)" <bernd.maierhofer_at_dato.at> wrote in message news:nlG%b.97290$174.53470_at_news.chello.at...
> Hi,
>
> > > thanks for the detailed answer. We have had no trouble using 8.1.5 on
> Win2k,
> > > only since we tried to setup the server in the VMWare box.
> > Pretty big "only"!
> Well, we need this setup for development only, so IŽd really love to avoid
> messing up with existing installations.
>
> > >But I will pay
> > > attention to your advice using v9. Btw VMWare is v3.0.0
> > Well, that's a bit ancient as well. They're up to version 4:6030 these
> > days.
> Ok, upgraded to v4 6030
> I also updated my Oracle setup to v8.1.6, which is the last one I have
here.
>
> > > The listenr.ora on the server loks like this:
> > > # C:\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration
> > > File:C:\Oracle\Ora81\NETWORK\ADMIN\listener.ora
> > > # Generated by Oracle Net8 Assistant
> > >
> > > LISTENER =
> > > (DESCRIPTION =
> > > (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
> > > (PROTOCOL_STACK =
> > > (PRESENTATION = TTC)
> > > (SESSION = NS)
> >
> > I'm sure there's a reason for having the PROTOCOL_STACK section in
> > there, but for the life of me I can't think what it might be. Care to
> > enlighten me?
> >
> > If your file were to read simply:
> >
> > LISTENER =
> > (DESCRIPTION_LIST =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
> > )
> > )
> > )
> >
> > SID_LIST_LISTENER =
> > (SID_LIST =
> > (SID_DESC =
> > (GLOBAL_DBNAME = bf)
> > (ORACLE_HOME = C:\Oracle\Ora81)
> > (SID_NAME = bf)
> > )
> > )
> >
> > ...then what happens?
>
> Well, the same agin:

Well, we could micro-diagnose this till kingdom come, but since Oracle in Vmware on Windows works perfectly normally here, I can only conclude your installation is stuffed in some way. Yes, it's networking. And yes, if you fiddle around long enough with sqlnet.ora, listener.ora, and tnsnames.ora you might very well be able to sort it.

But it shouldn't be happening in the first place. And needn't with that particular configuration.

So I can only suggest you wipe that virtual machine, if it is disposable, and start again.

Sorry. [Oracle] Networking is not difficult to do, but once you stuff one bit of it up, I find it very hard to diagnose it clean again.

Regards
HJR
>
> SQLNET.LOG:
>
> ***********************************************************************
> Fatal NI connect error 12160, connecting to:
> (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
>
> VERSION INFORMATION:
> TNS for 32-bit Windows: Version 8.1.6.0.0 - Production
> Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version
8.1.6.0.0 -
> Production
> Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version
> 8.1.6.0.0 - Production
> Time: 27-FEB-2004 12:58:38
> Tracing to file: c:\server_504.trc
> Tns error struct:
> nr err code: 0
> ns main err code: -1
> TNS-4294967Message -1 not found; product=NETWORK; facility=TNS
>
> ns secondary err code: 0
> nt main err code: 0
> nt secondary err code: 0
> nt OS err code: 0
>
>
> Looking at trace file, I enabled, I found the following lines:
>
> nsbal: normal exit
> nsprecv: reading from transport...
> nttrd: entry
> ntt2err: entry
> ntt2err: soc 668 error - operation=5, ntresnt[0]=517, ntresnt[1]=54,
> ntresnt[2]=0
> ntt2err: exit
> nttrd: exit
> nsprecv: transport read error
> nsprecv: error exit
> nserror: entry
> nserror: nsres: id=1, op=68, ns=12547, ns2=12560; nt[0]=517, nt[1]=54,
> nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
> nscon: error exit
> nsdo: nsctxrnk=0
> nsdo: error exit
>
> soc 668 error looks as if there is a problem with network communication?
>
> Bernd
>
>
Received on Sat Feb 28 2004 - 02:20:23 CST

Original text of this message

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