Oracle Database Discussions

Hi,

I have a probem in my production database -

Server - Windows 2003
DB - Oracle 10g

When i try to open Enterprise Manager I get the below error message. This was working fine since last month. But I haven't made any changes to this DB. But I noticed that disk space was very less so I deleted files from recycle bin, temp internet files, cookies and some unwanted documents i copied on the server. No disc space is OK. I have 10 GB free space. Also i am getting DB warning notification because table space is 92 % full so I want to increase it. But I dont know why I am getting this because I had already set to grow table space automatically.

Is there any other way to increase table space other than that in Enter prise manager ?


Message:*

*"The database status is currently unavailable. It is possible that the database is in mount or nomount state...."*

I tried to troubleshoot as per some forums but it doesnt work. If i use command prompt or sql plus to connect to DB it works but only enterprise manager has this issue. Also my Documentum Application connected to this DB works fine.

listner is fine. Also I added server login account in 'log on as batch john' in local policies.


I do not have a back up to restore also.


Regards,
Ranjith John