How to Fix 'ORA-65096: invalid common user or role name' Error

Issue Description

TIBCO JasperReports^® Server installation script js-install fails with

ORA-65096: invalid common user or role name

error.

What does the error mean and how to fix it?

Resolution

Installation script log showed that the process failed at Oracle Database user creation stage:

[advanced-sql] Failed to execute:  create user jasperserver identified by xxx

.....

[Oracle]ORA-65096: invalid common user or role name

This error is specific to Oracle 12c with CDB/PDB feature (a container database  which includes zero,one or many customer-created pluggable databases).

As stated in TIBCO JasperReports^® Server Installation guide, in such case Oracle username should be specified as c##username in default_master.properties configuration file:

https://community.jaspersoft.com/documentation/tibco-jasperreports-server-installation-guide/v71/installing-war-file-using-js-insta-0

Set parameter

dbUsername=c##jasperserver

in default_master.properties file and re-run install script.

Solution tested with TIBCO JasperReports^® Server v.7.1.0

Ref. Case 01659342