My Oracle Support Banner

EM 13c, 12c: MGMT$DB_DBNINSTANCEINFO view shows "NO" for both Open_Mode and Logins (Doc ID 2389349.1)

Last updated on MAY 23, 2018

Applies to:

Enterprise Manager for Oracle Database - Version and later
Information in this document applies to any platform.


This article explains why Open_mode and logins show "NO" in MGMT$DB_DBNINSTANCEINFO when the Database is up and running as expected in read-write mode.

To test:

SQL> select COLLECTION_TIMESTAMP,global_name,target_name,open_mode,logins from MGMT$DB_DBNINSTANCEINFO

------------------------- ----------------- -------------- ----------
OEM.ORACLE.COM       OEM.WORLD    NO               NO


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.