https://support.atlassian.com/confluence/kb/upgrading-confluence-to-711-fails-with-ora-00972/
Upgrading Confluence to 7.11+ fails with ORA-00972 | Confluence | Atlassian Support
Fix ORA-00972 when upgrading Confluence 7.11+ by checking Oracle compatibility mode and rerunning the upgrade.
upgradingconfluence