2

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.

1

I think you can write this setting permanently by writing :

alter system set "_ORACLE_SCRIPT"=true SCOPE=SPFILE;

see Oracle documentation

1
  • Have you try this? This doesn't even affect the current session.. How could it work for any other session opened in future? – Zé Carlos May 14 '20 at 21:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.