Sign in or 
Share this
Determine Oracle Instance Status
set lines110
col strtd hea 'STARTED'
col instance_name for a8 hea 'INSTANCE'
col host_name for a15 hea 'HOSTNAME'
col version for a10
select instance_name, version, host_name, status
, database_status, to_char(startup_time,'DD-MON-YYYY HH:MI:SS') strtd
from v$instance;
INSTANCE VERSION .. HOSTNAME ...... STATUS ..... DATABASE_STATUS . STARTED
-------- ---------- --------------- ------------ ----------------- --------------------
orcl ... 11.1.0.6.0 OLAPDBA-LAP ... OPEN ....... ACTIVE .......... 10-NOV-2007 09:47:42
--Use GV$INSTANCE for RAC Database
select instance_name, version, host_name, status
, database_status,to_char(startup_time,'DD-MON-YYYY HH:MI:SS') strtd
from gv$instance;
--Or use V$THREAD
select instance, status, enabled, open_time, checkpoint_time
from v$thread;
INSTANCE STATUS . ENABLED. OPEN_TIME ......... CHECKPOINT_TIME
-------- -------- -------- ------------------- -------------------
sigd1 .. OPEN ....PUBLIC . 14/01/2008 15:26:51 23/01/2008 15:16:05
sigd2 .. OPEN ....PUBLIC . 15/01/2008 16:23:03 23/01/2008 15:16:06
col strtd hea 'STARTED'
col instance_name for a8 hea 'INSTANCE'
col host_name for a15 hea 'HOSTNAME'
col version for a10
select instance_name, version, host_name, status
, database_status, to_char(startup_time,'DD-MON-YYYY HH:MI:SS') strtd
from v$instance;
INSTANCE VERSION .. HOSTNAME ...... STATUS ..... DATABASE_STATUS . STARTED
-------- ---------- --------------- ------------ ----------------- --------------------
orcl ... 11.1.0.6.0 OLAPDBA-LAP ... OPEN ....... ACTIVE .......... 10-NOV-2007 09:47:42
--Use GV$INSTANCE for RAC Database
select instance_name, version, host_name, status
, database_status,to_char(startup_time,'DD-MON-YYYY HH:MI:SS') strtd
from gv$instance;
--Or use V$THREAD
select instance, status, enabled, open_time, checkpoint_time
from v$thread;
INSTANCE STATUS . ENABLED. OPEN_TIME ......... CHECKPOINT_TIME
-------- -------- -------- ------------------- -------------------
sigd1 .. OPEN ....PUBLIC . 14/01/2008 15:26:51 23/01/2008 15:16:05
sigd2 .. OPEN ....PUBLIC . 15/01/2008 16:23:03 23/01/2008 15:16:06
olapdba |
Latest page update: made by olapdba
, Feb 13 2008, 11:25 AM EST
(about this update
About This Update
Edited by olapdba
9 words added 7 words deleted view changes - complete history) |
|
Keyword tags:
None
More Info: links to this page
|
There are no threads for this page.
Be the first to start a new thread.
