How to check oracle database status – Interview question

let us find out the database health status by using following sql command.

  1. Check whether the Oracle Process run or not#> ps -ef | grep pmon If no pmon detected, your database might be down
  2. Check the instance status SQL>select instance_name, status from v$instance;
  3. Check whether the database can be read or write SQL>select name, open_mode from v$database;

Check whether client can access the database

  1. Check whether the listener is available or not #> lsnrctl status
  2. Do tnsping from remote site #> tnsping SID

Thanks for visiting this post. Please contact us if you are looking for training.
Subscribe to our channel for unlimited learning. Thank you!!!

Leave a Reply

Your email address will not be published. Required fields are marked *