All of that is indeed strange. For the first problem, it has been noticed recently that the Oracle translator file is incorrect in the ALTER statement for more than one modification at a time. This has been fixed for the next update, but if you want to change it yourself you can edit “…Program Files\Inductive Automation\FactorySQL\databases\Oracle.xml” and change the lines:
<AlterString>ALTER TABLE {tablename} {alterdef}</AlterString>
<AlterColumnDef>, ADD {colname} {type}</AlterColumnDef>
to…
<AlterString>ALTER TABLE {tablename} ADD ({alterdef})</AlterString>
<AlterColumnDef>, {colname} {type}</AlterColumnDef>
Ultimately, though, you have a much larger problem than that. Indeed it sounds like something has gone drastically wrong in the configuration.
In the install directory, you’ll find a “system_database.fdb” file. If you could, please email that to support AT inductiveautomation.com
In the mean time, to get the service up and running again, you can just rename that file (and restart the service). You’ll lose what you’ve done so far (until we can fix the file/problem), but at least you’ll be back up and running.
Regards,