Difference between revisions of "Which databases are running on the machine"
From dbawiki
(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 ...") |
(→From Windows) |
||
| Line 4: | Line 4: | ||
==From Windows== | ==From Windows== | ||
| + | Start,run... then: | ||
services.msc | services.msc | ||
Look through list for services beginning with OracleService<SID> | Look through list for services beginning with OracleService<SID> | ||
| − | + | When I get the hang of bat files, I'll write a script for it. | |
==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 22:31, 22 November 2011
From Unix
ps -ef|grep [o]ra_smon|sed -e 's/.*_//'|sort|uniq
From Windows
Start,run... then:
services.msc
Look through list for services beginning with OracleService<SID> When I get the hang of bat files, I'll write a script for it.
How to see what databases have been defined (running or not)
cat /var/opt/oracle/oratab (Solaris)
cat /etc/oratab (others)
