All we need is an easy explanation of the problem, so here it is.
for the installation of a SAP IDM system, I need to know how to use the command
alter system set "_ORACLE_SCRIPT"=true SCOPE=SPFILE; command correctly.
The installation creates a user and gives the error
ORA-65096: "invalid common user or role name". During the researches I found the command
alter session set "_ORACLE_SCRIPT"=true. This command allows to create users temporarly.
At the next session or in a separate terminal, this is no longer possible.
$ORACLE_HOME/dbs/spfile.ora the parameter
*_oracle_script=true was in there, but it gives me the same error again.
Thank you in advance.
How to solve :
I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.
Digging further: Your error indicates that you are using a container/pluggable database (CDB/PDB) architecture for your Oracle Database. The SAP IDM installation guide specifically says not to do this:
When installing the Identity Management database on Oracle, note the following prerequisites and recommendations:…
…make sure the Create as Container database option is not selected
Based on this, you will most likely need to recreate your database from scratch and make sure it is configured as a traditional instance, and not as container/pluggable database architecture.
Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂