Differences

This shows you the differences between two versions of the page.

--- which_databases_are_running_on_the_machine [2018/12/08 12:49] – created 0.0.0.0
+++ which_databases_are_running_on_the_machine [2019/01/30 11:32] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-====== Which_databases_are_running_on_the_machine ======
+===== From Unix =====
-======From Unix======
 The 'uniq' should not be necessary!
-<code>0@@</code>
+<code>
+ps -ef|grep [[o]]ra_pmon|sed -e 's/.*_//'|sort|uniq
+</code>
-======From Windows======
+===== From Windows =====
 This shows the service name and its state
-<code>1@@</code>
+<code>
-<code>2@@</code>
+sc query | perl -00 -ne 'print "$1 $2\
+"  if /^SERVICE_NAME: OracleService(\\w+).TYPE.+?STATE\\s+:\\s+\\d\\s+(\\w+)/s'
+</code>
+<code>
+DEV running
+</code>
 To see the value of ORACLE_HOME on Windows, use another sc query:
-<code>3@@</code>
+<code>
+sc qc OracleServiceDEV
+</code>
 The ORACLE_HOME and the instance name can be found on the 'BINARY_PATH_NAME' line.
-<code>4@@</code>
+<code>
+SERVICE_NAME: OracleServiceDEV
+DISPLAY_NAME: Oracle Instance
+        TYPE               : 10  WIN32_OWN_PROCESS
+        START_TYPE         : 3   DEMAND_START
+        ERROR_CONTROL      : 1   NORMAL
+        BINARY_PATH_NAME   : c:\\oracle\\product\\11.2.0\\db\\bin\\ORACLE.EXE DEV
+        LOAD_ORDER_GROUP   :
+        TAG                : 0
+        DISPLAY_NAME       : OracleServiceDEV
+        DEPENDENCIES       :
+        SERVICE_START_NAME : LocalSystem
+</code>