KB Articles


KB Article # 17516

Topic/Category: Oracle

Issue: ORA-01017: invalid username/password; logon denied




From the catalina.out logs, Transact won’t start due to below error log:

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


On further investigation, it was found that 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

  1. 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


*Action:   Specify a valid common user or role name.


As configured database version is Oracle Database 12c Enterprise Edition Release – 64bit Production (Linux), a new parameter is added asCOMMON_USER_PREFIX. (https://docs.oracle.com/database/121/REFRN/GUID-516ADCCF-3661-4B54-908A-7041854EA14F.htm#REFRN10354)

By default this parameter value is set as C##. And the user configured is EPHESOFT_4130UAT1. Due to missing prefix of C## user creation was not allowed by the database .


As a fix/workaround, user need to update the database parameter COMMON_USER_PREFIX.

If 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.


Link to change the common name:



< Back|KB Main Page | Next KB Article >

Was this article helpful to you?

Walter Lee