10g Reports Problem
444825Jan 10 2006 — edited Sep 5 2006We have our application ported to 10g. After we run some reports the application server is throwing an error "REP-56055: Exceed max connections allowed: 20". We have tried increasing the maxconnect parameter in the $ORACLE_HOME/reports/conf/repservername.conf file and it works but again gives the same error after some time. Then we have to restart the reports server again. The problem what I feel is that once a report is run completely it is not getting disconnected from the reports server, due to which even if there is a single user running the reports then after the specified no of max connections the app server is throwing the same error.
Please give some suggestions.
Thanks in advance.