Oracle: Check state of database instance

Environment: Oracle 10g
- Connect SQL*Plus as database administrator (DBA).
- In SQL*Plus, use command "SELECT * FROM V$INSTANCE".
- See in the column "STATUS" whether it's "OPEN" or not.

Comments

  1. What if the database is in "nomount" ot "mount" state? How to check this state?

    ReplyDelete

Post a Comment

Popular posts from this blog

Microsoft Visio: How to set default font

LINE: Change the contact name

Microsoft Word: Make picture background to be transparent