Hi,


I just found that PMON and SMON are running (i.e., showing in the output of ps -ef | grep -i [o]ra)but when I check MMAN (used for internal database tasks), nothing comes up:

Is that okay or could there be some problem?

So, what are the essential processes of an Oracle Databse that we must check for their status to make sure that the Oracle Databse is up and running fine?

What steps do you usually take to validate an Oracle Databse on a Unix / Linux (Production) Server (specifially immediately after a CR has been worked upon)?

Thanks in advance for sharing your strategies and methods.

Hi,

this depends on the configuration of your database, if you are not aware of what processes are part of Oracle database, you definitly should read Oracle concept guide, which contains detailed process reference.

You can use a SQL connecting to the database, inserting a dummy value into a table, this have to succeed without any error.