DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: 'system' getting locked

  1. 02-03-2006, 12:34 PM #1
    daljitsb
    daljitsb is offline Member
    Join Date
    Jul 2003
    Posts
    136

    Exclamation 'system' getting locked

    Oracle 10g - 10.1.0.2.0
    Windows 2003 server

    I have this strange issue of 'system' user being locked.

    My all other 5-6 10g db installation are behaving fine but this one db always locks the 'system' user and then I have to login as sysdba to unlock it to be able to connect it as system.

    I don't know what script/process is causing it.

    Please suggest a fix for this. Finding the cause is ideally I am looking for.

    -D
    Reply With Quote Reply With Quote
  2. 02-03-2006, 12:54 PM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    profiles, locking the user after unsuccesfull login attempts?

    someone logging in as sysdba to lock it?

    It should be locked anyway. turn auditing on and you will find out
    Reply With Quote Reply With Quote
  3. 02-03-2006, 01:00 PM #3
    daljitsb
    daljitsb is offline Member
    Join Date
    Jul 2003
    Posts
    136
    Quote Originally Posted by davey23uk
    profiles, locking the user after unsuccesfull login attempts?

    someone logging in as sysdba to lock it?

    It should be locked anyway. turn auditing on and you will find out
    Nobody has access to this new database. Its just happening ever since I finished creating the db using dbca. Other user with same profile are fine.
    -D
    Reply With Quote Reply With Quote
  4. 02-03-2006, 07:41 PM #4
    yxez
    yxez is offline Advisor
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Me too...i experience it but my db is in IBM P5 AIX 5L what i
    observed is that it shows in the OEM that is it timed-locked.
    Is there any settings in user profile to timed-lock a certain user?
    Last edited by yxez; 02-03-2006 at 07:45 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width