Home / server / Questions / 923623
In Process
DenCowboy
Asked: 2018-07-27 02:14:22 +0800 CST

Persist alter session set "_ORACLE_SCRIPT"=true; in Oracle 12c

  • 772

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.

docker

1 Answers

  1. I think you can write this setting permanently by writing : 

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

    see Oracle documentation

    • 1