Page 1 of 2 12 LastLast
Results 1 to 15 of 17

Thread: Login Time out

  1. #1
    Join Date
    Jul 2004
    Posts
    102

    Unanswered: Login Time out

    Hi all,

    Is there any option to kick out users after a certain time of idle.

    Say, a user login my database and don't logout from database and he don't do anything in oracle. I want automatically logout from oracle after a certain time he is idle.

    For your information i'm using oracle 8.0.5 and developer 2000.

    Thanks in advance.

    Momin
    Working Together...

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    create a profile with idle_time = <your timeframe to kick out in minutes>

    alter user <your user> profile <your profile>;
    additionally set resource_limit = true in your initORA

  3. #3
    Join Date
    Jul 2004
    Posts
    102
    Thanks osy45

    please provie me the code for create a user profile with idle_time.
    Working Together...

  4. #4
    Join Date
    Nov 2002
    Posts
    833
    create profile idle_profile limit idle_time=15;

    and it is a good idea to start RTM

  5. #5
    Join Date
    Jul 2004
    Posts
    102
    Thanks again osy45 for your prompt response.

    What is RTM and how it start ?

    pardone me if i bother you .
    Working Together...

  6. #6
    Join Date
    Nov 2002
    Posts
    833
    Read the manual tahiti.oracle.com sql reference

  7. #7
    Join Date
    Jul 2004
    Posts
    102
    Many many thanks for your help
    Working Together...

  8. #8
    Join Date
    Jul 2004
    Posts
    102
    Hi osy45

    I implement a profile maned comm_user with idle_time=15.
    Bus after 15 min the STATUS shows SNIPED not killed.

    I aslo add set resource_limit = true with alter system command.

    Please explain.....Is there any problem.
    Last edited by Momin; 10-14-04 at 03:05.
    Working Together...

  9. #9
    Join Date
    Nov 2002
    Posts
    833
    as you are on 8.0.5 : I can remember that in some versions pre 8i had a bug where the background process was unable to remove the sniped sessions. Therefore, I had written a generic script and then croned the job which retrieved all the sniped sessions and killed them explicitly.

    select 'alter system kill session(' ||sid ||','|| serial# ||');' from v$session where status = 'SNIPED';
    Last edited by osy45; 10-14-04 at 04:23.

  10. #10
    Join Date
    Jul 2004
    Posts
    102
    Thanks for your prompt help osy45
    Working Together...

  11. #11
    Join Date
    Jul 2004
    Posts
    102
    osy45

    I'm in terible condition. After implement idle_time the users status shows SNIPED and after kill his session status shows KILLED, but after killed the user session user still unable to LOGON again. also in the v$session the user status shows KILLED.

    Please help me, How i survibe from this. After Kill user session why user cannot able to logon ?
    Working Together...

  12. #12
    Join Date
    Nov 2002
    Posts
    833
    do you have set any other profile properties, i.e. max sessions per user or the like ?

    post your profile and the properties
    and the properties of your user

    I don't remember of any initORA parameters that allow users only to connect once which sounds to be your problem

  13. #13
    Join Date
    Jul 2004
    Posts
    102
    My profile is

    create profile comm_user limit
    idle_time 10
    sessions_per_user 2

    User property :..

    CREATE USER momin
    IDENTIFIED BY momin
    DEFAULT TABLESPACE user_data
    TEMPORARY TABLESPACE user_data
    PROFILE COMM_USER;
    Working Together...

  14. #14
    Join Date
    Nov 2002
    Posts
    833
    you are allowing only 2 sessions per user ...
    if there is one killed in v$session and not removed by the oracle Server then only one other session is allowed with momin
    ...

    increase the value for sessions_per_user

  15. #15
    Join Date
    Jul 2004
    Posts
    102
    Quote Originally Posted by osy45
    and not removed by the oracle Server then only one other session is allowed with momin
    ...
    how i removed the killed session from oracle server at a time when i kill users sessions ?
    Working Together...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •