Error Running Ksh ./configureSourceDB.sh For OUA 251 ODI ELT Component (Doc ID 2150836.1)

Last updated on JUNE 21, 2016

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.5.1.0.0 to 2.5.2.0.0 [Release 2.5]
Information in this document applies to any platform.

Symptoms

On : 2.5.1.0.0 version of OUA

When attempting to add source DB,
the following error occurs.

ERROR
-----------------------
 - 2016-06-10 12:16:45,732 [main] ERROR (obiu.odiautomation.BIDeploy) Package B1_OUAF_ADD_INSTANCE failed. Session Failed :113602 : ODI-1217: Session B1_OUAF_ADD_INSTANCE (113602) fails with return code 1017.
ODI-1226: Step B1_OUAF_ADD_INSTANCE fails after 1 attempt(s).
ODI-1240: Flow B1_OUAF_ADD_INSTANCE fails while performing a Loading operation. This flow loads target table B1_PROD_INSTANCE.
ODI-1227: Task SrcSet0 (Loading) fails on the source ORACLE connection CCB1.
Caused By: java.sql.SQLException: ORA-01017: invalid username/password; logon denied


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Configure Source as per installation guide
Run ksh ./configureSourceDB.sh -c <Source instance> -u <Source Golden gate owner schema name> -p < Source Golden gate owner schema password > -s <Source Application Schema> -r <Source Application Drill Back URL>

Above error reported in deployodi.log

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