discover database on oms

Posted on 2005-05-15
Last Modified: 2012-05-05
i am discovering nodes on oms (oracle 9i on windows).  Although successfully discovering nodes, it is not discovering the databases. Is there an additional step for this?
Question by:asardesai
    LVL 2

    Expert Comment

    Follow the steps

    1. oemctl stop  oms                           ->  Stop the Oracle Management Server
    2. agentctl stop agent                        ->  Stop the Oracle Agent
    3. lsnrctl stop                                    -> Stop the Listener
    4. Configure your Listener Entry with GLOBAL_DBNAME = <<DB_NAME>>
    5. lsnrctl start                                    -> Start the Listener
    6. agentctl start agent                        -> Start the Oracle Agent
    7. oemctl start  oms                           -> Start the Oracle Management Server
    8. Now discover the Node by giving the host ( ip-address ).

    This worked fine for me..

    LVL 5

    Accepted Solution


    try this

    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.

    LVL 47

    Expert Comment

    In TNSNAMES.ORA insert a connection string for every Data Base.
    Check with SQL*Plus if you can successfully connect to every DB.
    After that start O E M.
    Use the Add databases option - right click on Databases and choose Add Databases.
    Choose radio button "... fron your tnsnames.ora...."
    Choose the desired databases.
    Thats all.
    LVL 21

    Expert Comment

    I think that all the previously mentioned might work but You need to put attention on the version mismatch ,if the version of Your OMS is greater than Your databases',say when  on dbs You must upgrade Your db's on windows,that anyway what I know.
    Hope it really helps,Oleg

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Title # Comments Views Activity
    query run slowness in 12c 23 92
    Converting BLOB to XMLTYPE 12 83
    Read only access to a user 5 83
    substr - oracle 5 49
    Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now