Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

deconnection of the users at the end of 20 minutes of inactivity

dngaya
Advisor

deconnection of the users at the end of 20 minutes of inactivity

hello,
I have a database oracle 8i installed on HP 11. there are users who connect themselves on the database using a program installed on their station. At the end of nearly 20 minutes of inactivity, they receive a deconnection session.
I will like to know how to make to trace the log which will allow me of to verify that or is what there is a parameter which can allow me of to verify that.
here the contents of my file will sqlnet.ora:

trace_level_client = OFF

sqlnet.expire_time = 0

automatic_ipc = ON

#sqlnet.authentication_services = (NONE)


how to make for resoudre this problem.
thank you for your assistance.

7 REPLIES
Francisco Pardillo Mart
Occasional Contributor

Re: deconnection of the users at the end of 20 minutes of inactivity

Hello,

Did you activate the profile's?

I think this users have a profile with a "idle time" of 20 min.

Regards, Francisco.
Frank
Graham Cameron_1
Honored Contributor

Re: deconnection of the users at the end of 20 minutes of inactivity

Not sure if you're trying to understand what is disconnecting your sessions, or just to stop it.

Also not sure what program the users use on their station, and I assume this is a PC.

To get to the bottom of this, start with turning on Net8 logging on server and client. This is controlled by sqlnet.ora which is usually in $ORACLE_HOME/network/admin

Here are some parameters to try:

SERVER
======
LOG_DIRECTORY_SERVER=/path/to/logdir
LOG_FILE_SERVER=svr.log
TRACE_DIRECTORY_SERVER=/path/to/tracedir
TRACE_FILE_SERVER=svr.trc
TRACE_LEVEL_SERVER=admin
TRACE_TIMESTAMP_SERVER=true




CLIENT
======
LOG_DIRECTORY_CLIENT=\path\to\logdir
LOG_FILE_CLIENT=client.log
TRACE_DIRECTORY_CLIENT=\path\to\tracedir
TRACE_FILE_CLIENT=client.trc
TRACE_LEVEL_CLIENT=admin
TRACE_TIMESTAMP_CLIENT=true


There are 4 trace levels - off|user|admin|support

There a loads of other options, for example you can use a single trace file for all sessions, or a separate file per session. See
http://download-west.oracle.com/docs/cd/B10501_01/network.920/a96581/sqlnet.htm#496765

The above should get you started, please let us know how it goes.

-- Graham
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.
dngaya
Advisor

Re: deconnection of the users at the end of 20 minutes of inactivity

hello,
thank you for the responses above. I have just put the files of trace and of log on the sqlnet.ora file on stations but which is the difference between the option admin and to user when one uses parameter TRACE_LEVEL_CLIENT ?.
thank you of your assistance.
Jean-Luc Oudart
Honored Contributor

Re: deconnection of the users at the end of 20 minutes of inactivity

You need to check the users profile


CPU/Session: Total amount of CPU time allowed in a session. The limit is expressed in seconds.

CPU/Call : Maximum amount of CPU time allowed for a call (a parse, execute, or fetch). The limit is expressed in seconds.

Connect Time: Maximum elapsed time allowed for a session. The limit is expressed in minutes.

Idle Time: Maximum idle time allowed in a session. Idle time is a continuous period of inactive time during a session. Long-running queries and other operations are not subject to this limit. The limit is expressed in minutes.


Rgds,
Jean-Luc
fiat lux
dngaya
Advisor

Re: deconnection of the users at the end of 20 minutes of inactivity

ok,
I have one default profile in my database which here below script:
CREATE PROFILE DEFAULT
LIMIT SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL UNLIMITED
CONNECT_TIME UNLIMITED
IDLE_TIME UNLIMITED
LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED
COMPOSITE_LIMIT UNLIMITED
PRIVATE_SGA UNLIMITED;


Yogeeraj_1
Honored Contributor

Re: deconnection of the users at the end of 20 minutes of inactivity

hi,

See the output of:

select distinct profile, LIMIT
from dba_profiles
where resource_name='CONNECT_TIME'

then correlate it with the output of:

select username, profile
from dba_users
where profile ='&Profile_Name'

(You should input the profile name generated in the previous query)

You should be able to link these findings to the users who are getting disconnection problems....

regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
dngaya
Advisor

Re: deconnection of the users at the end of 20 minutes of inactivity

Hello,
by using the requests below, all the users of my base have profiles it DEFAULT. There never was creation of others profile other but DEFAULT.
Thank you for your assistance.