:

RSSEnterprise Manager

Oracle Agent Ports

To put it simply, I have found that you need to have the following ports open in order to get Oracle’s Enterprise Manager to work: Port 1754 (from OMS to DB) Port 7772 (from DB to OMS) The above refers to the Oracle Management Server (OMS), which is where the Oracle software for Enterprise Manager is […]

Continue Reading

Enterprise Manager Library Job Removal

One of the main purposes of the Enterprise Manager (EM) software is to centralise the management of various components across your infrastructure. Using the EM software, you can schedule jobs to run against various targets. If, like me, you have lots of jobs running against the databases, you may want to delete them all at […]

Continue Reading

Collection Status Disabled by Upload Manager – EM Agent

I was investigating an issue whereby our Oracle 10g management agent had stopped uploading its XML files to the Oracle Management Service (OMS). We could not see why, and we had not made any changes. The agent just would not work as it should do. We found the following out: Collection Status: Disabled by Upload […]

Continue Reading

Oracle Enterprise Manager Grid (lock)…HTTP Error 500

After having our 10g Grid control Enterprise Manager system set-up and working well for many months, we started to see issues with  slowness, occasional timeouts on the web pages and jobs becoming suspended more and more frequently and in what seemed to be a random pattern. We were also receiving errors like the below when attempting to […]

Continue Reading

Error from SQLPLUS 255

The Problem When running a job from the Oracle Enterprise Manager Grid  Control, I kept getting the error message: Error from SQLPLUS: 255 The target was valid and up, along with the agent and  everything looked OK. Jobs were also working fine for other targets on the same  host, using the same Oracle management agent. […]

Continue Reading

OMS Won’t Start – StatusOMSCmd.java:223

The Problem After restarting the 11g OMS and Grid Control Repository, I was receiving the error below when running the command: D:\oracle\Middleware\oms11g\BIN>emctl start oms Windows service OracleManagementServer_EMGC_OMS1_1 failed to be started Oracle Management Server is not functioning because of the following reason: Unexpected error occurred. Check error and log files. Please check D:/oracle/gc_inst/em/EMGC_OMS1\sysman\log\emctl.log for error […]

Continue Reading

ORA-01873: the leading precision of the interval is too small

The Problem I was regularly receiving the following error messages in the emagent.trc file for my Oracle 11g agent. This may or may not have been after I switched tracing on but I only noticed them after it had been switched on because I was investigating an issue we were having with high CPU load […]

Continue Reading

ORA-06512: at “SYSMAN.MGMT_JOB_UI”, line 4847 ORA-06512

The Problem When attempting to remove a job from the Enterprise Manager library, you receive the following error message: ORA-01403: no data found ORA-06512: at “SYSMAN.MGMT_JOB_UI”, line 4847 ORA-06512: at line 1 The Cause It seems to be because there is no target associated with the job. If you look at the job in the […]

Continue Reading

Oracle 11g Enterprise Manager Agent Tracing

If you are having issues with your Oracle 11g agent, perhaps you are experiencing high CPU load from a perl.exe process, then you may want to turn tracing on in order to upload the details to Oracle support. Here is how you go about doing that: Create Backups of Configuration Files 1. Backup agent11g/sysman/config/emagentlogging.properties 2. […]

Continue Reading

Oracle 10g Agent Doesn’t Start on Windows Server

I ran into a problem the other day where the Oracle  Enterprise Manager 10g Agent would not start. This was on a Windows Server ia64,  which was dual homed; Oracle 9i & Oracle 10g homes. I had only just installed the Oracle 10g agent, and I  already had a 9i agent installed and running. This […]

Continue Reading