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 laterInformation 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:
- Launch a Command Prompt window and connect to the Oracle instance as sys or system "as sysdba".
- Set parameter SEC_CASE_SENSITIVE_LOGON to FALSE (ex. alter system set SEC_CASE_SENSITIVE_LOGON=false).
- Launch the configstar utlity (ex. C:\star_1\config.cmd).
- Provide the Oracle database connection details, system username and password, and staruser connection details.
- Leave Custom Tablespaces unchecked.
- Click Next.
- 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 |