I have an oracle 12c (1.0.2) running in Docker. I'm using a script which is executed during container startup:
TESTER IDENTIFIED BY TESTER;
This fails with this error:
ORA-65096: invalid common user or role name
When I alter my script it works fine:
alter session set "_ORACLE_SCRIPT"=true; TESTER IDENTIFIED BY TESTER;
But I don't want to add this to every script. Is there a way you can persist this setting in the database?
Also in this doc they need to alter the session.