StarETL Process Fails With Error "ORA-01017: invalid username/password" When Creating Database Link

Last updated on DECEMBER 22, 2016

Applies to:

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