It sounds like the database has gotten "hung up" somehow and needs to be restarted. Log in with SYSDBA privileges and try to do a SHUTDOWN ABORT and then restart the database. You didn't mention which OS you're using but if it's Windows, you could also stop the database service, then reboot the server to restart.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.