Error OCIStmtExecute: Oracle error ORA-65096: invalid common user or role name when running ora_setup on SharePlex 8.6.2 or higher on Oracle 12c or higher (4297173)

Error OCIStmtExecute: Oracle error ORA-65096: invalid common user or role name when running ora_setup on SharePlex 8.6.2 or higher on Oracle 12c or higher

The following errors are observed when running ora_setup on SharePlex 8.6.2 or higher on Oracle 12c Pluggable Database (PDB) or higher version of Oracle PDB (shown in the example below):

Enter username for new user [splex/splex] :

SQL> CREATE USER splex IDENTIFIED BY splex

OCIStmtExecute: Oracle error ORA-65096: invalid common user or role name

Insufficient privileges

The error occurs due to insufficient privileges. It is most likely due to one of the following scenarios:

1.      The following privileges need to be granted by sysdba to the Shareplex user prior to running ora_setup in a multitenant database (here sp_admin is the SharePlex user in our example below):

create user c##sp_admin identified by sp_admin;

grant dba to c##sp_admin container=ALL;

grant select on sys.user$ to c##sp_admin with grant option container=ALL;

If they are not granted prior to running ora_setup, the error ORA-65096 will occur. To resolve it, grant the above privileges and then re-run ora_setup.

2.      Even though the privileges have been granted to a user who is purported to be the SharePlex user, if a different user has been specified during the running of ora_setup, it will fail with the ORA-65096. The most common reason for this to occur is when ora_setup prompts “if you want to create a new SharePlex user” and the customer replies in affirmative while not granting the above privileges prior to running ora_setup for a new user. Grant the above privileges to the SharePlex user and then re-run ora_setup.

The following excerpt from SharePlex Installation Guide delve on this requirement of granting the privileges: Required privileges to run Oracle Setup The user who runs Oracle Setup must have the following privileges: Non-multitenant (standard) database The user running SharePlex Setup must have DBA privileges, but if support for TDE is required, then this user must have SYSDBA privileges. Multitenant database It is recommended that the user running SharePlex Setup have SYSDBA privileges, but at minimum the user should be a DBA user with privileges for sys.users$ and sys.enc$. The minimum following grants are required for the SharePlex user: create user c##sp_admin identified by sp_admin; grant dba to c##sp_admin container=ALL; grant select on sys.user$ to c##sp_admin with grant option container=ALL; If TDE support is required for the CDB, then the following additional priviledge is required: grant select on sys.enc$ to c##sp_admin with grant option container=ALL; Here is the description of ORA-65096 ORA-65096: invalid common user or role name Cause: An attempt was made to create a common user or role with a name that was not valid for common users or roles. In addition to the usual rules for user and role names, common user and role names must start with C## or c## and consist only of ASCII characters. Action: Specify a valid common user or role name.