Problem with OEM
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Problem with OEM

  1. #1
    Join Date
    Dec 2001
    Posts
    9

    Question

    I run oracle8i on win2k. I want to use OEM but when I try to use the service discovery option of OEM, it finds the node but not the database (but I can connect to the database with SQLplus).
    does anyone have an answer ?
    TIA

  2. #2
    Join Date
    Aug 2000
    Posts
    236
    Check if the Oracle agent service on the target database is up and running.

    Nizar

  3. #3
    Join Date
    Dec 2001
    Posts
    9
    Yes the Oracle Agent is running on the database server.

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Configure the database manually instead of "Auto discovery".
    It works..
    Sometimes OEM is unable to discover the DB even if the Oracle agent is running.. (Don't know, why?)
    Sanjay

  5. #5
    Join Date
    Dec 2001
    Posts
    9
    How do you configure the database manually ?
    I didn't even know it was possible.

  6. #6
    Join Date
    Jan 2001
    Posts
    191
    Make sure your listerner.ora is correct. And delete snmp_ro.ora and snmp_rw.ora. Then atart your agent again.

  7. #7
    Join Date
    Jan 2001
    Posts
    191
    Once the agent start, the Windows NT agent will first check the Windows NT registry values:
    ORACLE_HOME and ORACLE_SID. The registry keys are located in:

    HKEY_LOCAL_MACHINE => System => CurrentControlset => Services => OracleServicexx
    The Agent checks the entire harddrive and builds a list of all ORACLE HOMEs.
    This list also indicates the SID's in each ORACLE HOME. Another list is also
    constructed for all the services in these ORACLE HOMEs (if more than one).
    After all the information about SIDs, Listeners and other services are obtained
    and analyzed, a summary will be written to the "services.ora" file. This file
    is ALWAYS written to "ORACLE_HOME/network/agent" or "ORACLE_HOME/net80/agent"
    directory. The "services.ora" file is used when the EM Console's Communication
    Daemon or the Oracle Management Server checks for discovered services on a
    specific node.

    The Agent also generates two other configuration files "snmp_ro.ora" and
    "snmp_rw.ora". These files are written to either "ORACLE_HOME/network/admin" or
    "ORACLE_HOME\NET80\admin". The files can also be written to the "TNS_ADMIN"
    location. The two files contain Agent configuration information. The
    "snmp_ro.ora" file is read only and cannot be edited. It contains all the
    services information the SIDs and ORACLE_HOMEs.

  8. #8
    Join Date
    May 2001
    Posts
    736
    To configure database manually type in the discovery pannel either Host name or it IP address.
    regards
    akhadar

  9. #9
    Join Date
    Dec 2001
    Posts
    9
    even when configuring the database manually, it doesn' work.
    The file 'services.ora' contains :
    dbserver = (ORACLE_NODE, dbserver, dbserver, (PLATFORM=(osName=Windows NT)(osVersion=5.0)))

    the file 'snmp_rw.ora' is empty

    and the file 'snmp_ro.ora' contains :
    snmp.visibleservices = ()
    ifile = D:\oracle\Oracle\network\admin\snmp_rw.ora

    The files 'listener.ora' and 'tnsnames.ora' are probably correct because I can connect to the database with SQLplus.

  10. #10
    Join Date
    Jan 2001
    Posts
    191
    In your tnsname.ora and listenser.ora, host have to be same for that database. You can't use IP address for one and hostname for another. Alse check $ORACLE_HOME/network/log for error information. Check following log file.
    dbsnmpc.log
    dbsnmpw.log
    nmiconf.log


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width