Are there any troubleshooting tips for OEM?

  • Create the OEM repository with a user (which will manage the OEM) and store it in a tablespace that does not share any data with other database users. It is a bad practice to create the repository with SYS and System.

  • If you are unable to launch the console or there is a communication problem with the intelligent agent (daemon).

    Ensure OCX files are registered. Type the following in the DOS prompt (the current directory should be $ORACLE_HOMEBIN:

    C:Orawin95Bin> RegSvr32 mmdx32.OCX
    
    C:Orawin95Bin> RegSvr32 vojt.OCX

  • If you have a problem starting the Oracle Agent

    Solution A: Backup the *.Q files and Delete all the *.Q Files
    ($Oracle_home/network/agent folder)

    Backup and delete SNMP_RO.ora, SNMP_RW.ora, dbsnmp.ver and services.ora files
    ($Oracle_Home/network/admin folder)

    Start the Oracle Agent service.

    Solution B: Your version of Intelligent Agent could be buggy. Check with Oracle for any available patches. For example, the Intelligent Agent that comes with Oracle 8.0.4 is buggy.

  • Sometimes you get a Failed status for the job that was executed successfully.

    Check the log to see the results of the execution rather than relying on this
    status.