Question:

Oracle Content Delivery CreateTridionSYSUser.sql errors

Sophie: 2 weeks ago

I have an Oracle 12.1.0.2 DB running on RHEL 7. As I understand it, the first step of setting up a CD delivery database is to create the TRIDION_SYS user.

When I log in to the db via sqlplus with "CONNECT SYS AS SYSDBA" and run the "@CreateTridionSYSUser.sql" script, the script fails with errors stemming from an error "ORA-65096: invalid common user or role name". What am I doing wrong here?

enter image description here

Answer:
Jayden: 2 weeks ago

For anyone else stuck with this, here's the solution.

Oracle 12c introduces multitenancy. With this architecture the Tridion Content Delivery database must be set up in the pluggable database rather than the container database that is the default when you first connect via sqlplus.

To switch to the pluggable database you will need to log in "sys as sysdba" and use the command alter session set container=pdborcl; to switch to the pluggable DB. You can then use the CD installation scripts, including the tridion_sys set up script to run the installation process.