How to check oracle database status

How to check oracle database status – Interview question

let us find out the database health status by using following sql command. Check whether the Oracle Process run or not#> ps -ef | grep pmon If no pmon detected, your database might be down Check the instance status SQL>select instance_name, status from v$instance; Check whether the database can be read or write SQL>select name, …

How to check oracle database status – Interview question Read More »