DEVFYI - Developer Resource - FYI

How does one list one's databases in the OEM Console? (for DBA

ORACLE Interview Questions and Answers (Part 4)


(Continued from previous question...)

580. How does one list one's databases in the OEM Console? (for DBA

Follow these steps to discover databases and other services from the OEM Console:
1. Ensure the GLOBAL_DBNAME parameter is set for all databases in your LISTENER.ORA file (optional). These names will be listed in the OEM Console. Please note that names entered are case sensitive. A portion of a listener.ora file:
(SID_DESC =
(GLOBAL_DBNAME = DB_name_for_OEM)
(SID_NAME = ...
2. Start the Oracle Intelligent Agent on the machine you want to discover. See section "How does one start the Oracle Intelligent Agent?".
3. Start the OEM Console, navigate to menu "Navigator/ Discover Nodes". The OEM Discovery Wizard will guide you through the process of discovering your databases and other services.

(Continued on next question...)

Other Interview Questions