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.

Comments

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

It should be "ps -ef | grep -i pmon"
naor-search said…
Thank you :)

Popular posts from this blog

How to set or disable auto-logout on bash shell

How to install PGPool II on PostgreSQL Servers in master-slave architecture + PGPoolAdmin web managment

Setting Filezilla Server on Amazon EC2 instance with passive ftp