HERNK’S JOURNAL

How to check Oracle Instance is Up or Down

Posted by: hernk on: 22 December 2008

Here is the simplest way how to know whether oracle instance is up or down :
1. Try to connect to oracle using sqlplus /nolog
2. And then put code conn /as sysdba
3.  Let see in v$instance using query : select status from v$instance;
If the result is OPEN, it means that the Oracle is already up but if oracle give an error mesage message
ERROR at line 1:
ORA-01034: ORACLE not available -> oracle instance is not running.
4. If oracle is down and then You want to start it, You may using command startup and wait until database mounted and opened.

2 Responses to "How to check Oracle Instance is Up or Down"

Excellent site, keep up the good work

Hi,

Very interesting. Thanks for such great article.

Thanks and regards,
Gitesh
http://www.dbametrix.com

Leave a Reply

Categories

Blog Stats

  • 44,669 hits

Archives

Flickr Photos

luv

lotus

white lotus

serangga2

More Photos

Web Stat

Blog Worth


My blog is worth $564.54.
How much is your blog worth?