Home » RDBMS Server » Server Administration » System account keeps locking
System account keeps locking [message #243053] Tue, 05 June 2007 16:46
suzyque54
Messages: 14
Registered: December 2006
Junior Member
I am using Oracle 10g R2 on Windows 2003. I just put up a new database and the system account keeps locking. I unlock the account, but it will lock again sometimes as often as every 15 minutes, at other times it will be as long as an hour before it locks again. The system account is assigned to the Default profile and per Oracle's suggestion I set everything in the Default Profile to unlimited, but this didn't help the account keeps locking. Anyone have any ideas?

SQL> select profile from dba_users where username = 'SYSTEM';

PROFILE
------------
DEFAULT

SQL> select resource_name, limit from dba_profiles where profile = 'DEFAULT';

RESOURCE_NAME LIMIT
--------------------------------
COMPOSITE_LIMIT UNLIMITED
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL UNLIMITED
LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED
IDLE_TIME UNLIMITED
CONNECT_TIME UNLIMITED
PRIVATE_SGA UNLIMITED
FAILED_LOGIN_ATTEMPTS UNLIMITED
PASSWORD_LIFE_TIME UNLIMITED
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_VERIFY_FUNCTION NULL
PASSWORD_LOCK_TIME UNLIMITED
PASSWORD_GRACE_TIME UNLIMITED
Previous Topic: Constraints
Next Topic: GATHER_TABLE_STATS - temp tablespace getting full
Goto Forum:
  


Current Time: Sat Dec 03 14:23:19 CST 2016

Total time taken to generate the page: 0.08710 seconds