{"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

Issue<\/b><\/span><\/h2>\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

Root Cause\u00a0<\/b><\/span><\/h2>\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

Solution<\/b><\/span><\/h2>\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":"\njava.sql.SQLException: ORA-01017: invalid username\/password; logon denied SQL Error: ORA-65096: invalid common user or role name | Ephesoft Docs<\/title>\n<meta name=\"robots\" content=\"noindex, follow\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"java.sql.SQLException: ORA-01017: invalid username\/password; logon denied SQL Error: ORA-65096: invalid common user or role name\" \/>\n<meta property=\"og:description\" content=\"Applies to: All versions of Ephesoft Transact\u00a0 Issue Transact won\u2019t start, and the following error appears in the catalina.out logs: […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ephesoft.com\/docs\/kb0017516-ora-01017-invalid-usernamepassword-logon-denied-ora-65096-invalid-common-user-or-role-name\/\" \/>\n<meta property=\"og:site_name\" content=\"Ephesoft Docs\" \/>\n<meta property=\"article:published_time\" content=\"2017-07-18T01:07:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-28T16:06:12+00:00\" \/>\n<meta name=\"author\" content=\"lydiaxie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"lydiaxie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ephesoft.com\/docs\/kb0017516-ora-01017-invalid-usernamepassword-logon-denied-ora-65096-invalid-common-user-or-role-name\/\",\"url\":\"https:\/\/ephesoft.com\/docs\/kb0017516-ora-01017-invalid-usernamepassword-logon-denied-ora-65096-invalid-common-user-or-role-name\/\",\"name\":\"java.sql.SQLException: ORA-01017: invalid username\/password; logon denied SQL Error: ORA-65096: invalid common user or role name | Ephesoft Docs\",\"isPartOf\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\"},\"datePublished\":\"2017-07-18T01:07:45+00:00\",\"dateModified\":\"2022-02-28T16:06:12+00:00\",\"author\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/#\/schema\/person\/bca3e75d8d08163c3b26d530db9013d1\"},\"breadcrumb\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/kb0017516-ora-01017-invalid-usernamepassword-logon-denied-ora-65096-invalid-common-user-or-role-name\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ephesoft.com\/docs\/kb0017516-ora-01017-invalid-usernamepassword-logon-denied-ora-65096-invalid-common-user-or-role-name\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ephesoft.com\/docs\/kb0017516-ora-01017-invalid-usernamepassword-logon-denied-ora-65096-invalid-common-user-or-role-name\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ephesoft.com\/docs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"java.sql.SQLException: ORA-01017: invalid username\/password; logon denied SQL Error: ORA-65096: invalid common user or role name\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\",\"url\":\"https:\/\/ephesoft.com\/docs\/\",\"name\":\"Ephesoft Docs\",\"description\":\"Intelligent Document Processing Made Easy\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ephesoft.com\/docs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/ephesoft.com\/docs\/#\/schema\/person\/bca3e75d8d08163c3b26d530db9013d1\",\"name\":\"lydiaxie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ephesoft.com\/docs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b98869ec848ba0d1f0d43297973b9cd7?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b98869ec848ba0d1f0d43297973b9cd7?s=96&r=g\",\"caption\":\"lydiaxie\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"java.sql.SQLException: ORA-01017: invalid username\/password; logon denied SQL Error: ORA-65096: invalid common user or role name | Ephesoft Docs","robots":{"index":"noindex","follow":"follow"},"og_locale":"en_US","og_type":"article","og_title":"java.sql.SQLException: ORA-01017: invalid username\/password; logon denied SQL Error: ORA-65096: invalid common user or role name","og_description":"Applies to: All versions of Ephesoft Transact\u00a0 Issue Transact won\u2019t start, and the following error appears in the catalina.out logs: […]","og_url":"https:\/\/ephesoft.com\/docs\/kb0017516-ora-01017-invalid-usernamepassword-logon-denied-ora-65096-invalid-common-user-or-role-name\/","og_site_name":"Ephesoft Docs","article_published_time":"2017-07-18T01:07:45+00:00","article_modified_time":"2022-02-28T16:06:12+00:00","author":"lydiaxie","twitter_card":"summary_large_image","twitter_misc":{"Written by":"lydiaxie","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ephesoft.com\/docs\/kb0017516-ora-01017-invalid-usernamepassword-logon-denied-ora-65096-invalid-common-user-or-role-name\/","url":"https:\/\/ephesoft.com\/docs\/kb0017516-ora-01017-invalid-usernamepassword-logon-denied-ora-65096-invalid-common-user-or-role-name\/","name":"java.sql.SQLException: ORA-01017: invalid username\/password; logon denied SQL Error: ORA-65096: invalid common user or role name | Ephesoft Docs","isPartOf":{"@id":"https:\/\/ephesoft.com\/docs\/#website"},"datePublished":"2017-07-18T01:07:45+00:00","dateModified":"2022-02-28T16:06:12+00:00","author":{"@id":"https:\/\/ephesoft.com\/docs\/#\/schema\/person\/bca3e75d8d08163c3b26d530db9013d1"},"breadcrumb":{"@id":"https:\/\/ephesoft.com\/docs\/kb0017516-ora-01017-invalid-usernamepassword-logon-denied-ora-65096-invalid-common-user-or-role-name\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ephesoft.com\/docs\/kb0017516-ora-01017-invalid-usernamepassword-logon-denied-ora-65096-invalid-common-user-or-role-name\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ephesoft.com\/docs\/kb0017516-ora-01017-invalid-usernamepassword-logon-denied-ora-65096-invalid-common-user-or-role-name\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ephesoft.com\/docs\/"},{"@type":"ListItem","position":2,"name":"java.sql.SQLException: ORA-01017: invalid username\/password; logon denied SQL Error: ORA-65096: invalid common user or role name"}]},{"@type":"WebSite","@id":"https:\/\/ephesoft.com\/docs\/#website","url":"https:\/\/ephesoft.com\/docs\/","name":"Ephesoft Docs","description":"Intelligent Document Processing Made Easy","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ephesoft.com\/docs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/ephesoft.com\/docs\/#\/schema\/person\/bca3e75d8d08163c3b26d530db9013d1","name":"lydiaxie","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ephesoft.com\/docs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b98869ec848ba0d1f0d43297973b9cd7?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b98869ec848ba0d1f0d43297973b9cd7?s=96&r=g","caption":"lydiaxie"}}]}},"_links":{"self":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/posts\/12333"}],"collection":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/users\/54"}],"replies":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/comments?post=12333"}],"version-history":[{"count":2,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/posts\/12333\/revisions"}],"predecessor-version":[{"id":50397,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/posts\/12333\/revisions\/50397"}],"wp:attachment":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/media?parent=12333"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/categories?post=12333"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/tags?post=12333"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}