Oracle-L: Re: question on multibyte character storage

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Tue, 14 Oct 2003 11:59:25 -0800
Message-ID: <F001.005D314C.20031014115925@fatcity.com>

would anyone care to take a whack at this?

thanks.

RDBMS Version:: 9.2.0.4
Operating System and Version:: MS W2K Advanced Server SP4 Error Number (if applicable)::
Server Net Version:: 9.2.0.4
Client Operating System and Version:: MS W2K Pro SP4 Client Net Version:: 9.2.0.4

sqlnet.expire_time support in 9.2 on NT (w2k)

sqlnet.expire_time is not working properly for me in 9.2.0.4.0 on w2k.

In a trace file (trace_level=16)
I am seeing the message:

nstimarmed: entry 
nstimarmed: no timer allocated 
nstimarmed: normal exit

I have read the following docs:

Note:151972.1 Dead Connection Detection (DCD) Explained 
Note:1018160.6 Common Questions About Dead Connection Detection (DCD) 
Note:1006809.6 DEAD CONNECTION DETECTION WON'T WORK

Oracle9i Net Services Reference Guide
Release 2 (9.2) Part Number A96581-02
http://download-west.oracle.com/docs/cd/B10501_01/network.920/a96581/sqlnet.htm#437587

and Jonathan Gennick's Oracle Net8 Troubleshooting Guide.

parameters:
sqlnet.expire_time = 10
in the file %ORACLE_HOME%\network\admin\sqlnet.ora

environment variable
tns_admin = 9.2 home\network\admin, as that was referenced in one of the above docs as a possible remedy.

the listener service has been cycled (since the file sqlnet.ora was changed).

This server does have 2 oracle homes (8.1.7.4.6 and 9.2.0.4.0). No Oracle TNS Listeners are in use that use the 8.1.7 home. The 9.2 Home is the default home.

when examining a connection from my workstation to the server, the timer functionality is not being used.

Is the use of sqlnet.expire_time supported on win32 (at all)?
If 1 is true, under what release/patch is it supported?
if 1 is false, has anyone had success with the following:

Use the standard TCP KeepAlive on Windows NT/2000:
- Open the registry under:

HKEY_LOCAL_MACHINE: SYSTEM: CurrentControlSet: Services: Tcpip: Parameters
- Add KeepAliveTime : REG_DWORD to the registry

Set the value to a reasonable timeout.(decimal and NOT Hex) Eg: (120000 = 2 minutes)
Save this
Reboot

and what are the downsides of such a workaround?

MTS / shared_server is not an option, as this is a client/server app that can move large volumes of data.

sqlnet.expire_timeout was supposed to be supported on 9.0.1 on win32.

thanks,

Paul

Do you Yahoo!?
The New Yahoo! Shopping - with improved product search

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Drake
  INET: discgolfdba_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Oct 14 2003 - 14:59:25 CDT