23 July 2003

The next version of Oracle will be called Oracle 10G, with the 'G' standing for Grid Computing. Oracle 10G is due to be formally launched at Oracleworld in September, but details of the new name leaked out recently when the Oracleworld Paris site was made public.Further details of other new features are only rumours at this stage, although this report at eWeek quotes "hyped speed, scalability that will support petabyte databases, enhanced XML database and Web services support, expanded clustering support, and additional grid-computing features." As with previous major releases of the core database, it'll probably be around June or July 2004 before we actually get our hands on a copy of 10G, and then with versions for Unix/Linux coming before Windows. Whilst some are concerned about the value of upgrading so soon after 9i, the fact that 10G is likely to include major improvments to management and reporting tools will hopefully make the upgrade seem more attractive. Me? I'm looking forward to the settling down of the new-to-9i Business Intelligence features, improved GUI tools for 9i OLAP, and further improvements to scalability, ETL and manageability for data warehousing projects. 6:58:30 PM

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. 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. Find the line <connection maxConnect="20" idleTimeOut="15"> Change the maxConnect value to something like "100" Restart your reports server, i.e. $ORACLE_HOME/dcm/bin/dcmctl restart -co OC4J_BI_Forms -v which fixed the error for me. 6:41:48 PM