Re: Connection problem ORA 12535 TNS Timeout

From: Bernd Maierhofer \(dato\) <bernd.maierhofer_at_dato.at>
Date: Fri, 27 Feb 2004 12:02:27 GMT
Message-ID: <nlG%b.97290$174.53470@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:

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 Fri Feb 27 2004 - 06:02:27 CST