How to check your Oracle Database status (whether running properly or not)

As a Database Administrator you should know how to check whether your database can work properly or not.
Here’s the steps that you can use to know whether your oracle database work properly or not (in Unix OS)

Check whether the instance run well and database can be accessed

  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


No comments yet.

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s


Twitter Updates

Error: Please make sure the Twitter account is public.

%d bloggers like this: