KB Articles

 

KB Article # 17516

Topic/Category: Oracle

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

 

Solution:

 

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

           characters.

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

 

As configured database version is Oracle Database 12c Enterprise Edition Release 12.2.0.1.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:

https://dbasolved.com/2013/07/04/change-common_user-prefix-12c-edition/

 

< Back|KB Main Page | Next KB Article >

Was this article helpful to you?

Walter Lee

Comments are closed.