Skip to content

How to find what sids are available on your machine

From Unix

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

or

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

From Windows

Look through list for services beginning with OracleService\<SID>

services.msc

From the Windows command line

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(.+)$/"

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

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

cat /etc/oratab (others)