查看oracle状态

1. 查看数据库运行状态

表示数据库正在运行状态

[root@ebsdalian ~]# ps -ef | grep ora_
root      3612 32490  0 11:22 pts/3    00:00:00 grep ora_
oracle   30891     1  0 10:33 ?        00:00:00 ora_pmon_VIS
oracle   30893     1  0 10:33 ?        00:00:00 ora_dbw0_VIS
oracle   30895     1  0 10:33 ?        00:00:00 ora_lgwr_VIS
oracle   30897     1  0 10:33 ?        00:00:00 ora_ckpt_VIS
oracle   30899     1  0 10:33 ?        00:00:00 ora_smon_VIS
oracle   30901     1  0 10:33 ?        00:00:00 ora_reco_VIS
oracle   30903     1  0 10:33 ?        00:00:00 ora_cjq0_VIS
oracle   30905     1  0 10:33 ?        00:00:06 ora_qmn0_VIS
[root@ebsdalian ~]#

 

 

2. 查看监听状态：

表示监听正在运行

[oracle@ebsdalian ~]$ lsnrctl status

LSNRCTL for Linux: Version 9.2.0.5.0 - Production on 05-DEC-2012 11:24:07

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     VIS
Version                   TNSLSNR for Linux: Version 9.2.0.5.0 - Production
Start Date                05-DEC-2012 10:49:42
Uptime                    0 days 0 hr. 34 min. 26 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /d01/oracle/visdb/9.2.0/network/admin/VIS_ebsdalian/listener.ora
Listener Log File         /d01/oracle/visdb/9.2.0/network/admin/vis.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCVIS)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebsdalian.ge.com)(PORT=1521)))
Services Summary...
Service "PL***tProc" has 1 instance(s).
  Instance "PL***tProc", status UNKNOWN, has 1 handler(s) for this service...
Service "VIS" has 2 instance(s).
  Instance "VIS", status UNKNOWN, has 1 handler(s) for this service...
  Instance "VIS", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@ebsdalian ~]$