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:

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

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