Oops! My first attempt at changing a silly query using the Oracle-ism "rownum" failed. It appears that the SQL92 variant I've replaced my first attempt with works...
bootstrapper can now load either the Oracle or PostgreSQL acs-kernel datamodel. It checks on-the-fly for which db is configured in the OpenNSD database pools allocated to OpenACS. Only acs-kernel is correctly self- configured at this point.