- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- deconnection of the users at the end of 20 minutes...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-25-2003 08:25 PM
тАО11-25-2003 08:25 PM
deconnection of the users at the end of 20 minutes of inactivity
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2003 06:57 PM
тАО11-26-2003 06:57 PM
Re: deconnection of the users at the end of 20 minutes of inactivity
Did you activate the profile's?
I think this users have a profile with a "idle time" of 20 min.
Regards, Francisco.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2003 09:16 PM
тАО11-26-2003 09:16 PM
Re: deconnection of the users at the end of 20 minutes of inactivity
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-27-2003 01:10 AM
тАО11-27-2003 01:10 AM
Re: deconnection of the users at the end of 20 minutes of inactivity
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-27-2003 01:30 AM
тАО11-27-2003 01:30 AM
Re: deconnection of the users at the end of 20 minutes of inactivity
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-27-2003 01:43 AM
тАО11-27-2003 01:43 AM
Re: deconnection of the users at the end of 20 minutes of inactivity
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-28-2003 03:43 PM
тАО11-28-2003 03:43 PM
Re: deconnection of the users at the end of 20 minutes of inactivity
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-30-2003 07:56 PM
тАО11-30-2003 07:56 PM
Re: deconnection of the users at the end of 20 minutes of inactivity
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.