Error Running Ksh ./configureSourceDB.sh For OUA 251 ODI ELT Component
Last updated on JUNE 21, 2016
Applies to:Oracle Utilities Advanced Spatial and Operational Analytics - Version 184.108.40.206.0 to 220.127.116.11.0 [Release 2.5]
Information in this document applies to any platform.
On : 18.104.22.168.0 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 ./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
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