My Oracle Support Banner

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

Last updated on AUGUST 24, 2020

Applies to:

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


**Any examples provided in this article do not represent real life personal/confidential information**

**Disclaimer:** This KM article may include the following abbreviations:

OUA - Oracle Utilities Advanced Spatial and Operational Analytics

ODI - Oracle Data Integrator

CCB/CC&B - Oracle Utilities Customer Care and Billing

DB - Database

ksh - KornShell


On : version of OUA

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

 - 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

The issue can be reproduced at will with the following steps:
Configure Source as per installation guide
Run ksh ./ -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




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.