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 12.1.0.3.0 and later
Information in this document applies to any platform.

Goal

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

GLOBAL_NAME            TARGET_NAME OPEN_MODE LOGINS
------------------------- ----------------- -------------- ----------
OEM.ORACLE.COM       OEM.WORLD    NO               NO
 

Solution

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 hundreds of Community platforms