How can I know , whether oracle is running or not?

Hi,
  How can I know , whether oracle is running or not?
  Since, if I want to know, whether a process is running or not, by using the command
  ps -aef | grep process_name | grep -v grep.
   In case of oracle databse, in place of "process_name", what I have to give ?  
bobyjoseAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
banickiConnect With a Mentor Commented:
ps -aef | grep ora_pmon | grep -v grep
oracle consist of 5 or 6 processes which function together.
on my aix box they are:
ora_pmon
ora_smon
ora_reco
ora_ckpt
ora_lgwr
ora_arch, if you are running in archive log  mode

any one of these processes should work.

terry
0
 
alexhudghtonCommented:
ps -aef | grep ora_ | grep -v grep

will give you a list of all oracle database processes running for all instances
0
 
bellyboyCommented:

Note that if the database is hanging ... perhaps a shutdown is in progress/hanging these processes will still be there.

In scripts I always also do a check which logs on as sqlplus and select * from v$database to give the database name.


0
 
geotigerCommented:
Running Oracle processes do not mean Oracle is functioning properly. Check your alert log file. Any database changes and unusual behaviers are logged in the file.  It is located in Oracle's background_dump_dest directory.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.