dbawiki

ps -ef | grep [[o]]ra_pmon | sed -e 's/.*_//' | sort | uniq

or

ps -ef | grep [[o]]ra_pmon | awk -F_ '{print $NF}'

Look through list for services beginning with OracleService<SID>

services.msc

Note: Windows does not understand single quotes so the Perl one-liner has to use “

sc queryex state= all | find "SERVICE_NAME" | find "OracleService" | perl -ne "print \\"$1\
" if /OracleService(.+)$/"

cat /var/opt/oracle/oratab (Solaris)

cat /etc/oratab (others)