StarETL Process Fails With Error "ORA-01017: invalid username/password" When Creating Database Link (Doc ID 2214667.1)

Last updated on DECEMBER 22, 2016

Applies to:

Primavera Analytics - Version 15.1.6.0 and later
Information 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

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