Oracle Database Discussions

First I want to thank you before hand any help you could give me.

I have installed Oracle 10g in a Windows Server 2003 machine, now after starting my data base instance I try to log in as SYS or SYSTEM through the management console and I am getting the following error: “ORA-28000 the account is locked”, I have configured the listener and tnsnames to get in the service and unsuccessfully could not get in through the management console.

Through the SqlPlus I can get in without any problem.

I tried to solve the problem on my own and I have made the following queries according to the information I was getting on the way:



SQL> select user_id,username, account_status,profile from dba_users;



USER_ID USERNAME ACCOUNT_STATUS PROFILE

---------- ------------------------------ -------------------------------- -----------

5 SYSTEM OPEN DEFAULT

0 SYS OPEN DEFAULT







SQL> select profile,resource_name,limit
2 from dba_profiles
3 where resource_type='PASSWORD'
4 order by profile;



PROFILE RESOURCE_NAME LIMIT
------------------------------ -------------------------------- ------------------
DEFAULT FAILED_LOGIN_ATTEMPTS 10
DEFAULT PASSWORD_LIFE_TIME UNLIMITED
DEFAULT PASSWORD_REUSE_MAX UNLIMITED
DEFAULT PASSWORD_LOCK_TIME UNLIMITED
DEFAULT PASSWORD_GRACE_TIME UNLIMITED
DEFAULT PASSWORD_VERIFY_FUNCTION NULL
DEFAULT PASSWORD_REUSE_TIME UNLIMITED
MONITORING_PROFILE FAILED_LOGIN_ATTEMPTS UNLIMITED
MONITORING_PROFILE PASSWORD_GRACE_TIME DEFAULT
MONITORING_PROFILE PASSWORD_LOCK_TIME DEFAULT
MONITORING_PROFILE PASSWORD_VERIFY_FUNCTION DEFAULT


PROFILE RESOURCE_NAME LIMIT
------------------------------ -------------------------------- ------------------
MONITORING_PROFILE PASSWORD_REUSE_MAX DEFAULT
MONITORING_PROFILE PASSWORD_REUSE_TIME DEFAULT
MONITORING_PROFILE PASSWORD_LIFE_TIME DEFAULT

I do not know what else to do.
Thank you very much for your help.