Apply/Generate DDL on Tools Fails With ORA-01017 If Password Contains Lowercase (Doc ID 2163294.1)

Last updated on JULY 07, 2020

Applies to:

Symptoms

On IP2016 Siebel Tools Client,

When Siebel Tools Client local database (Oracle XE) is initialized from DbXtract, password may contain lower case characters. However, 'Apply/Generate DDL' operation on Table object fails with the following error.

Following are  the steps to reproduce the issue.
1) Run DbXtract for client=EMP007
2) At Tools client login box, enter EMP007 as username and emp007 as password.
3) Initialization succeeds. Using SQL*Plus, make sure password is emp007 (with lowercase characters).
4) Using Tools connected to LOCAL_XE, add some extension columns.
5) Click 'Apply/Generate DDL' then 'Generate DDL'.
6) Provide necessary parameter then click 'Generate DDL' button.

** When the password emp007 was changed to EMP007 using SQL*Plus then performed the above steps, Apply/Generate DDL finished without error.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.