Set Parameter in SPFILE still outputs the same error

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.

In the $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.

-Sruscht

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.

Method 1

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

https://help.sap.com/viewer/d77277f42c0b469db8794645abd954ea/8.0/en-US/571119cc37ce465b93de726fc0408427.html

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 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply