Which databases are running on the machine - Revision history

Stuart: /* From Windows */

2017-06-20T13:58:10Z

‎From Windows

Stuart: /* How to see what databases have been defined (running or not) */

2017-06-20T13:31:19Z

‎How to see what databases have been defined (running or not)

Stuart: /* From Unix */

2017-05-31T08:11:00Z

‎From Unix

Stuart at 08:22, 3 May 2016

2016-05-03T08:22:54Z

Stuart: /* From Windows */

2016-05-03T08:20:19Z

‎From Windows

Shb: /* From Windows */

2011-11-22T22:31:50Z

‎From Windows

Shb: Created page with "==From Unix== ps -ef|grep [o]ra_smon|sed -e 's/.*_//'|sort|uniq ==From Windows== services.msc Look through list for services beginning with OracleService ==How to see ..."

2011-11-22T22:25:37Z

Created page with "==From Unix== ps -ef|grep [o]ra_smon|sed -e 's/.*_//'|sort|uniq ==From Windows== services.msc Look through list for services beginning with OracleService<SID> ==How to see ..."

New page

==From Unix==
ps -ef|grep [o]ra_smon|sed -e 's/.*_//'|sort|uniq

==From Windows==
services.msc
Look through list for services beginning with OracleService<SID>

==How to see what databases have been defined (running or not)==
cat /var/opt/oracle/oratab (Solaris)

cat /etc/oratab (others)

@@ Line 6: / Line 6: @@
 ==From Windows==
 <pre>
-sc query | perl -00 -ne 'print "$1 $2\n"  if /^SERVICE_NAME: OracleService(\w+).DISPLAY.+?STATE\s+:\s+\d\s+(\w+)/s'
+sc query | perl -00 -ne 'print "$1 $2\n"  if /^SERVICE_NAME: OracleService(\w+).TYPE.+?STATE\s+:\s+\d\s+(\w+)/s'
 </pre>

@@ Line 8: / Line 8: @@
 <pre>
 sc query | perl -00 -ne 'print "$1 $2\n"  if /^SERVICE_NAME: OracleService(\w+).DISPLAY.+?STATE\s+:\s+\d\s+(\w+)/s'
 </pre>

@@ Line 1: / Line 1: @@
 ==From Unix==
 <pre>
-ps -ef|grep [o]ra_smon|sed -e 's/.*_//'|sort|uniq
+ps -ef|grep [o]ra_pmon|sed -e 's/.*_//'|sort|uniq
 </pre>

@@ Line 4: / Line 4: @@
 ==From Windows==
-Start,run... then:
+<pre>
- services.msc
+sc query | perl -00 -ne 'print "$1 $2\n"  if /^SERVICE_NAME: OracleService(\w+).DISPLAY.+?STATE\s+:\s+\d\s+(\w+)/s'
-Look through list for services beginning with OracleService<SID>
+</pre>
 ==How to see what databases have been defined (running or not)==