Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Determining the oracle instances running in my machine

martin75May 16 2008 — edited May 16 2008

How can i determine the differenct instances running in my Solaris machine? Can i issue the command ps -ef |grep smon and then identify each instance from the naming convention

$ ps -ef |grep smon
  oracle 3461298       1   0 04:17:54      -  1:03 ora_smon_oratesc
  oracle 5103754 3448876   0 18:25:42  pts/0  0:00 grep smon

Here i can confirm that there is an instance called oratesc is running in this machine. If there was was a process called ora_smon_oraeuc, i could confirm that there is an instance called oraeuc is running in this machine. Right? I can grep for pmon process as well. Can't i?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 13 2008
Added on May 16 2008
12 comments
3,227 views