Oracle Database Discussions

Hi all,

I'm working on 10g Enterprise, with Windows 2003 platform.

There are two major problems

1. logon database from sqlplus

ORA-00257 : archiver error. Connect internal only, until freed.

I'm not able to cleanup the archive logs since I couldn't access database. The
archive logs generate fast abnormally.

2. logon from OEM

It shows:
The database status is currently unavailable. It is possible that the database is
in mount or nomount state. Click 'Startup' to obtain the current status and open
the database. If the database cannot be opened, click 'Perform Recovery' to
perform an appropriate recovery operation.

I've tried both 'startup' and 'perform recovery'. Didn't work since I couldn't logon
database.

The earlier error (while I was able to log on database) :

ORA-28001 : The password has expired

I created a profile with restrictions and assigned the profile to all users
except 'sys', 'system', 'karen' (me), and a current user. ( all the users that I've
changed are generated when installed Oracle )

new profile:

failed_login_attempts 10
password_lock_time 1
password_life_time 90
password_grace_time 3
password_reuse_time 180
password_reuse_max 10


I've tried 'alter user identified by' to change the password. It altered, but still
lock me out.
I've tried to change the profile back to the default(original one), I'm still locked
out.

Help!!!

Thanks,
Karen