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.

Popular posts from this blog

Microsoft Word: Make picture background to be transparent

Microsoft Visio: How to set default font

LINE: Change the contact name