Dealing with “REP-56055: Exceed max connections allowed: 20″ Oracle Reports Error

If you're using Oracle Reports delivered as either a JSP or through the Reports Servlet, and you're getting the error "REP-56055: Exceed max connections allowed: 20", you need to increase the maxConnect value in the reports configuration file to a higher value.

  1. Find the file $ORACLE_HOME/reports/conf/repservername.conf

    where $ORACLE_HOME is your applications (not infrastructure) home, and repservername is your reports server name, i.e. rep_markr.
  2. Find the line <connection maxConnect="20" idleTimeOut="15">
  3. Change the maxConnect value to something like "100"
  4. Restart your reports server, i.e.

    $ORACLE_HOME/dcm/bin/dcmctl restart -co OC4J_BI_Forms -v

which fixed the error for me.