KB Article # 17516
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
- 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 18.104.22.168.0 – 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: