Sunday, October 14, 2007

how to locate oracle SID on linux / unix machine

Log into a UNIX or Linux machine as root.
execute: ps -ef |grep -i pmon
you should see something like that:
oracle 27161 1 0 Mar07 ? 00:03:53 ora_pmon_ODS
then ODS is a SID of that oracle.


Sergio Altamirano said...

Thanks! it's missing a pipe symbol in the command.

It should be "ps -ef | grep -i pmon"

naor-search said...

Thank you :)