Printable View
Can you guys help me figure out what is wrong with my net config?
we can run query with small result set reruened against this table, but when we run the query with lots of data returned, we got 'the session has been killed' error. what am I looking for?
thanks,
cathy
Some information from u:
-- OS on clien and on server
-- type of network protocol
-- what application u are using
-- sqlnet.ora on server and client mashines
...
any addition datas may help to solve ur problem
Here are more detail:
-- OS on clien and on server
Window NT on both client and server
-- type of network protocol
TCP/IP
-- what application u are using
sqlplus
-- sqlnet.ora on server and client mashines
-- Client sqlnet.ora file as below:
# SQLNET.ORA Network Configuration File: d:\Oracle\Ora81\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = xxxx.xxxxxx.com
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)
-- server sqlnet.ora file as below:
AUTOMATIC_IPC = OFF
TRACE_LEVEL_CLIENT = OFF
names.directory_path = (TNSNAMES)
names.default_domain = world
name.default_zone = world
-- server listener.ora as follow
################
# Filename......: listener.ora
# Node..........: local.world
# Date..........: 24-MAY-95 13:23:20
################
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(COMMUNITY= TCP.world)
(PROTOCOL= TCP)
(Host= xx.xx.xx.xx)
(Port= 1521)
)
(ADDRESS=
(COMMUNITY= TCP.world)
(PROTOCOL= TCP)
(Host= xx.xx.xx.xx)
(Port= 1526)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ADMIN
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
)
(SID_DESC =
(SID_NAME = xxx)
)
(SID_DESC =
(SID_NAME = xxx)
)
(SID_DESC =
(SID_NAME = xxx)
)
)
PASSWORDS_LISTENER = (oracle)
thanks, cathy
Hi,
I presume you run your apps on the client side, can you try
running it on the server side if it will be killed also?
I'm just curious.
In first: I don't sure about this my answer.
Maybe problem in sqlnet parameter:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
U have to check period, how often NT server check
authentication datas on windows client. and which layer of
OSI model NT have to use for this procedure.
when u execute long query and use direct soket connection
to oracle database they will use 3 upper layes of OSI models
If NT authentication procedure use the same layes it may
create conflict situation and NT network software MAY (I DON'T SURE) close soket.
Try to exclude this parameter from sqlnet.ora file.