KB0017516 – ORA-01017: invalid username/password; logon denied; ORA-65096: invalid common user or role name

Applies to: All version of Ephesoft Transact 

Issue

Transact won’t start, and the following error appears in the catalina.out logs:

“Caused by: java.sql.SQLException: ORA-01017: invalid username/password; login denied

Root Cause 

On further investigation, it was found that the database user was not created due to error log:

“ORA-65096: invalid common user or role name”

Detailed Error report:

“SQL Error: ORA-65096: invalid common user or role name

65096. 00000 –  “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.”

As the configured database version is Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production (Linux), a new parameter is added as COMMON_USER prefix. Refer to the following Oracle article for more information.

By default, this parameter value is set as C##. And the configured user is EPHESOFT_4130UAT1. Due to the missing prefix of C##, the database did not allow users to be created.

Solution

As a workaround, update the database parameter COMMON_USER prefix.

If the COMMON_USER prefix is set to an empty string, Oracle will not enforce any restrictions on the names of common or local users, roles, and profiles.

You can find detailed steps to change the COMMON_USER prefix in the following DBASolved article.