{"id":12333,"date":"2017-07-17T18:07:45","date_gmt":"2017-07-18T01:07:45","guid":{"rendered":"https:\/\/ephesoft.com\/docs\/?p=12333"},"modified":"2022-02-28T09:06:12","modified_gmt":"2022-02-28T16:06:12","slug":"kb0017516-ora-01017-invalid-usernamepassword-logon-denied-ora-65096-invalid-common-user-or-role-name","status":"publish","type":"post","link":"https:\/\/ephesoft.com\/docs\/kb0017516-ora-01017-invalid-usernamepassword-logon-denied-ora-65096-invalid-common-user-or-role-name\/","title":{"rendered":"java.sql.SQLException: ORA-01017: invalid username\/password; logon denied SQL Error: ORA-65096: invalid common user or role name"},"content":{"rendered":"
Applies to: <\/b>All versions of Ephesoft Transact\u00a0<\/span><\/span><\/p>\n Transact won\u2019t start, and the following error appears in the <\/span>catalina.out <\/b>logs:<\/span><\/span><\/p>\n \u201cCaused by: java.sql.SQLException: ORA-01017: invalid username\/password; login denied<\/span><\/p>\n On further investigation, it was found that the database user was not created due to the error log:<\/span><\/p>\n \u201cORA-65096: invalid common user or role name\u201d<\/span><\/p>\n Detailed Error report:<\/span><\/strong><\/p>\n \u201cSQL Error: ORA-65096: invalid common user or role name<\/span><\/p>\n 65096.00000 –\u00a0 “invalid common user or role name”<\/span><\/p>\n *Cause: An attempt was made to create a common user or role with a name<\/span><\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span> that was not valid for common users or roles.\u00a0 In addition to<\/span><\/span><\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span> the usual rules for user and role names, common user and role<\/span><\/span><\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span> names must start with C## or c## and consist only of ASCII<\/span><\/span><\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span> characters.<\/span><\/span><\/p>\n *Action: Specify a valid common user or role name.\u201d<\/span><\/p>\n 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<\/span>. <\/span><\/i>Refer to the following <\/span><\/span>Oracle article<\/span><\/a> for more information.<\/span><\/p>\n 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.<\/span><\/p>\n As a workaround, update the database parameter COMMON_USER prefix.<\/span><\/p>\n 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.<\/span><\/p>\n You can find detailed steps to change the COMMON_USER prefix in the following <\/span>DBASolved article<\/span><\/a>.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":" Applies to: All versions of Ephesoft Transact\u00a0 Issue Transact won\u2019t start, and the following error appears in the catalina.out logs: […]<\/p>\n","protected":false},"author":54,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12392,12354],"tags":[1430],"yoast_head":"\nIssue<\/b><\/span><\/h2>\n
Root Cause\u00a0<\/b><\/span><\/h2>\n
Solution<\/b><\/span><\/h2>\n