Difference between revisions of "Which databases are running on the machine"
From dbawiki
(→From Windows) |
(→From Windows) |
||
| Line 4: | Line 4: | ||
==From Windows== | ==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' | |
| − | + | </pre> | |
| − | |||
==How to see what databases have been defined (running or not)== | ==How to see what databases have been defined (running or not)== | ||
Revision as of 08:20, 3 May 2016
From Unix
ps -ef|grep [o]ra_smon|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)
