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.
- 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.
What if the database is in "nomount" ot "mount" state? How to check this state?
ReplyDelete