Database

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
Advertisements

Discussion

No comments yet.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Archives

Twitter Updates

Error: Twitter did not respond. Please wait a few minutes and refresh this page.

%d bloggers like this: