Connection problem ORA 12535 TNS Timeout

Bernd Maierhofer (dato)

unread,

Feb 25, 2004, 12:46:58 PM2/25/04

to

Hi and thanks for reading. My configuration is as follows:

Oracle 8.i 8.1.5 Client and Server
Server installed in a Win2K Professional VMWare Box, a database is up and
running, connecting locally (loopback) works ok
Client is installed on a Win2k machine

TNSPing can reach the database, times are about 9000 msec, sometimes 3000
msec

Connecting from the client fails, the sql.log on the server says:
Fatal NI connect error 12160, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.1.5.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.5.0.0 -
Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version
8.1.5.0.0 - Production
Time: 25-FEB-04 18:35:04
Tracing not turned on.
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

The listener says:
Listen auf:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle)(PORT=1521))(PROTOCOL_STACK
=(PRESENTATION=TTC)(SESSION=NS)))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
25-FEB-04 18:03:51 * service_register * BF * 0
25-FEB-04 18:03:51 * service_register * BF * 0
25-FEB-04 18:05:11 *
(CONNECT_DATA=(SERVICE_NAME=bf)(INSTANCE_NAME=bf)(CID=(PROGRAM=C:\Oracle\Ora
81\BIN\SQLPLUS.EXE)(HOST=ORTLER)(USER=b.maierhofer))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.31)(PORT=3340)) * establish * bf * 0
25-FEB-04 18:09:01 * ping * 0
25-FEB-04 18:11:05 *
(CONNECT_DATA=(SERVICE_NAME=bf)(INSTANCE_NAME=bf)(CID=(PROGRAM=C:\Oracle\Ora
81\BIN\SQLPLUSW.EXE)(HOST=ORTLER)(USER=b.maierhofer))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.31)(PORT=3350)) * establish * bf * 0
25-FEB-04 18:13:54 * bf *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.31)(PORT=3350)) * service_update * BF
* 0
25-FEB-04 18:13:54 * bf *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.31)(PORT=3350)) * service_update * BF
* 0
25-FEB-04 18:15:36 *
(CONNECT_DATA=(SERVICE_NAME=bf)(INSTANCE_NAME=bf)(CID=(PROGRAM=C:\Oracle\Ora
81\BIN\SQLPLUSW.EXE)(HOST=ORTLER)(USER=b.maierhofer))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.31)(PORT=3356)) * establish * bf * 0
25-FEB-04 18:23:51 * bf *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.31)(PORT=3356)) * service_update * BF
* 0
25-FEB-04 18:23:51 * bf *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.31)(PORT=3356)) * service_update * BF
* 0
25-FEB-04 18:24:04 *
(CONNECT_DATA=(SERVICE_NAME=bf)(INSTANCE_NAME=bf)(GLOBAL_NAME=bf)(CID=(PROGR
AM=C:\Programme\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=ORACLE)(USER=Administrat
or))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.19)(PORT=1221)) * establish *
bf * 0
25-FEB-04 18:24:34 *
(CONNECT_DATA=(SERVICE_NAME=bf)(INSTANCE_NAME=bf)(CID=(PROGRAM=C:\Oracle\Ora
81\BIN\SQLPLUSW.EXE)(HOST=ORTLER)(USER=b.maierhofer))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.31)(PORT=3369)) * establish * bf * 0

I already tried to increase the connection_timeout, but this does not help.

Thanks for any idea.
Bernd

Daniel Morgan

unread,

Feb 25, 2004, 6:27:45 PM2/25/04

to

Bernd Maierhofer (dato) wrote:

Looks like a network configuration issue to me. What is the ping (not
tnsping) time?

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damo...@x.washington.edu
(replace 'x' with a 'u' to reply)

Howard J. Rogers

unread,

Feb 25, 2004, 6:51:08 PM2/25/04

to

"Bernd Maierhofer $dato$" <bernd.ma...@dato.at> wrote in message news:<mc5%b.76818$174....@news.chello.at>...

> Hi and thanks for reading. My configuration is as follows:
>
> Oracle 8.i 8.1.5 Client and Server
> Server installed in a Win2K Professional VMWare Box, a database is up and
> running, connecting locally (loopback) works ok
> Client is installed on a Win2k machine

The version of VMware might have helped, too. But my initial
observation is that 8.1.5 was never certified for Windows 2000 (from
memory, 8.1.6 was the first version that was). So you can expect
fireworks.

> TNSPing can reach the database, times are about 9000 msec, sometimes 3000
> msec

TNSPing tells you you can reach the *listener*, not the database.
Which means your client tnsnames must be resolving aliases correctly,
but your listener hasn't a clue how to forward the request on to an
instance.

And whilst the log is interesting, I can't comment further about why
the Listener is having trouble dealing with the connection request
unless you post the listener.ora.

I will say, however, that tahiti.oracle.com describes error 12160 as
follows:

TNS-12160 TNS:internal error: Bad error number

Cause: Corrupt error reporting subsystem. This message is not normally
visible to the user.

Action: For further details, turn on tracing and re-execute the
operation. If the error persists, contact Oracle Customer Support.

And the fact that something is reported as "corrupted" means this is
the sort of fireworks you get by running an antiquated and buggy
Oracle version on a non-certified Operating System inside a
non-certified virtual machine configuration.

I'd try 9i Release 2 if I were you, since I know that works perfectly
well inside Vmware.

Regards
HJR

Bernd Maierhofer (dato)

unread,

Feb 26, 2004, 6:43:46 AM2/26/04

to

>
> Looks like a network configuration issue to me. What is the ping (not
> tnsping) time?

It is <10ms, so I assumed no problem here.

Bernd

Bernd Maierhofer (dato)

unread,

Feb 26, 2004, 6:46:21 AM2/26/04

to

Howard,
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. But I will pay
attention to your advice using v9. Btw VMWare is v3.0.0

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)
)
)

CONNECT_TIMEOUT_LISTENER = 60

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = bf)
(ORACLE_HOME = C:\Oracle\Ora81)
(SID_NAME = bf)
)
)

LOGGING_LISTENER = OFF

Thank you,

Bernd

"Howard J. Rogers" <h...@dizwell.com> schrieb im Newsbeitrag
news:14a1f766.0402...@posting.google.com...

Howard J. Rogers

unread,

Feb 26, 2004, 12:32:01 PM2/26/04

to

"Bernd Maierhofer $dato$" <bernd.ma...@dato.at> wrote in message news:<h0l%b.84079$174....@news.chello.at>...

> Howard,
> thanks for the detailed answer. We have had no trouble using 8.1.5 on Win2k,

Yeah, I know. I had no trouble either. But it still isn't supported,
and you can (and will) run into issues.

> only since we tried to setup the server in the VMWare box.

Pretty big "only"!

>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.

> 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?

Regards
HJR

Bernd Maierhofer (dato)

unread,

Feb 27, 2004, 7:02:27 AM2/27/04

to

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悲 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.

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

Frank van Bortel

unread,

Feb 27, 2004, 11:21:27 AM2/27/04

to

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

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

Howard J. Rogers

unread,

Feb 28, 2004, 3:20:23 AM2/28/04

to

"Bernd Maierhofer (dato)" <bernd.ma...@dato.at> wrote in message
news:nlG%b.97290$174....@news.chello.at...

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

Bernd Maierhofer (dato)

unread,

Mar 1, 2004, 6:56:06 AM3/1/04

to

> 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.

Yes, this is one thing, I am going to do - restart the whole thing.

Thanks,
Bernd

Bernd Maierhofer (dato)

unread,

Mar 1, 2004, 7:02:13 AM3/1/04

to

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

Yes, this is strange. Happy, you saw it too. But shouldn´t the env set
automatically by the Network wizard?

> 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).

Silly question: How do I set these env variables? What format must they
conform to?

Bernd

Frank van Bortel

unread,

Mar 1, 2004, 3:34:33 PM3/1/04

to

Should be in the registry.

The client should do (this is from the CLI):

sqlplus system/manager@myserver

Your client should have a tnsnames.ora file (default location
is %OH%\network\admin), with the entry:

MYSERVER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.200)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
)
)

Of course, your HOST = entry, and SID = would be different in your case.

Let's take it from there.

BTW - you run Win2k + VMWare + Win2K Pro just to test a server?

Bernd Maierhofer (dato)

unread,

Mar 2, 2004, 3:42:37 AM3/2/04

to

On my client I have

BF1.DATO.LOCALHOST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = bf1)
)
)

The error with BEQ was logged at the server愀, so I think there is something
wrong with the server愀 protocol?

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

> The client should do (this is from the CLI):

>
> sqlplus system/manager@myserver
>
> Your client should have a tnsnames.ora file (default location
> is %OH%\network\admin), with the entry:
>
> MYSERVER =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.200)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = orcl)
> )
> )
>
> Of course, your HOST = entry, and SID = would be different in your case.
>
> Let's take it from there.
>
> BTW - you run Win2k + VMWare + Win2K Pro just to test a server?

We have VMWare boxes for the various DBServers/Configurations we need for
development.

brgds
Bernd

Frank van Bortel

unread,

Mar 2, 2004, 3:45:37 PM3/2/04

to

Bernd Maierhofer (dato) wrote:

Well, I may be completely on the wrong track here.
Let's summarize what I understood from your posts
about your environment:
- You have a big machine, running Win2k.
- On that machine, you have:
-- Oracle 8iRel1 client
-- VMWare.
The VMWare virtual machine runs
---- Win2K Pro,
---- Oracle RDBMS.

Or, perhaps there's two machines. It does not matter
for the scenario: you have a client, and a remote server.

Let's take a look at your tnsnames.ora:

>BF1.DATO.LOCALHOST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = bf1)
> )
> )

1) your remote machine (the server) is called "oracle"; you
can ping oracle.
2a) your sqlnet.ora file (sits next to tnsnames.ora) contains
an entry default_domain = DATO.LOCALHOST, or:
2b) You type @bf1.dato.localhost fully (instead of @bf1).
3) On your server "oracle", you installed 8.1.5 RDBMS, with a SID
called bf1. You did not give any domain to the database.
4) Ergo, you listener.ora on the server must be:
# LISTENER.ORA Network Configuration File:
D:\oracle\9iAS\network\ADMIN\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
)

)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =

(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora815)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = bf1)
)
)

Can you verify this, and post listener.ora?

Also, tnsping's of 3 to 9 seconds are way too long!
600mSec to 1 sec on a WAN, 500msec or less on a LAN.
I got 50msec on my (tiny) LAN, <10msec local, using tcp/ip.

Bernd Maierhofer (dato)

unread,

Mar 3, 2004, 7:02:45 AM3/3/04

to

> 1) your remote machine (the server) is called "oracle"; you
> can ping oracle.

As I did a new setup, the machine is now calles oracleserver, but yes, I can
ping it.

> 2a) your sqlnet.ora file (sits next to tnsnames.ora) contains
> an entry default_domain = DATO.LOCALHOST, or:

SQLNET.ORA on the remote machine:
# SQLNET.ORA Network Configuration File:
C:\Oracle\Ora81\NETWORK\ADMIN\sqlnet.ora