Thursday, August 30, 2012

emagent_perl.trc: ERROR: Max Count Value not set properly in file


Errors in $ORACLE_HOME/host/sysman/log/emagent_perl.trc:

maxRowCount.pl: Tue Aug 21 14:34:29 2012: ERROR:  Max Count Value not set properly in file /u01/app/oracle/product/11.2.0/dbhome_1/sysman/config/esa/database.properties line no. 77

1. emctl stop dbconsole

 2. pwd
/u01/app/oracle/product/11.2.0/dbhome_1/sysman/config/esa
3. ls
database.properties  host.properties  instance.properties  oracle_listener.properties
4. vi database.properties

-- remove all empty lines from database.properties

5. emctl start dbconsole

I folowed a similar approach for file instance.properties to avoid following error:

maxRowCount.pl: Tue Aug 21 14:37:56 2012: ERROR:  Max Count Value not set properly in file /u01/app/oracle/product/11.2.0/dbhome_1/sysman/config/esa/instance.properties line no. 69


The last two issues were generated by bug 5091502 - errors logged in file emagent_perl.trc for blank lines in database.properties, bug fixed in Oracle Management Agents 10.2.0.5.
But for my installation (10.2.0.3), the version of the agent was 10.2.0.4.4 that doesn't have a fix for the bug.


emctl status agent
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version     : 10.2.0.4.4
OMS Version       : 10.2.0.4.4
Protocol Version  : 10.2.0.4.4

Now console work fine.

2 comments: