My Oracle Support Banner

Error 'ORA-01017: invalid username/password; logon denied' When Attempting to Configure Data Warehouse Using the 'Configstar' Utility (Doc ID 2300978.1)

Last updated on AUGUST 12, 2019

Applies to:

Primavera Data Warehouse - Version and later
Information in this document applies to any platform.


When attempting to create the data warehouse using the configstar.cmd (/.sh) utility with SEC_CASE_SENSITIVE_LOGON parameter set to FALSE, the following error occurs.

ORA-01017: invalid username/password;logon denied


The issue can be reproduced at will with the following steps:

  1. Launch a Command Prompt window and connect to the Oracle instance as sys or system "as sysdba".
  2. Set parameter SEC_CASE_SENSITIVE_LOGON to FALSE (ex. alter system set SEC_CASE_SENSITIVE_LOGON=false).
  3. Launch the configstar utlity (ex. C:\star_1\config.cmd).
  4. Provide the Oracle database connection details, system username and password, and staruser connection details.
  5. Leave Custom Tablespaces unchecked.
  6. Click Next.
  7. Observe the reported error.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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