Difference between revisions of "Which databases are running on the machine"
From dbawiki
(→From Unix) |
|||
| Line 1: | Line 1: | ||
==From Unix== | ==From Unix== | ||
| + | The 'uniq' should not be necessary! | ||
<pre> | <pre> | ||
| − | ps -ef|grep [o] | + | ps -ef|grep [o]ra_pmon|sed -e 's/.*_//'|sort|uniq |
</pre> | </pre> | ||
Revision as of 08:11, 31 May 2017
From Unix
The 'uniq' should not be necessary!
ps -ef|grep [o]ra_pmon|sed -e 's/.*_//'|sort|uniq
From Windows
sc query | perl -00 -ne 'print "$1 $2\n" if /^SERVICE_NAME: OracleService(\w+).DISPLAY.+?STATE\s+:\s+\d\s+(\w+)/s'
How to see what databases have been defined (running or not)
cat /var/opt/oracle/oratab (Solaris) cat /etc/oratab (others)
