What is a quick way to find out what's wrong with an oracle database

If you run this query, you'll get back info on any serious problems, also check the alert.log file. The alert log is located in $ORACLE_HOME/admin/$ORACLE_SID/bdump