Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

System Account Keeps Locking (Timed)

552829Jun 5 2007 — edited Jun 12 2007
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. 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. 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 10 2007
Added on Jun 5 2007
5 comments
1,163 views