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 APRIL 06, 2023

Applies to:

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

Symptoms

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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