Run_service.sh and/or Set_repository_password.sql Script Execution Fail With ORA-29532 And ORA-28239: no key provided (Doc ID 419330.1)

Last updated on JULY 05, 2016

Applies to:

Oracle Warehouse Builder - Version 10.2 and later
Information in this document applies to any platform.


Symptoms

The run_service.sh and/or the set_repository_password.sql script execution fail with:

ORA-29532: Java call terminated by uncaught Java exception:
oracle.jdbc.driver.OracleSQLException: ORA-28239: no key provided

Additional error :

 

Changes

The database has been cloned - including the OWB repositories.
OWB tables have been manually updated to reflect the change of hostname/port/service name.

This is not a RAC configuration (refer to <Note 395037.1> in that case) unless there is a shared drive.

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