StarETL Process Fails With Error "ORA-01017: invalid username/password" When Creating Database Link
(Doc ID 2214667.1)
Last updated on DECEMBER 03, 2019
Applies to:
Primavera Analytics - Version 15.1.6.0 and laterInformation in this document applies to any platform.
Symptoms
When creating the database link (DSLINK), the StarETL process fails at step 16/59 with the following error:
ERROR
<12.12.2016 17:25:34> staretl [INFO] (Progress) - Step 16/59 Part 1/1 - [12/12/2016 17:25:34] StartProcess -- Start ETL Process
<12.12.2016 17:25:34> staretl [INFO] (Message) - === Step 16, Part 1 ====================================================
<12.12.2016 17:25:34> staretl [INFO] (Message) - === Start ETL Process
<12.12.2016 17:25:34> staretl [DEBUG] (Message) - SQL Plus(3) : [-s] [********] [@runscript.sql]
<12.12.2016 17:25:37> staretl [INFO] (Message) - BEGIN status_start_run('FULL'); END;
<12.12.2016 17:25:37> staretl [INFO] (Message) - *
<12.12.2016 17:25:37> staretl [INFO] (Message) - ERROR at line 1:
<12.12.2016 17:25:37> staretl [INFO] (Message) - ORA-01017: invalid username/password; logon denied
<12.12.2016 17:25:37> staretl [INFO] (Message) - ORA-02063: preceding line from DSLINK01
<12.12.2016 17:25:37> staretl [INFO] (Message) - ORA-06512: at "STARUSER.VALIDATE_DB_LINK", line 11
<12.12.2016 17:25:37> staretl [INFO] (Message) - ORA-06512: at "STARUSER.STATUS_START_RUN", line 34
<12.12.2016 17:25:37> staretl [INFO] (Message) - ORA-06512: at line 1
<12.12.2016 17:25:37> staretl [INFO] (Progress) - Step 16/59 Part 1/1 - FAILED (249) (0 hours, 0 minutes, 3 seconds, 370 milliseconds)
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 |
Cause |
Solution |