I recomend naming your pools to indicate which db they below to,
e.g. "pg_pool_1". It's not strictly necessary but helps keep things
clear.
If you want to use the multi-db support you should not be using the
"availablepool" syntax, it is there only for backwards compatibility.
So you are both correct to levae those availablepool lines out.
I don't know what the problem is, your config files look ok to me. I
haven't touched or looked at any of that code since
April 2003
though, so it's possible somebody broke it since then. Unfortunately
I don't currently have Oracle and PostgreSQL set up for testing, so I
can't test it myself right now.
What specific release of OpenACS are you using, the OpenACS 5.0.0b4
tarball? The multi-db stuff should work in all OpenACS 5.x
versions, but like I said I haven't actually tested it for many
months...