Error: "ORA--01017: invalid username/password; logon denied" When Attempting to Create the Data Warehouse Using Configstar.cmd/.sh (Doc ID 2300978.1)

Last updated on SEPTEMBER 12, 2017

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 utility with parameter SEC_CASE_SENSITIVE_LOGON set to FALSE
the following error occurs.

ERROR
-----------------------
ORA--01017: invalid username/password;logon denied


STEPS TO DUPLICATE
-------------------------
The issue can be reproduced at will with the following steps:
      1. Launch command prompt and connect to oracle instance via sqlplus
      2. Set parameter SEC_CASE_SENSITIVE_LOGON to FALSE (alter system set SEC_CASE_SENSITIVE_LOGON=false)
      3. Launch configstar.cmd (i.e. C:\star_1\config)
      4. Provide the Oracle database connection details
      5. Provide the SYSTEM username and password
      6. Provide the STARUSER connection details
      7. Leave custom tablespaces unchecked
      8. Click NEXT and observe the error

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms