I think the problem is with your data source configuration in standalone.xml - there is an sql statement given which I think is not valid "SELECT 1" and thus the error ORA-00923: FROM keyword not found where expected.
Same probably happens when you undeploy task server war and try to use console only as console with build EntityManagerFactory on first access not as human task war which does that on server startup.
HTH