2) The various services that require tables will build them automatically.
3) A few ways to check. First, remove the default-ds.xml file, and also remove the hsqldb JAR files (a search will find them). Second, look in the database after you start the appserver - you should see a number of tables created.
What you posted is the deployment report, it rarely contains any information about what the problem is. You need to scroll back and find the first exception stack trace and post that. Either that or look in the server log for the first exception stack trace for an ERROR log entry.
But here is a guess: Your Oracle datasource is not named DefaultDS. There are several services that depend on a datasource with that name. You will either have to change the name of your Oracle datasource to DefaultDS, or change all of the services that need DefaultDS to use OracleDS instead.
Please post your oracle-ds.xml file.
Also, please do not post a screen shot of the command prompt - instead, copy and paste the text.