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: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 27 Feb 2004 17:21:27 +0100
Message-ID: <c1nqn9$828$1@news2.tilbu1.nb.home.nl>


Bernd Maierhofer (dato) wrote:
> 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
>
>

Hold your horses! - this is BEQ, i.e. local. Your ORACLE_SID environment variable is not set!

Looking at the error about the error ( TNS-4294967Message -1 not found;   product=NETWORK; facility=TNS), I'd say your environment is not set at all (ORACLE_HOME is missing, too - for starters).

Take it from there

-- 

Regards,
Frank van Bortel
Received on Fri Feb 27 2004 - 10:21:27 CST

Original text of this message

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