The OpenACS datamodel defines a view called "dual" which returns a
single row with a column named "sysdate". Sounds familiar to
"oracleman", I bet :)
Anyway, the fact that "dual" does not exist is an indication that the
OpenACS datamodel hasn't been loaded, or failed miserably when you
tried to load it.
Is there any chance you loaded the data model into another database,
say the "postgres" database, rather than the "oracleman" database?
That's one possible explanation.