How to find what SIDs are available on your machine
From dbawiki
Contents
From Unix[edit]
ps -ef | grep [o]ra_pmon | sed -e 's/.*_//' | sort | uniq
or
ps -ef | grep [o]ra_pmon | awk -F_ '{print $NF}'
From Windows[edit]
Look through list for services beginning with OracleService<SID>
services.msc
From the Windows command line[edit]
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\n\" if /OracleService(.+)$/"
How to see what databases have been defined (running or not)[edit]
cat /var/opt/oracle/oratab (Solaris)
cat /etc/oratab (others)
