In Linux/Unix, you can verify the SMON (system monitor) is running:
ps –ef | grep smon
In both cases, this will tell you if the instance is up, but not necessarily accessible. There are cases where a user cannot sign on to the database but the above looks like the instance is up and running. To verify things are still ok, you will have to sign on to the database.
Dig Deeper on Oracle database design and architecture
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading