2017-03-11

How to know if Oracle Database instance is Running

Quick check if there's Oracle database instance running - by checking the presence of smon and pmon.

$ uname -a
HP-UX sapprd01 B.11.31 U ia64 0574715905 unlimited-user license
$ sudo ps -ef | grep [p,s]mon | grep -v grep
Last successful login:       Sat Mar 11 13:31:51 MET 2017
Last authentication failure: Wed Jan  6 09:42:00 MET 2016 10.75.236.144
    root  3708     1  0  Oct  4  ?         2:29 /etc/opt/resmon/lbin/p_client
    root  3132     1  0  Oct  4  ?         0:00 /etc/opt/resmon/lbin/emsagent
  vipadm 10646     1  0  Oct  4  ?        44:04 ora_smon_VIP
  vipadm 10604     1  0  Oct  4  ?        102:57 ora_pmon_VIP

$ sudo /usr/sbin/cmviewcl
Last successful login:       Sat Mar 11 14:00:00 MET 2017
Last authentication failure: Wed Jan  6 09:42:00 MET 2016 10.120.3.100
CLUSTER        STATUS    
DLG_SAP        up        

  NODE           STATUS       STATE      
  saptst01        down         halted    
  sapprd01        up           running    
    PACKAGE        STATUS           STATE            AUTO_RUN    NODE      
    vip            up               running          disabled    sapprd  
 
UNOWNED_PACKAGES
    PACKAGE        STATUS           STATE            AUTO_RUN    NODE      
    rst            down             halted           disabled    unowned     

No comments:

Post a Comment