How to know oracle database instance status | Oracle Database instance is running or not | Instance name | Instance status

This post will help you to know the status of oracle database instance. So you can find the database instance is running or not. 


After completing this post study you will get the answer of below questions.

• How to know oracle database instance status?
• Oracle Database instance is running or not
• How to find Instance name?

Run this below query:

SQL> select instance_name, STATUS, DATABASE_STATUS, TO_CHAR(startup_time, 'DD-MON-YY HH:MM:SS AM') startedate from v$instance;

Output will be like this:

INSTANCE_NAME     STATUS       DATABASE_STATUS      STARTDATE
---------------- ------------ ----------------- -----------------------------------------------------
NEW                              OPEN          ACTIVE                    24-JAN-19 10:01:15 AM


 






Note: you can use this query to get individual output.
For-example:



Run below query to know the instance name only. 

SQL> select instance_name from v$instance; 

output:            INSTANCE_NAME
                        ----------------
                         NEW

 if you have any question then feel free to comments. 

 

You can find me on Fiverr & LinkedIn