How do one check for the oracle db whether it is started,shutdown ?

On: Friday, December 06, 2013 By: Azhar Mulla 0 comments

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Dec 6 10:29:27 2013

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select status from v$instance;

STATUS
------------
OPEN