You are running an Oracle-specific part of the acceptance tests. OpenACS does not have an official Acceptance test suite yet. We have to port ACS' sometime.
Just go into psql and do a "d" which should show you all table, sequences and views. That should be give you some good information showing that everything was loaded. Also, if you redirected your output when loading the datamodel (as described in the docs) you should be able to see if you had any errors righ there.